Notifications
Clear all
Topic starter
I have two tables in Airtable: one is named Skills and the other is Employee. My goal is to link multiple records from the Skills table to a single record within the Employee table.
Here's a breakdown of the process I'm following:
- I retrieve the record IDs from the Skills table.
- I intend to add these Skill record IDs to a linked field in the Employee table.
However, I'm facing an issue where some record IDs appear empty in both the Array Aggregator and Set Variable modules. This prevents me from linking all the intended Skills records to the Employee record.
How can I effectively link multiple Skill record IDs to an Employee record? Any guidance would be greatly appreciated.
The Update Record in Airtable action is returning the following error: Operation Failed with error
Posted : 02/07/2024 6:25 pm
Hi there. Welcome. I've set up a similar scenario and was able to achieve your desired output. Please follow these steps and let me know if you have any questions.
- Search your Airtable base for the necessary records using a formula.
- Filter between the Airtable search results and the array aggregator to prevent empty record IDs.
- Aggregate all record IDs from Airtable using the ID field.
- Search for the required employee in the Airtable search module. If you can share a full screenshot of your scenario, I can assist further, as I'm currently unsure where you're sourcing that variable from.
- Map the array of IDs from the aggregator into the link record.
- Ensure that your column in Airtable has this setting enabled.
Posted : 02/07/2024 7:42 pm
Topic starter
Hello! I'm encountering an issue where the Record IDs are not being written during the update process in my callin.io workflow. Could someone please point out where I might be going wrong?
-
Overall Workflow
2.Get the output from parse json
3.iterator over the parse json
-
Search with table which specific skills matches and get the IDs
-
Pass the ID to Set Variable to get the IDs using
{{map(135.array; “id”)}} -
Getting the Error While updating the Airtable Record ID
Posted : 03/07/2024 4:17 am
Please verify these initial points. This can be accomplished using the Airtable formula itself.
- Create a formula field and implement the formula
RECORD_ID() - Create a lookup field and choose your ID field as the lookup. This will present the record IDs of the linked items, separated by commas. Success!
If this approach doesn't suit your needs and you require performing these actions via callin.io, then within your iterator, utilize the filter when searching for employee skills. If no matches are found, use the continue command to bypass that record.
Kindly inform me if you continue to encounter errors.
Posted : 03/07/2024 6:04 am
