IF statements on text formulas (next-gen)

Ask the Community Get Answers
1

Hi there guys!

I’m trying to have a field auto-filled based on an if statement with parameters from another field. Something like:

if fishWeight > 10:
fishCategory = “large“;

if it isn’t possible on text formulas, maybe there are other ways you guys might know? Ideally this is kept in the next-gen app builder, let me know if this is possible.

Cheers

2

Hi @Sebastien_Duke, unfortunately text formulas don’t have IF statements (I feel that pain!).
The alternative is using a short text or multiple choice field and using conditional rules to set the field value based on values in other fields.

image
image352×473 18.8 KB

Hope that helps!

3 Likes
3

Hi !

Thank you so much, this works wonders.