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





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.






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