Multi select field from another table

Question

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------------------------------

markshnier__you · Answer

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.&nbsp;&nbsp;------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

jenniferpaschal · Answer

Will deleting list items from the table cause records with that value selected to turn red/be put in "" and cause an error when trying to edit/save the record?

------------------------------
Thanks in advance,
Jennifer Paschal
------------------------------

markshnier__you · Answer

I suggest that you test ourself, but in my testing it works perfectly, does not block save and does not appear in red on forms or reports, only in red when editing the field. That invalid drop down choice is in red, but if previously selected will not block the save.

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

jenniferpaschal · Answer

Okay, thanks! I did some testing and it does keep the historical in the dropdown but if you go in to edit the record it does not allow a save. I will just stick with removing older values completely since it was more of a 'nice to have'. Thanks!------------------------------Thanks in advance,Jennifer Paschal------------------------------

markshnier__you · Answer

That is strange because I just tested and the save worked perfectly for me. I was able to add additional multi select choices and it's a fine including the pre-existing red one&nbsp;------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

Multi select field from another table