I have lockrow plugins in a joined list.
It nearly works, but in a kind of back to front manner!
The owner of an unlocked row receives the correct message when opening a form to edit ("This record is being locked for your use. Nobody else can edit this record till you submit it. The record will stay locked for 60 minutes. If you don't submit within that time, the record will become unlocked and editable others, and you will no longer be able to submit this form").
The locked padlock icon shows in the list view, for other users.
A second user also receives the correct message when opening the same "locked" form / row id. ("This record is locked by another user, you cannot edit it").
But, if the second user ignores the warning message, and saves the edited form, the form is submitted successfully, with the success message.
And when the original owner subsequently submits the open form, they receive the "Record locking is enabled on this data, but your submitted form does not have the correct lock token, so your form has not been submitted. Please contact the administrators. Sorry, but you are not authorised to edit this record" message.
When returning to the list view, the second user now owns the form (and can unlock the form with the padlock icon). And the locked padlock is displayed in the list view of original owner.
The plugin works as it is expected to in lists without joins.
Is there anyway to correct this?
Thank you
It nearly works, but in a kind of back to front manner!
The owner of an unlocked row receives the correct message when opening a form to edit ("This record is being locked for your use. Nobody else can edit this record till you submit it. The record will stay locked for 60 minutes. If you don't submit within that time, the record will become unlocked and editable others, and you will no longer be able to submit this form").
The locked padlock icon shows in the list view, for other users.
A second user also receives the correct message when opening the same "locked" form / row id. ("This record is locked by another user, you cannot edit it").
But, if the second user ignores the warning message, and saves the edited form, the form is submitted successfully, with the success message.
And when the original owner subsequently submits the open form, they receive the "Record locking is enabled on this data, but your submitted form does not have the correct lock token, so your form has not been submitted. Please contact the administrators. Sorry, but you are not authorised to edit this record" message.
When returning to the list view, the second user now owns the form (and can unlock the form with the padlock icon). And the locked padlock is displayed in the list view of original owner.
The plugin works as it is expected to in lists without joins.
Is there anyway to correct this?
Thank you