Using a date value to select an item row

Ask for Help
1

Hi all,

I am working on an app the has a different image for each day of the year. I have a list of every date of the year in a column and an adjacent image column.

I can use a list collection to show all the dates, and pick one. But I would much rather use either a calendar or date picker. Unfortunately, both of those are intended to add data to the table, not facilitate selecting a row.

Has anyone designed an elegant way to select a date and then show the detail screen for that row of the underlying table?

All help appreciated!

2
  • use a Date Picker (not in a form) to write a date value into a User Specific date/time column
  • use that value to create a Single Relation to your list of dates
  • show a details screen via the relation

You may find that you have trouble building the relation, even though the dates might look the same. This will most likely because the underlying times won’t match. To get around this, I recommend using a math column to convert all dates to integers, then use the integer values to create the relation. The formula to use is as follows:

Year(Date)*10^4
+ Month(Date)*10^2
+ Day(Date)