Discussions

Expand all | Collapse all

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

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

    Silver
    Contributor
    Posted 06-26-2018 14:00
    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.

    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1737386/RackMultipart20180626-23788-p3d2m5-image_inline.png?1530021453">

    Can I show only distinct value here?

    Thanks,
    Gaurav


  • 2.  RE: Is there a way to show distinct value in the dropdown?

    Silver
    Contributor
    Posted 07-02-2018 13:57
    Can anyone help me here?

    Thanks,
    Gaurav


  • 3.  RE: Is there a way to show distinct value in the dropdown?

    Posted 07-02-2018 14:05
    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.


  • 4.  RE: Is there a way to show distinct value in the dropdown?

    Silver
    Contributor
    Posted 07-06-2018 12:41
    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


  • 5.  RE: Is there a way to show distinct value in the dropdown?

    Posted 07-06-2018 15:29
    I'm not sure how to do that in non native Quick Base.