Help

Update record action failing - "error: received invalid inputs."

Topic Labels: Automations
Solved
Jump to Solution
2843 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Olu_Adebajo
5 - Automation Enthusiast
5 - Automation Enthusiast

I’ve set up an automation that consists of a trigger (which works), a script to get the automationTime (which finally outputs the current date in ISO format), and an Update Record Action (which should capture the outputted Date—from the script—and input it into an empty Date Field of the same format).

I don’t know why it’s failing, and what invalid input it’s referring to. Some assistance would be greatly appreciated.

Please see screenshot attached for reference.

Thank you!

Screen Shot 2022-03-02 at 11.08.45 AM

1 Solution

Accepted Solutions
Olu_Adebajo
5 - Automation Enthusiast
5 - Automation Enthusiast

@ScottWorld your suggestion was actually very helpful, and a simpler option than what I had there before, so thanks for that.

The reason why it wan’t working altogether was because I placed a field (Experiment Code) in the Record ID input field. After @Courtney took a look—she pointed it out and my automation was finally good to go!

Cheers! @Airtable community is strong! :muscle:t5:

See Solution in Thread

4 Replies 4

I don’t know how to solve your particular problem, but are you simply trying to put today’s date into a date field?

If so, you could just create a formula field with the function TODAY(), and then in your automation, tell Airtable to update your date field with that formula field.

Thanks so much for your reply. I tried your suggestion, but it looks like the error is persisting. Have I applied it correctly?
Screen Shot 2022-03-03 at 10.04.48 AM

Not sure, but I would try re-testing the trigger and then re-testing the action.

Olu_Adebajo
5 - Automation Enthusiast
5 - Automation Enthusiast

@ScottWorld your suggestion was actually very helpful, and a simpler option than what I had there before, so thanks for that.

The reason why it wan’t working altogether was because I placed a field (Experiment Code) in the Record ID input field. After @Courtney took a look—she pointed it out and my automation was finally good to go!

Cheers! @Airtable community is strong! :muscle:t5: