Forum Discussion

Qrew Member

2 years ago

Multi-select field

I have a multi-select field for fruit where the user can select any number of fruit in the record. If a user selects 3 different kinds of fruit, is is possible to have QB automatically copy the 'main'...

Qrew Commander

2 years ago

What is 'the main' record? Is there a parent to the record that this multi select field is on?

And what do you mean by copy? Put all the fruits in their own field? Just have one field with a list of the fields selected?

------------------------------
Mike Tamoush
------------------------------

LisaColby
Qrew Member
2 years ago
There is not a parent to the record that the multi-select field is on.

I have a form that asks Name, Company, Date and several other fields and one of the questions is the multi-select fruit question in which the user can choose any number of fruits. What I'd like to have happen is that if the user chooses 2 fruits, the landing page - or another report, has 2 records - one for each fruit, instead of 1 record that aggregates all of the multi-select into one column.

This is sort of confusing to write out and I'm fairly sure what I want isn't possible with a multi-select field that has no parent.

Thank you for thinking about this!

------------------------------
Lisa Colby
------------------------------
- MarkShnier__You
  Qrew Legend
  2 years ago
  How many possible choices are in the fruit drop-down list. I.e. what is the most number of fruits that could be selected to be duplicated?
  
  ------------------------------
  Mark Shnier (Your Quickbase Coach)
  mark.shnier@gmail.com
  ------------------------------
- MikeTamoush
  Qrew Commander
  2 years ago
  In addition to Marks question, what is your ultimate goal? Are you trying to count up fruit in a certain way? Make a report or chart in a certain way? What are you trying to achieve in the end?
  
  There may be a way to achieve your goal without extra records.
  
  ------------------------------
  Mike Tamoush
  ------------------------------