I'm trying to limit a user's ability to click the same trigger link multiple times, but having a hard time finding a value I can use as a condition.
I have a members table (accounts), a jobs table of volunteering opportunities and a table for Jobs-Volunteers to hold a list what members volunteered to do each job. I have a link on the jobs page that triggers a new record to be added to the Jobs-Volunteers table when a member wants to volunteer to complete a job. My challenge is in figuring out how to prevent a member from clicking the link more than once.
I thought I'd be able to create a text formula field in Jobs-Volunteers that combines the job with the account number and enforces uniqueness. But since both Job and Volunteer fields have a many-to-many relationship, with their corresponding tables, these values are not available to me in formulas.
So, how can I enable a user to click the "I'll do it" link one time and prevent additional clicks of the link by the same user from creating additional new records?