Hey all - I need your help
Basically - am trying to create an expense reimbursement form that will then create an automated email to trigger approval/payment.
I have created a form in Fillout that has a form and a sub-form. Users can use the sub-form to input 1 or more items to their submission. Once filled out and submitted it gets ported over to Airtable. (all good - this works)
What I originally wanted to do was to have it take all the records that are created in Airtable from Fillout consolidate into a different table with a roll-up field to get the total payment needed. (for example, if you have 3 items for reimbursement, fillout creates 4 records in Airtable - 1 for each item and 1 for the overall form info). However, I had to create a workaround because the info for each item for reimbursement was being ported over to Airtable from Fillout immediately upon creation.
The workaround I created was to add a trigger at a time (like every hour) that will consolidate all the items into the other table where the roll-up happens.
HERE’S THE ISSUE - I can’t figure out how to create the automation to update the record.
- I have a field with a check-box - I have created an automation that once that check-box is checked, it runs the consolidation - that works really well.
- What I want to do is to create an automation that will automatically check that box if it’s unchecked at a certain time interval.
- sounds easy, but, I keep getting an error that says “Received invalid inputs.”
Here’s some screen shots (please let me know if you need to see anything else):
Thank you so much in advance - it’s driving me crazy!
