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!