Unique List from Data Table

[wdandrews]

I have a data table with that could have multiple locations for a physician. From that data table I would like only one unique physician name display after the user enters their search criteria. From the list of names that match the criteria I would like the user to select the physician name and on the next page have it display all of the locations for the physician. From that list of locations the user would select one and have the details display for the location. How do I build the first query to get the unique physician name that matches the criteria? In SQL I could use distinct, but I don't see that as an option when building a view.

 

[Vitalikssssss]

On 5/11/2017 at 11:16 PM, wdandrews said:

I have a data table with that could have multiple locations for a physician. From that data table I would like only one unique physician name display after the user enters their search criteria. From the list of names that match the criteria I would like the user to select the physician name and on the next page have it display all of the locations for the physician. From that list of locations the user would select one and have the details display for the location. How do I build the first query to get the unique physician name that matches the criteria? In SQL I could use distinct, but I don't see that as an option when building a view.

 

Hello wdandrews,

I would suggest using a special form element on your search form called Cascading:

http://howto.caspio.com/datapages/datapage-components/cascading-elements/

This element allows restricting a possible amount of option in child field based on the selection in parent field.

Please note that "distinct" option is enabled by default for a different type of form elements (dropdown\listbox\radio button etc).

Hope this helps.

 

[Vitalikssssss]

Just an update on this topic.

There is a feature called "Show distinct records only" released by Caspio in R30 that can easily solve this use case scenario.

This feature available in List/Gallery/Tabular reports.

https://howto.caspio.com/release-notes/caspio-30-0/