Can I use concatenate in Quickbase?
Trying to combine two text fields in Quickbase into one text field. Field 1 is a title from another table and Field 2 is the version of that title. So Field 1 might be "Diabetes" and Field 2 might...
Forum Discussion
If you need to test for a value in Field2:
If([FIELD2]="",[FIELD1],[FIELD1]&"_"&[FIELD2])
If([FIELD2]="",[FIELD1],[FIELD1]&"_"&[FIELD2])
David,
If we needed to concatenate only if the checkbox is checked? How would this formula look? I have a table with services offered and several checkboxes listing each service. I would like one fields to have a list.
If we needed to concatenate only if the checkbox is checked? How would this formula look? I have a table with services offered and several checkboxes listing each service. I would like one fields to have a list.