Mapping Multi-Select Fields with Integromat

[Process_Boost]

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!

[Process_Boost · Accepted solution]

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:

[cor]

Thanks for posting that :slightly_smiling_face:

[cor]

You actually dont need the same options if you have the Smart links option ticked in the airtable create or update node. By doing this Integromat will create a new option if the option does not exist alreade. You will get an error if you try to post anything with an option that do not exist without Smart links turned on.

[ScottWorld]

You never explained to us why you needed a JSON array to begin with.

Most people just need a 2-step Integromat scenario:

1. Watch records or Search Records.
2. Create records.