Forum Discussion

GauravSharma3's avatar
GauravSharma3
Qrew Commander
7 years ago

Is there a way to show distinct value in the dropdown?

Hi team,

I have one custom time cards approval page where I want to show only distinct values in the drop-down time card Approver dropdown. I have populated time cards approver values with the help of query.

Currently, it looks like below.



Can I show only distinct value here?

Thanks,
Gaurav
APIs and custom code
Ask about Quickbase functionality
Tips and tricks
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Did you try just making a multiple choice field with the the values taken from that field. It will only offer unique choices. So this is NOT going to be a relationship, try a simple multiple choice field from another field.
    • GauravSharma3's avatar
      GauravSharma3
      Qrew Commander
      7 years ago
      Hi Mark,

      Thank you for your response.
      I tried but, it works well if I add a record. I want to show this field on a custom HTML form to show the value.

      or what I am planning to do, Is there a way to show the value of the dynamic filter on the HTML page? like If I have a report and I have added some dynamic filters to it.

      Thanks,
      Gaurav