Formula Text field based on multiple fields
I have a form which contains a field called "System Intake Category" which has 15 choices. If one of those choices are selected, a corresponding field populates which has a list of applications for ...
Forum Discussion
While not intuitive, the IsNull is documented not to be usable with text fields. To test for bank you need to use a test looking for empty quotes. The Trim is optional, but its a good idea if there is a possibility that the user has typed an invisible space into the text field.
If(
Trim([Advanced Solution System])<>"", ToText([Advanced Solution System]),
Trim([Back Office Support System])<>"", ToText([Back Office Support System]),
etc
If(
Trim([Advanced Solution System])<>"", ToText([Advanced Solution System]),
Trim([Back Office Support System])<>"", ToText([Back Office Support System]),
etc