Jul 19, 2023 05:47 AM - edited Jul 19, 2023 05:55 AM
(Thank you in advance! I swear I've tried everything I could find here and no luck)
I'm running a (successful) Create New Record automation from a Synced table, so my teammates can use the source data to develop their own additional work (but not adjust the source data itself). Yes, it duplicates a record -- but it's the only way I can deliver the starter content and let them build on.
Next step is to run an Update Record automation, so when:
Trigger (successfully finding the updated records in Source data) & Actions ("received invalid inputs") screenshots attached.
Solved! Go to Solution.
Jul 19, 2023 06:02 AM
It looks like you’re missing the Find Record step.
When a record is updated in the Database (auto-updates!), you need to first find the record in the YOUR Do Less Database that has the same song name as the update record. Then you use the RecordID of the found record in the YOUR Do Less Database as the RecordID that gets updated.
Jul 19, 2023 06:02 AM
It looks like you’re missing the Find Record step.
When a record is updated in the Database (auto-updates!), you need to first find the record in the YOUR Do Less Database that has the same song name as the update record. Then you use the RecordID of the found record in the YOUR Do Less Database as the RecordID that gets updated.
Jul 19, 2023 07:52 AM
I don't know what magic you possess, my friend, but the way you worded this WORKED for me. I'd been so close (yet so far). Thank you!
Jul 19, 2023 08:54 AM
Happy to help. Sometimes we all get lost in the automations. 🤣🤣🤣