3 Replies Latest reply on Dec 9, 2013 1:51 PM by philmodjunk

    Container Field Calculation error ( "Field not modifiable")

    ScottSpencer

      Title

      Container Field Calculation error ( "Field not modifiable")

      Post

           I have been out of FM for awhile - so my own troubleshooting is at a loss and it seems that any of the forum posts don't cover (or maybe answer my problem).

           I have been tinkering with my own version of the "Assets" DB provided with FM 13. I am trying to replicate the photo container option where you click on an image and it puts it up in the bigger container through a simple calc.  

           I think all my data is right - and I get the message "This action cannot be performed because this field is not modifiable."

            

           I have changed permissions in the system, the file and the database, even made sure my settings replicated to FM template. At least I think I've caught it all.  Still get the same message.  I must be missing a step and hope someone knows what I've not done... 

            

           Thanks!

           Scott

        • 1. Re: Container Field Calculation error ( "Field not modifiable")
          philmodjunk

               This error message can be tripped through one of two actions:

               In File Options, "Prohibit modification of value..." has been selected on the Auto-Enter tab for the field that your action is trying to modify.

               The field you are attempting to modify is of type calculation.

               File and account permission settings will not produce this precise error message.

          • 2. Re: Container Field Calculation error ( "Field not modifiable")
            ScottSpencer

                 The field is a type of calculation.  I've gone into the template, studied it - even changed names of fields to get a feel of how the script works.  

                 The source field is a container (photo), which, when clicked gets dropped into a larger "display container - which is a calculated field. 

                 It's all driven from a button assigned to the source container field.  "when clicked, make picture bigger".   

                  

                 While I can drop my photo in the source container, when I click on it and it triggers the scripts, no dice.  I get the message.   

                 Is it possible that I have some fields missing that are in the template that I should have? I can't see what steps I've missed. 

            • 3. Re: Container Field Calculation error ( "Field not modifiable")
              philmodjunk

                   To modify the data shown in a calculation field, you cannot use this script step:

                   Set Field [YourTable::calculationfield ; Some expression goes here]

                   You'll get an error every time.

                   To modify what is shown in the calculation field, you have to modify one of the fields referenced in the calculation. Using simple number fields as an example.

                   If your calculation field, Field C, is defined as:

                   Field A + Field B

                   Then

                   Set FIeld [YourTable::Field C ; 6 ]

                   will not work.

                   But you can use either

                   Set field [YourTable::Field A ; 3 ]

                   or

                   Set FIeld [YourTable::Field B ; 2 ]

                   (Or Both) to change the results shown in the field.