I have a table where users enter their leave requests including Name, StartDate and EndDate.
When the request is approved I need to take that single record and add one record for each Weekday of the leave period to another table (Inputs).
To accomplish that I want to set up the following series of Actions when a supervisor approves the leave request:
Set the Selected By field in the Leave Requests table to USEREMAIL() to identify the record that’s just been approved
Sets the value of the Date field on Row 2 of the Dates table to the Start day of the leave period that’s just been approved (Dates is a spreadsheet that lists week days starting from the date entered in Row 2)
Perform an AddRecord action for each row in the Dates table, Filtered to only include dates up to the EndDate of the Leave Request record
The AddRecord action adds the required record to the Inputs table
Reset the Selected By field in the Leave Requests table to blank
Essentially I think I have worked out each of the steps and tested steps 1 & 2. I wanted to test the sequence by creating a grouped Action but it looks like I can only run a grouped action if all the Actions originate from the same table.
Is there any way around this, or do I need to go back to the drawing board again?