I’m trying to update a multiple select field based on info from an api. There’s 30 some values that will either be Yes or blank. If it’s yes, its works fine and puts the correct value, but gives an error if it tries to add nothing to the multi select field.
What I’ve tried so far:
{{if(206.record.animalDrools = “Yes”; “Drools”; )}}
{{if(206.record.animalDrools = “Yes”; “Drools”; null)}}
{{if(206.record.animalDrools = “Yes”; “Drools”; emptystring)}} * Doesn’t fail but doesnt leave it completely blank either
Hey there @Jessi_Burns, Michaela from Integromat here :wave:
Ok, so this is definitely not an easy nut to crack but basically, you have a data type problem here.
In a much easier situation, this is how you can keep your multi-select column “clear”.
With an if function like the one below, you are already working on the item-level within the multi-select which is no good for clearing a multi-select column.
Even if :arrow_up: the formula :arrow_up: returns a null, it’s a different null than the one in the first screenshot.
For the solution, we need the “map” slider enabled and:
(To make this as digestible as possible, we decided to work with dates.)
As you can see, in the first case the function returns a “yes” because today’s date is 2021-09-27.
In the second case, the field remains clear because today’s date isn’t 2021-09-28.
The reasoning behind this is that you need to pass either an array with the “Yes” value if you want to set a value, or you need to pass an “array level” null which in this case will translate to a multi-select column.
No need to worry about the explanation too much, though :grinning_face_with_sweat: If you follow the screens, I’m sure it’ll work for you :slightly_smiling_face:
