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

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • In Progress
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
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,756 Points 5k badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,756 Points 5k badge 2x thumb
Can anyone help me here?

Thanks,
Gaurav
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
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.
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,756 Points 5k badge 2x thumb
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
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
I'm not sure how to do that in non native Quick Base.