Searching dates

[Tanya]

Hi

I would have started creating an app on Appery and I have a database linked to it. I would like the user to be able to enter/ select a date, then have data returned from the datebase for that date specifically.

My idea is that someone will enter data onto the database then users will be able to access this information using the app.

I'm not sure what the best way would be to look up the date that has been selected in my database and return the relevant information. I have tried setting storage variables for the date and I have also tried mapping the date entered to the date displayed but none of this has been successful so far.

[Evgene Karachevtsev]

Hello Tanya,

And could you please clarify your question? What have you done for your app already and what problems do you have?

[Tanya]

I have created a page that the user needs to add their username and password in order to login. This works fine. They are then directed to a page (screenshot below) where the information that has been entered in the database appears in a list box. The first field has the date, then various other information is displayed. I have also added a datepicker above the list box where I was trying to link the date that is selected in the datepicker to the date in the list box. I would like to be able to select a date from the datepicker and display the information for that day (productivity figures).

I hope this makes more sense?

[Illya Stepanov]

Hi Tanya -

Please walk through this tutorial:
http://devcenter.appery.io/tutorials/...
It looks very similar to your task.

[Tanya]

Thank you very much, this worked perfectly!

[Tanya]

Thank you very much, this worked perfectly!