Jump to content
  • 0

Unique List from Data Table


wdandrews

Question

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.

 

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0
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.

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...