Drop down box variable

[Andrew Gilmour]

Hi,Is there any guidance on using backend data where a drop down box brings up related data to the selected option? I want a dropdown box to be able to load specific data - like a SQL @variable. ThanksAndrew

[maxkatz]

If you have an example that would help -- but just bring in the data from a service and display in the drop down.

[Andrew Gilmour]

Hi Max,

That's the bit I am struggling with - how do we bring in data to a dropdown and the how does the table below get the filtered data.

If we have a table

Team FirstName LastName
Red Fred Flinstone
Red Barney Rubble
Blue Captain Caveman

The drop down should only have the options Red or Blue and then the data below would display the names based in the selection.

I can see help docs on how to do this by manually entering options - I just can't see anything that shows you how to do this from a appery database.

Thanks

Andrew

[Kateryna Grynko]

Hi Andrew!

To get all the unique items from "Team" column you can't use Rest Services. Rest Services support simple requests only: read, write, delete.

You would need to use Generic Service. Via JavaScript, you can access Appery Database, get collection data and get an array of unique "Team" items. You can find an example of Generic Rest Service here: https://getsatisfaction.com/apperyio/...