I’m trying to build an automation so that if I put ‘Regular’ in the ‘type’ column in the bookings table it will automatically populate the ‘populate issues’ column in the same table with all the entries in a list (‘issue date’) from the ‘Issues’ table. I can’t work out how to build this automation and get a ‘Received invalid inputs’ error. Can anyone help?
Hm assuming your end goal is for that ‘Regular’ record to be linked to all the found records, then you could do this instead and I’ve set it up here for you to check out:
And this is what it looks like in action:
The record ID is the triggering record’s ID:
And the linked field is populated with the IDs of all the found records:
This is amazing - thank you so much Adam. I spent hours trying to work out how to do this and was about to give up - really appreciate your help! Can I just check - will the issues field in table 1 update automatically if the issues are changed in the column/table it pulls from?
Hmm, data changes of linked records will show up automatically via lookup / rollups, but the links themselves won’t change I’m afraid. What would be changing on the issues side?
I do free half hour calls and would be happy to jump on a quick Zoom with screenshare to try to help too!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.