Jump to content

Disable data change on field value


This topic is 2737 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hi,

I've a solution with FilemakerGo where the users insert data. When all data is inserted, the user clicks a button which sets the field "lockRecord" to "Y" and from now on, changes should be avoided. I tried the following solution, that I inserted a rectangle control on top over all fields, and set the "Hide object if" to lockRecord unequal to "Y". This works fine as long as the rectangle control has a background-color. But in this case, I can't see the underlaying fields anymore ;-) When I set the background-color to transparent, I can see all fields with values, but changing of the field values is still possible ;-(

How can I do this? 

Thanks, Hans

Edited by JoP
Link to comment
Share on other sites

Hi Hans

One technique is to have each field in your layout twice, one of which has the 'Allow data entry in browse mode' turned on, and the other turned off. Then you just show and hide these two fields appropriately based on your lockRecord flag.

Alternatively you could have two layouts and when your user changes record, use a layout ScriptTrigger (OnRecordLoad) to switch to an 'editable' or 'non-editable' layout appropriately.

I know of no more elegant ways to achieve this, but someone on the forum may have something!

Link to comment
Share on other sites

  • Newbies

Thanks for all replies. Now I created a custom privilege set where I changed the Edit and Delete capabliities to ‘Limited’ and set the formula to IsEmpty(lockRecord) OR lockRecord unequal to "Y".

Link to comment
Share on other sites

This topic is 2737 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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