I have an app running on an Airtable base. It tracks (data entries by employees): employee timesheet entries, accomplishment of specific commissionable actions and rewards for receiving 5-Star Reviews (entries by Admins). That’s 3 different sets of data.
A Payroll Calculations table combines information from all three sources to determine an employee’s pay for a given Pay Period (which is Week # - Sunday to Saturday). So, when an employee makes a Timesheet Entry, a row is created in the Timesheets table the following values are to be passed to the Payroll Calculations table:
-
Employee Name
-
Time entry Start Date and Time
-
Time entry Stop Date and Time
When an employee makes a Timesheet entry from an iPhone, the new record is created in the Timesheets table. I’d like it to also to create a record in the Payroll Calculations table and update corresponding fields (Employee Name, Start/Stop Date and Time). Should I create a custom action as part of the Upon Submit routine?
If not, what suggestion would be easier/better? I’d like the same thing to happen in the Payroll Calculations table when records are created in the other (Commissionable Actions and 5-Star Reviews) two data source tables.
Thanks in advance for any guidance provided.