Link to home
Start Free TrialLog in
Avatar of Hiroyuki Tamura
Hiroyuki TamuraFlag for United States of America

asked on

lock record and field data filemaker

I made an invoice system and customer looking for locking invoice data.
I guess they want to disable delete button for the locked data.
Is this possible?
Avatar of Member_2_908359
Member_2_908359
Flag of France image

plenty of ways to do this.
first have a field to store the locked state.
then you can do a script to access the layout which allows editing if the locked field is empty for instance.
you can also play with the validation feature of the field, but this has to be made on every field of the table. quite a lot of work.
you can also allow records edition/deletion in the account privileges, based on a certain field content, ie the locked field.
Avatar of Hiroyuki Tamura

ASKER

thank you, lesouef.
do you think i can make a lock button, once user push then the record and related record lock?

> first have a field to store the locked state.
> then you can do a script to access the layout which allows editing if the locked field is empty for instance.
do you think we can hide delete button on the menu bar?
ASKER CERTIFIED SOLUTION
Avatar of Member_2_908359
Member_2_908359
Flag of France image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thank you, lesouef!