*Has anyone found a way to run a check during the submit form process off another object? As in I want to create a record in a registration object, but want to first check the count field in the shift object one more time.
We have a scheduling app with two objects, one that holds registration records of each instance of a staff registering for a shift (many → 1), and one that holds records of each shift (1-> many). The shift records can connect to more than one registration record. There is a count field in the shift object that is counting the number of records connected to it from the registration object.
We’re having trouble stopping folks from creating a registration record when there are no longer any spots left (count field in shift object is at 0). The view for the submit button on the form to create a new record is hidden by a page rule if the count field is at 0, however, if two staff open the page at the same time, the registration button will appear for both of them and both are then able to create a new registration.
Thanks for the HELP!