Hello FileMaker Community,
I am new to this program (using version 17) and am looking for help. I am creating a database of product testers.
I want to tie a field (Dog 1 - Harness Size) to a size measurement (Dog 1 - Girth ")
The goal is that the Harness size will automatically populate with text (XXXS, XXS, etc.) when a value is input into the Girth " field,
9-13 = XXXS
14-17 = XXS
I'm guessing Dog 1 - Harness Size needs a calculation. But I don't know how to write it.
If anyone can teach me what calculation to use, I would really appreciate it.