5 Replies Latest reply on Sep 28, 2015 6:22 PM by MattW_1

    Calculation Options to field based on user input

    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!