Feb 27th, 2013, 7:01 AM
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:
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.
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.
