Skip to main content

I'm trying to set up an Airtable automation that's not working as expected.

Here are the details:

Current Setup
1. Trigger: When a record matches conditions
- Quote_Date_String is not empty
- Axonaut_Status is "accepted"

2. Action: Find records
- Where Quote_ID matches Quote_ID from trigger

3. Action: Update record (in a "Repeat for each" loop)
- Table: Landing_Table
- Update Quote_Date_String field

Error:
Getting "Received invalid inputs" when testing the automation, even though the test step shows valid data in the trigger record.

Screenshots of the automation and test results are attached.
Any help identifying why the update action is failing would be greatly appreciated.

Regards,
Hugo

It’s because you’re trying to update the entire list of record IDs in your “update record” step, but you can only update ONE record ID at a time. So in your update record step’s record ID field, you need to choose “current item” on the left and then “Airtable Record ID” on the right.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld 

Try updating your 'Update record' action with these settings:

Reply


Terms & Conditions