Skip to main content
Question

Multi select field from another table

  • August 23, 2023
  • 0 replies
  • 433 views

Hello -

For dropdowns that change values, it is helpful to use a separate table to store the values in and then use a field to mark values as active (allows you to drive which options show in the dropdown but allows you to also maintain historical data values). Is there a way to do this with a multi select field? The goal is to allow me a way to tell Quickbase which values to show, allowing the options to change over time and maintain historical records while not clogging up the dropdown choices with things like "retired do not use - Option A".



------------------------------
Thanks in advance,
Jennifer Paschal
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24

I think you can make a table of valid drop-down choices and set that multi select field to look at the field in that table which has records corresponding to each valid choice.

When the choice no longer becomes valid you need to delete them off of that table.  



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