How to create a table with unique dates?

Ask for Help
4

Okay, cool.

So just focussing on your primary question, which is to create a list of unique dates, you can do it as follows:

  • I’m assuming that your Logs table contains the email address of the user that added each row
  • Start by creating a table, and add enough rows as you are likely to need (one row for each unique date)
  • Add a Row Index by following the 2nd method described here.
  • Add a Query column, target it at your Logs table, filter it where User Email is User Profile->Email, and order it by Date descending
  • Create a Lookup column, target it at the Query column, and select the Date from the Logs table. This should give you an array of all dates for the signed in user.
  • Add a Unique Elements column and target it at the Lookup column. This will give you an array of unique dates.
  • Add a Single Value column, target it at the Unique Elements column, and select N from start, where N is the Row Index.

This should give you a list of unique dates for the signed in user, with one date per row.

1 Like