Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
Your issue is that you want to create these Attendance records quickly and not one by one. There are a variety of ways to do this with URL formula button, but i will start with a pure no code solution.
Make a check box field on the Students table called [Record Attendance]. Also make a formula date field called Today with a formula of Today(). Not surprisingly it will calculate to today's date. :)
I suggest setting up a table with one record in it to fire the Automation. When the user is ready to record the Attendance they will edit a field on that table, say a checkbox field to start the Automation.
Then set up an Automaton to fire and do a COPY records process when the Trigger record is modified and the Trigger checkbox is checked.
Map the Record ID# field into the field for [Related Student]
Map Today into the date field.
That's it.
So the user would view a list of students and then use Grid Edit to update any changes from the last day.
Then save the student list.
Then trigger the automation by editing the trigger record to check the checkbox.
The next day the user will need to uncheck the checkbox to get ready to check the checkbox again to fire the Automation.
So you can start with that and then it can be made fancier with say a formula URL buttonn to trigger the Automation.
Make a check box field on the Students table called [Record Attendance]. Also make a formula date field called Today with a formula of Today(). Not surprisingly it will calculate to today's date. :)
I suggest setting up a table with one record in it to fire the Automation. When the user is ready to record the Attendance they will edit a field on that table, say a checkbox field to start the Automation.
Then set up an Automaton to fire and do a COPY records process when the Trigger record is modified and the Trigger checkbox is checked.
Map the Record ID# field into the field for [Related Student]
Map Today into the date field.
That's it.
So the user would view a list of students and then use Grid Edit to update any changes from the last day.
Then save the student list.
Then trigger the automation by editing the trigger record to check the checkbox.
The next day the user will need to uncheck the checkbox to get ready to check the checkbox again to fire the Automation.
So you can start with that and then it can be made fancier with say a formula URL buttonn to trigger the Automation.