AnsweredAssumed Answered

Calculation Options to field based on user input

Question asked by MattW_1 on Sep 28, 2015
Latest reply on Sep 28, 2015 by MattW_1

I have a filemaker database with a field labeled “Part #”. The data in that field might be 12 digits long.  I’m trying to make a separate radio button option that gives the user two options that will change the “part #” fields data already typed by the user.

 

Value Option #1 (UPC)

Will remove all digits but digits 7-11

Middle ( Part # ; 7 ; 5 )

 

Value Option #1 (MASTER)

Will remove all digits but digits 9-13

Middle ( Part # ; 9 ; 5 )

 

I’m lost on how to have these two calculations as options to the user and also change the data in the Part # field. I also need it compatible with Filemaker GO. Thanks!

Outcomes