Help

Discover what data silos are costing your org in our commissioned Forrester study. Learn more

Formula not working with data from Make (Integromat)

Topic Labels: Formulas
55 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi,

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

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