Hi All, I’m new in a game and hit the wall with the following. I have two tables in airtable (fixtures, standings). The data comes from 2 API via http get data modules. In fixture table i want to look up values for home/away teams from standings table eg. rank, form etc. When i change field type in airtable to"link to another record’ Make’s airtable create a record module gives an error of “[422] Value is not an array of record IDs.” I would appreciate any tips. TIA!
Hello @PanoStudio and welcome to the Make Community!
That error indicates you mapped in something other than an array when it was expecting an array as input. Could you please open your Airtable Create Record module and take a screenshot of this field and what is currently mapped into it? Whatever it is, it needs to be transformed to an array first.
You can use output from an array aggregator, or use functions like map(), add(), or merge() or others to create an array depending on how your data is set up here.
This happens because the field that links the fixtures table to the standings table expects actual record identifiers. When a new fixture is created, it needs the correct standings records ID.
Solution:
Add a Airtable Search Records module before creating the fixture. Search the standings table for the matching team record, then map the record identifier from that search into the linked record field during creation. This gives Airtable the array of identifiers it needs and the record will be created correctly.
If you need further assistance, please provide the following:
1. All Relevant Screenshots
We need to see what you’re working with to give you the best advice. Screenshots are extremely important because Make is a visual editor — a picture provides us with more context.
It would help us identify the issue by having screenshots of:
the full scenario,
the zoomed in section of the scenario that you are referring to (if your scenario is huge),
a full scenario run/execution (showing output “speech” bubbles),
any error messages,
individual module fields,
relevant filter settings (conditions), and
each module’s output bundles
any external services (spreadsheet headers, sample data, regex101.com, etc.), for example, to show that the item/record exists and set up correctly
You can upload images here using the Upload icon in the text editor:
We would appreciate it if you could upload screenshots here instead of linking to them outside of the forum. This allows us to zoom in on the image when clicked, and avoid tracking cookies from third-party websites.
Sharing these details will make it easier for others to assist you.
Hi Fellas, thank you for the suggestions. I guess Airtable Search Records did the trick. I have added Search Records and added formula {Team ID new} = “{{30.teams.home.id}}” - mapped to iterators output, then I added Airtable Update record and mapped Fixtures table with Record ID and then , map the correct field eg. “form” from Search Records Module. Enclosing scenario screenshots and the ones from modules. Now time to map fixture table to placid for image generation. Thank you again for support here, I lost few hair over this last week
What is your goal?
What is the problem & what have you tried?
Screenshots (scenario flow, module settings, errors)
