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])
List(", ",
IF([Wash checkbox], "Wash"),
IF([Dry checkbox], "Dry"),
IF([Iron checkbox], "Iron"),
IF([Repair checkbox], "Repair")
)
IF([Wash checkbox], "Wash"),
IF([Dry checkbox], "Dry"),
IF([Iron checkbox], "Iron"),
IF([Repair checkbox], "Repair")
)