Unable to insert true into a single select field which has options true and false

Thanks for your reply !

I did it but unfornutalely what is passed to Airtable is "mydata" instead of the value (true or false) of mydata.

Airtable then asked for the permission to create a new option in the field which is not what I want.

I understand the problem comes from Integromat / Make which outputs "mydata" (without replacing the value of mydata by true or false). If I try ti use the function toString (mydata), then Make outputs everything as a string "toString (mydata)".

How did you guys manage to insert none string true / false values from Integromat / Make into an Airtable single select field ?

I'm not familiar with Make, but let me point this out, just in case:

Many language syntaxis will code a function call with no spaces between the function name and the parenthesis enclosing the parameters.
Could it be that you actually inserted the space in: toString (mydata) in the definition of that field?
Shouldn't it be: toString(mydata) instead, for it to be recognised as a function rather than a string?

As for the permission to add new options, that can be solved by granting that permission at the field level. This is a once-for-ever configuration.

Thanks for your reply !

I just found how to solve the problem based on your first reply and trial and error with Make.

When you want to map a data to a field in Make, you click on the field and then a list of tag representing the available data show up.

But as I explained, because the type of the data I wanted to map was incompatble with the type of a single select field this didn't work.

There is a "function mode" in Make where you can click on tags representing functions. So I clicked on the toString( ) tag and typed in the name of my data inside the parenthesis.

That was accepted by Make but didn't as I explained in a previous message.

To make it work, I had to also click on my data tag and not type it.

Now, the string conversion works and I do get true in my single select field if the data was true.

As for the permission to add new option, I didn't want that because the data was incorrect (e.g. "mydata" or "toString(mydata)").

Thanks again for your help and sorry it was finally more a Make problem than an Airtable problem.

---

@JaponaisNaturel wrote:

Thanks again for your help and sorry it was finally more a Make problem than an Airtable problem.

---

Thanks for your explanation, I too learned something new today.

And nothing to sorry about - Airtable and Make form what kids 😉 like to call "an ecosystem". Either part fails, the whole thing fails.