multiple records in one cell -> create new records on a different page

Topic Labels: Automations Base design
528 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


My brain is stuck on an operation that doesn't seem so complicated... but

I have an "Event" table

Screenshot 2023-09-29 at 15.36.10.png




and a "Days" table

Screenshot 2023-09-29 at 15.39.44.png




Is it possible, or how can I achieve this result ("expected" page)?

Screenshot 2023-09-29 at 15.37.12.png




I have a project in which events are created over time. When I create these events, I don't yet know the day(s) on which they will take place and their quantity (number of days).

Would it be possible that when I add 1 day (or more) to a project, it creates a new record on another page ("expected" page)?

1 Reply 1

Hi @qwas,

Yes it is possible by using an automation. As trigger you could set "when a record is updated" which looks at the field with the data that can be updated by adding one day. And as action you could use "add a new record", selecting the new table "Expected". By doing this, every time you add a day to an event it will create a new row.

I hope this helps!