Share
Report
18Hello,
I need the submit button to do 3 things (4 actually but haven't figured out how to do the 4th item yet).
1) Error out if the user tries to submit an entry for someone else. (That's working fine.)
2) Refresh the form. (That's also working fine.)
3) Add the new entry to the users main page data table.(Not working) I'm using the Collect function to add it to the users Collection, but every time I add this formula my insert form disappears from my Insert Screen.
4) I'd also like to add another error to prevent an individual from submitting an entry for a day they have already have an entry for a given date in the system. I've come across UpdateIf, so I guess I'm looking for Not UpdateIf conditions X & Y occur (date and email match)
Please see the screenshots for the data table, formula, and what happens when I add Collect etc.
All responses (
Answers (
