Plain text in relation columns

[Samuel_Langford]

Hello!

I’ve been having issues with this for a while and it’s really bothering me lately. In a relation column, plain text will sometimes end up there, even if the Allow adding of new options is turned off. Users will sometimes just paste in something, or the text doesn’t line up perfectly or something like that. The point is, plain text will sometimes end up in a relation column.

The issue is that I don’t have a good way to find those rows. If I use the isfromtable() formula, it throws me an error. But the isblank() formula gives me back false because there is something in there.

Any tips?

[Melanie_Teh]

@Samuel_Langford

added a column called “Formula” that could help you detect these..

you can change it to a check box type column etc

hope this helps!

Cheers!
Mel

[YouGamified]

Try this formula on a new column

This will return 3 different values, then you can group a table and find the invalid values, and build UX alerts in your interfaces, preventing users to perform actions if the input is invalid.

Result:

[Samuel_Langford]

@YouGamified , @Melanie_Teh

Thank you both! I’ll try these out.