Skip to main content

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

  • September 29, 2023
  • 1 reply
  • 24 views
Q
Forum|alt.badge.img+1

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

1 reply

A
Forum|alt.badge.img+11
  • Alessio_Monino
  • Participating Frequently
  • October 2, 2023

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

Terms & ConditionsAccessibility statement