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. - List(", ",
IF([Wash checkbox], "Wash"),
IF([Dry checkbox], "Dry"),
IF([Iron checkbox], "Iron"),
IF([Repair checkbox], "Repair")
) - What he said: ^^
- I will give it a try! Many thanks to both :)
- I am trying to do the same-thing but with using a text field with two numeric fields. The three fields are an identifier or ID field for Die Specifications.
Dimension ID/Text field = A0
Number Across/numeric = 2
Number Around/Numeric = 4
Die Specification/text field would = A024
------------------------------
Frank Mitchell
------------------------------- I got it worked out using the totext
------------------------------
Frank Mitchell
------------------------------
