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.
3 Likes