All,
I am trying to create a simple automation that for some reason, wont work. On my “Trips” table I have a date submitted field. When this field is populated, I want all the corresponding expenses that are listed on the “Receipt Log” table to be updated with a submission date.
I created a view on my Trips table to show all records that have the date submitted field populated and I use that view as my trigger. I then do a “Find Records” action that shows all the expenses that have the same “trip name” as the trips in the view. The find records is working perfectly.
I then created an Update Record action and using the Airtable Record ID from the Find Records. But when I test this action out, it continues to fail saying “invalid input”.
I can’t figure out why.
Appreciate any suggestions,
Kevin
