User-Specific Column collect together on another table

I made a daily calendar and have user-specific column row (user note) for each day.
I want to collect “non empty” daily user note together on another table with corresponding date and user note. export it also.

How do I “collect” user notes to another table ?

  • Create a template column that concatenates the date and the note
  • Create an if-then-else column:
    – If note is not empty, then template column
  • Create a joined list column targeting the if-then-else column

This will give you a list of dates/notes for the logged in user.
Because your notes column is user specific, it is of course only possible to do this for the signed-in user.