AnsweredAssumed Answered

Value to Text Automatic Formatting

Question asked by andydob27 on Jul 17, 2018
Latest reply on Jul 17, 2018 by philmodjunk

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

18-22= XS

23-27=S

28-32=M

33-42=L/XL

 

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.

 

Thanks,

 

Andy

 

Screen Shot 2018-07-17 at 8.02.53 AM.png

Outcomes