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

[qwas]

Hello

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

I have an "Event" table

and a "Days" table

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

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)?

[Alessio_Monino]

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!

Website: https://alessiomonino.com
Calendly: https://alessiomonino.com/contact
Email: alessio.monino@gmail.com