Record Picker Distinct Values
Hello, I have a reference field I am showing as a dropdown for data entry. The record picker is showing repeated values rather than distinct. I tried creating a summary report on the value and summ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendAre you just trying to fill the drop down choice? If so, you can kill the relationship and use a shared multiple choice field. By then you will not have a relationship to pull in lookup values.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Hello Mark,
Is a shared multiple choice field different from the standard multiple choice field?
More background to help understand the specific use case:
- The table that contains the values for the dropdown pulls in data from an internal source nightly so the multiple choice values would could change (new values could be brought in with newer data) so the dropdown would need to be dynamic.
- The dropdown also needs to drive a filter on an embedded report (selected value is the value the report is filtered to show related records). The way it is currently set up (even with repeated values) is currently doing this properly. If (from screenshot in original post) 'Analytics' was selected then the embedded report shows all records where 'Analytics' is in the 'Program' column.
------------------------------
Jennifer Paschal
------------------------------- MarkShnier__YouYou should be able to make a new field which uses the internal source nightly file as the source for the multiple choices. I believe that it will offer up dynamically the unique values contained in a field in that data at the time of selecting.
You can then make a Report link field and match up the selected value in that shared multiple choice field to a field on the embedded report, to get the filtered list. The filtered list will only show once the record is saved.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- How do you create a multiple choice field so that it allows you to select another source as the choices (or in this case a field)? When I create a new multiple choice field I only see the following:
------------------------------
Jennifer Paschal
------------------------------
