Lock Record When In Use

[humbabba]

Hi,

 

Forgive me if I've missed it in the documentation. Looking for a way to lock a record when another user is editing it. To prevent simultaneous updates to the same record.

 

Thanks

[svitlanataran]

Hi, as far as I know, you can't lock a record while editing is in process. 

 

But I can recommend you to create a log report to control changes:

http://howto.caspio.com/tech-tips-and-articles/parameters/how-to-create-a-one-to-many-relational-datapage/

Also you can watch a video:http://howto.caspio.com/getting-started/create-a-one-to-many-relationship/

 

You can stamp time of editing http://howto.caspio.com/tech-tips-and-articles/common-customizations/stamp-the-time-url-or-ip-address-to-new-and-updated-records/  and you can take user name from authenticated fields: http://howto.caspio.com/authentications-and-connections/authentication/stamp-a-record-with-user-profile-data/

 

Take a look at the live version: http://www.caspio.com/contact-management/

This ready made application use this feature. 

[LWSChad]

A work around.

 

Setup:

1.  Create a new field to your table. Perhaps - checked_out_by
2. User clicks edit
   1. Update Data Page with the Auto-Submit script found ->> http://forums.caspio.com/index.php/topic/4314-js-auto-submit-a-datapage (optional)
   2. Check if the record wanted to be edited is currently checked out.
      1. If checked out => is it checked out by the current user?
         1. If checked out by the current user => direct to edit DataPage
         2. If checked by a different user => direct to display only DataPage
      2. If not checked out => direct to edit DataPage
   3. If the user is directed to the edit page, have this form (that does the checked out check) update the "checked_out_by" to the current users' email address (or other unique id)
3. On this edit Data Page....
   1. Include a hidden field with a default of "checked_out_by" = "not checked out" or NULL or whatever you want.
   2. When the editor submits their edits - it will become unchecked out. 
      1. If the user doesn't submit the page, the record will remain checked out. They will have to come back and un-check it out for others to be able to edit it.

I hope this helps

[aam82]

cool

[humbabba]

Thanks, ezIQ, that'll do!