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
Hello Mark,
Is a shared multiple choice field different from the standard multiple choice field?
More background to help understand the specific use case:
------------------------------
Jennifer Paschal
------------------------------
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__You
Qrew Legend
Qrew LegendYou 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
------------------------------
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
------------------------------- MarkShnier__YouYou should be able to create the field with no choices and then go back into it and select "choices from another field".
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------