Hi. Sorry, I’m new to baserow. how to do this in baserow? I want to move to baserow because I prefer open source.
In airtable it is right. In baserow I can’t do it.
I’ve tried this formula:
IF(field(‘RESPOSTA’)=field(‘GABARITO’),1,0)
Thank you
Hi. Sorry, I’m new to baserow. how to do this in baserow? I want to move to baserow because I prefer open source.
In airtable it is right. In baserow I can’t do it.
I’ve tried this formula:
IF(field(‘RESPOSTA’)=field(‘GABARITO’),1,0)
Thank you
Hello @roowba! First of all, welcome to the Baserow community
That’s great you prefer open source software, you’ll find a lot of like-minded people here
The formula doesn’t work in your case, as the IF function works only with text field types in Baserow for now. But there is a super easy workaround: all you need is to add conversion of your single select fields into text (by using the TOTEXT function) to the formula:
if(totext(field('RESPOSTA')) = totext(field('GABARITO')), '1', '0')
I recreated your table, so you can see that this solution works
Awesome. Thank you so much.