Record Picker Distinct Values

Question

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 summarized on the distinct count and grouped by equal values. The output of the report is what I want but when I change the record picker of the report link to this summary report it still shows repeated values.Is there something I can change to make the summary report as my record picker work the way I want it to? And/Or do you have any other ideas on how to accomplish this?

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

markshnier__you · Answer

Are you just trying &nbsp;to fill the drop down choice? If so, you can kill the relationship and use a shared multiple choice field. &nbsp;By then you will not have a relationship to pull in lookup values.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

jenniferpaschal · Answer

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__you · Answer

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

jenniferpaschal · Answer

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__you · Answer

You 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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Record Picker Distinct Values

Related Content

Distinct Dates

Record Picker in Grid Edit

Filtering Record Picker

Custom Record Titles

Changing Record Picker List Dynamically