Does anyone know how to lock a record for a minute...
# generalt
ted_p
11/29/2023, 6:59 PMDoes anyone know how to lock a record for a minute for just the user that created it or for a certain role? We have some workflows that run to update fields on a sales order after creation (syncs to other systems) and we don't want edits from users in a small time frame.
c
Castor
11/29/2023, 7:01 PMIs it a custom record or normal record?
t
ted_p
11/29/2023, 7:02 PMnormal sales order (with custom form of course)
c
Castor
11/29/2023, 7:02 PMCould probably schedule a workflow, or as the last action on system updates unlock it after the last update is made
Castor
11/29/2023, 7:03 PMCustom records have optimistic locking as an option
Castor
11/29/2023, 7:03 PMi.e. you lock the record except to admin
Castor
11/29/2023, 7:03 PMyou finish your edits
Castor
11/29/2023, 7:03 PMthe last update is unlocking the record
t
ted_p
11/29/2023, 7:04 PMHow does it determine a start/finish of editing? Basically, our system syncs with another and will read/write (using a role we created for it).
c
Castor
11/29/2023, 7:05 PMthe record is locked (except to your created role and admin)
Castor
11/29/2023, 7:05 PMthen do a saved search with a checkbox that unlocks it after 15 minutes
Castor
11/29/2023, 7:05 PMis probably simplest
t
ted_p
11/29/2023, 7:06 PMyeah, I wish the saved search workflow had more lengths of time. It would be much more versatile if it wasn't 15 min, 30min etc
c
Castor
11/29/2023, 7:06 PMright, time is not easy...
Castor
11/29/2023, 7:07 PMhence why your "last update" which if it's a certain status, could also be the unlocking function
3 Views