Forum | Appery.io

I am trying to create a clickable list app, not unlike the HTML5/Local storag tutorial, but I'd like to be able to use a DB collection for the values.

To explain further:

Start page- Clickable list item( dynamically displayed from DB collection)
Details page- When clicking on any of the list items, certain values from the DB are displayed.

Is there a tutorial, or can someone point me in the right direction?

Thanks in advance.

Hello -

Have you checked our tutorials about how to work with database?
:: http://devcenter.appery.io/tutorials/...
:: http://devcenter.appery.io/tutorials/...

I have looked at that tutorial, but it isnt exactly what i am trying to accomplish.

I apologize for leaving this out, but as in the html5/local storage tutorial; When clicking on one of the list items i want to navigate to another page which displays only information for the clicked list item. I understand how the tutorial shows it using routes and tagID, but in the tutorial theyre using an imported xml sheet, and not a database.

I've created hidden labels, tagid, and the id from the database is mapped to it, but Im unsure as to how i can use that to navigate "on click"..

In total scope, I'm trying to create a way to list "stores" on my start page. When clicking on an individual store, navigate to a "store details" page. The "Store details" page displays the database information pertaining to selected store, and also some CRUD functions for selected store.

again, thanks in advance for your help!

Hello Zachary,

Please look at this link, it should help:
http://devcenter.appery.io/documentat...

I have read all the tutorials and still cannot understand how to get my data from a database rather than XML feed (as in the tutorial). Is there more detailed instruction on how to present a list from a database, pass the value selected from the list, display details about the selected menu item on a new page?

Hi Donald,

You can make the same as in HTML5/clicked list tutorial.

But with following differences:

1. Use "list" service to populate list component.

2. Use "read" service to get needed item and populate with this item details page.

   Regards.

Thank you. I have all these settings in place but do not understand where to create the local variable to hold the id when passed from my startScreen.

Hello!

Let me know if this helps http://devcenter.appery.io/documentat...

Not really but thank you. I created a local variable. I set my click upon success to assign the itemID to the variable. I cannot figure how to get the detail page to use the variable to display the details from my selection.

I have it working now. Thank you for the suggestions.