4 Replies Latest reply on Apr 19, 2013 10:25 AM by PaulWebb_1

    Possible to make a field manual and a calculation?

    PaulWebb_1

      Title

      Possible to make a field manual and a calculation?

      Post

                FM Server 12 Adv

                FM Pro 12 Adv

                 

                I have a table where all of the data is pulled in via an ODBC import script nightly. Every time the script is run it updates existing records and adds new records. The users do not create any records and they cannot modify any of the imported fields. There are 12 fields that need to be modifiable for the users. For those 12 fields I created duplicate fields and named them v_DuplicateName. On the layout I stacked the two fields and using conditional formatting hide or show the modifiable field.

                 

                Now that I have that, I created another field called Verified (calculation) and on the layout I use a checkbox. The calculation is a Case function that if one of the fields above is modified it adds a check in the checkbox. So far everything works.

                 

                I need to make the field 'Verified' manually modifiable. So that if I look at the record and everything is ok I can check the box. Or if I change one of the 12 fields it automatically adds a check. Looking for ideas on how to acomplish this. Thanks!

           example file located in thread below in Tech Net

      https://fmdev.filemaker.com/message/112785#112785