Formula not working with data from Make (Integromat)

Topic Labels: Formulas
484 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


I have the folowwing formula: IF({Type Relation} = "Mr","ok","pas ok"), it’s just a test because in my make automation i’ve a problem, and now I understand why, because in my airtable base the formula doesn’t work correctly in a first try.

When my automation write “Mr” in my “Type Relation” field, the formula don’t see “Mr” in the first try. If you see the next screen, you can see that when I remove the final “r” of “Mr”, the formula is always to “pas ok”, it make sens and no problem here. When I rewrite the “r” to have “Mr” (What I had in the beginning), the formula is updated correctly to “ok”.

Capture d’écran du 2022-11-19 09-45-39
Capture d’écran du 2022-11-19 09-45-59
Capture d’écran du 2022-11-19 09-46-17

Have you ever seen that ?

1 Reply 1
4 - Data Explorer
4 - Data Explorer

Reply to me. By default in radio button, Make (Integromat) set “\n” after the string … So If i try my formula with “Mr\n” it’s working !
Better solution is to use “toString()” function in Make