+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: Client accessing record alert. Is this possible? (/showthread.php?tid=2390)
Client accessing record alert. Is this possible? - EdgarAllenPoe - Feb 27th, 2013
Hello all,
I have set up Form Tools using internal forms to aid in a phone questionaire campaign that I am running.
There is a "bank" of callers who select from the list on the "Submissions" page a person to call.
This sends them to the "Edit Submission" page where they enter the answers to the questions listed there and then "Update" the submission.
OK. Here is my question. Is there a way that I can allow only one person at a time to access a record? The danger in the way I have it set up is that two or more people could conceivably view and update the same record.
There are two results that would achieve this:
- Remove records being accessed by someone from the list on the "Submission" page while the record is being accessed.
- Show a Warning message on the "Edit Submission" page alerting the user that this record is already being accessed.
Are either of these possible? If so how? I am familiar with PHP and HTML, I just am rather weak on mysql queries and the use of FormTools' Hooks Module. Any help would be appreciated.
RE: Client accessing record alert. Is this possible? - Joe - Feb 27th, 2013
Hello,
Sorry, Form Tools does not have a feature to lock a record while another user is editing it.
Show a Warning message on the "Edit Submission" page alerting the user that this record is already being accessed would be the easier of the two solutions to implement. You would basically need a way to track when a record is being access.
Just a note, that what you need to achieve is possible it will require quite a bit of work to customize Form Tools to do this.