Jump to content
Sign in to follow this  
mike bell

Calculation Modification

Recommended Posts

I have a field that is a calculation.

And is set in the layout as a Pop-Up List.

Can I modify the Pop-Up List without getting the error "This field is not modifyable"?

What I am trying to do is this:

I have to database files. One is jobs.fp5 and the other is to_do.fp5. Both, have a status field, which are pop-up lists with values: incomplete, in progress, in print, received, etc..

I want to be able to be in either file, make the change to status and have the other files pop-up list change as well. I could do it with a script, if I have both files opened side by side then it doesn't display until a button is pushed.

Any help would be greatly appreciated.

Michael

Share this post


Link to post
Share on other sites

You can only "change" a calculation field by editing one of the fields that the calculation is based upon. If the calc was:

If ( isempty( field ) ; "no" ; "yes" )

...the only way to change the calculation result is to change the value in "field".

Formatting a calculation field as a list or menu won't change the fact that it can only be changed by editing one of the fields that the calculation is based upon.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.