Values true and false refer to a boolean variable (ie, a checkbox).
Values "true" and "false" are strings, compatible with select field options.
It depends on how your code "sees" those values coming. How the source variable is described: string, or boolean/any/variant.
Looks like they are being interpreted as the latter; so yes, try enclosing the values in quotes, good chance they will get parsed out.
Values true and false refer to a boolean variable (ie, a checkbox).
Values "true" and "false" are strings, compatible with select field options.
It depends on how your code "sees" those values coming. How the source variable is described: string, or boolean/any/variant.
Looks like they are being interpreted as the latter; so yes, try enclosing the values in quotes, good chance they will get parsed out.
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?
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 ?
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.
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.
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.