Forum Discussion

NicholasNeilio's avatar
NicholasNeilio
Qrew Member
5 months ago

Multi-select text field with descriptions

Two tables, using made up info as example to simplify question.

1st table - Main

Customer Name - Text Field

Burger Selection - Multi-Select Text Field

2nd Table - Definitions

Burger Item - Text

Burger Description - Text - Multi-line

Hamburger - Fresh, hand-formed patties hot off the grill and placed on a soft, toasted sesame seed bun.

Cheeseburger - American-style cheese melted between fresh patties and placed on a soft, toasted sesame seed bun.

Question: On Table One, when the customer is selecting the burgers, I want to be able to show the description on the form so they know what the options are.

IOW - how can i show descriptions of the options in a multi-select text field.



------------------------------
Nicholas Neilio
------------------------------

8 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    5 months ago

    There is not an elegant way to do that with a multi select field.  have you considered a middle join table where 1 Order has many Order Lines and One Parts Master has many Order lines.  The order lines can hen have lookups for the descriptions and also data entry fields for the quantities and perhaps prices or price overrides.



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • NicholasNeilio's avatar
      NicholasNeilio
      Qrew Member
      5 months ago

      Ok, next issue, change the setup a bit

      1st table - Main

      Customer Name - Text Field

      2nd Table - Order(join table)

      Order Date

      3rd Table - Definitions

      Food Type = (Main or Side)

      Food Item = (Hamburger, Cheeseburger, Fries, Tots)

      Food Description = 

      How do i Create a form that filters the definitions to the food type, so when filling out the order i have a section for each

      thanks



      ------------------------------
      Nicholas Neilio
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew Champion
        5 months ago

        Are you asking how to limit the drop down choices for Food Items to just those for Food Type, say Main? 

        If so you can make a report of Food items with a filter of Food Type = Main and then set the Form Properties to use that report for the drop down choices for Food Items.

        Or perhaps you are looking to have multiple embedded child reports on the Parent Order record, and want the child records separated into sections.  If so, then similarly make reports appropriately filtered and set the Form Properties  to use those reports for the embedded report.



        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------