Multiple Field Values as Drop down
Hi, I have a table/ report that has 3 fields (like LVL1_GRP, LVL2_GRP and LVL3_GRP) for every record. Is it possible to create a drop down with values from the 3 fields for every record. Every record...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendYou can create a formula field which concatenates these together.
For example
List(" ", [Field 1], [Field 2]. [Field 3])
But I'm not sure what you want the appearance of the combined field to look like when one or more of those three fields are blank. If you let me know that, I can adjust the formula. The formula I provided will list the non blank field values separated with a "space".
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
The Drop down should list only non blank values. If field2 is blank then the drop down should list only field1 and field3.
And the request is to list the values in 3 fields as a drop down and let the users select one of the values.
------------------------------
Anitha Jeevarathinam
------------------------------