Skip to main content
Question

Multiple Field Values as Drop down

  • May 3, 2023
  • 0 replies
  • 71 views
Forum|alt.badge.img+6

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 may have different values for the 3 fields. Example for the records with dummy values listed below.

R1 L1_GRP1 L2_GRP3 Blank
R2 L1_GRP2 L2_GRP1 L3_GRP1
R3 L1_GRP1  Blank L3_GRP2



------------------------------
Anitha Jeevarathinam
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24

    You 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
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement