Re: Mapping Multi-Select Fields with Integromat
I have a scenario where I am mapping a Multi-Select Field in one Airtable Base to a Multi-Select Field in another Airtable Base using Integromat.
The scenario requires the JSON Parse module in order to correctly parse the data to show up correctly in the 2nd Base.
The Multi-Select Field can contain a variety of social media Channels, like Twitter, Facebook, Youtube, etc.
The scenario works great unless I add in more fields beyond the ones that are being sent.
For example, if I map it to where there are 6 potential Channels to choose from (Youtube, Twitter, Facebook, LinkedIn, Tiktok, Snapchat) but only 3 are sent in the Scenario, those 3 extra fields will be sent as “null” and this causes an error in the Scenario.
Is there any way to remove that null, so that the JSON produces THIS:
{“Channel”:[“Twitter”,“Instagram”,“Youtube”]}
instead of THIS:
{“Channel”:[“Twitter”,“Instagram”,“Youtube”,null,null,null]}
Thank you!
Accepted Solutions
Solution to this that @cor helped me out with was essentially to make sure that “Smart Links” is checked on the “Create a record” Module and to map the array (ex: Channel: [ ] ) rather than mapping something like “Channel 1: [1], Channel: [2], Channel [3]”
As usual, the solution ends up being way simpler in the end. :man_facepalming: 
