Dec 02, 2022 09:41 AM - edited Dec 02, 2022 09:43 AM
I wrote a simple script to calculate the unmet needs of a particular product based on the status of orders.
And the script has successfully found the result: Sum 7
Then I ask airtable to update the corresponding record field "Amount in Need," which is a "number(int)" .
As you can see, the system found the correct record, yet it threw an error: received invalid inputs.
This is confusing.
What did I do wrong?
Dec 02, 2022 11:07 AM
What value are you passing into the Record ID for the automation to update?
Your screenshot just barely cut it off.
Take a look and ensure you're passing it the correct variable or value.
Issues with the record ID are my main culprit when an automation throws me this error.
Dec 02, 2022 02:16 PM
I’m passing a number 7 to a number field “Amount in need”.
That’s why it surprised me
Dec 05, 2022 04:28 PM
I‘m still stuck here. Any help?
Dec 08, 2022 01:23 PM
Hi John! To echo Ben on this, based on what I can glean from the screenshot of your action step, it looks like you’re using a linked record to reference text within the box reserved for Record ID. The record ID is a unique hash that is assigned on the backend, and it must reference the IDs of the records you’re intending to update.