Hey Guys,
I have two column which are [cadence] and [planned_start_date]. [cadence] is a enum type column with option value “Weekly”, “Monthly” and “Quarterly”. [planned_start_date] is a date type column.
I need to find a way where the planned dates are automatically populated based on select [[cadence]. Thank you very much for your help.
cc @Steve
Hello @alhazen , how would you like the planned dates to be populated? you mean like as in automatically generated in a table based on the starting date?
For example, if you were to create a new row on january 1st set to monthly, you would like 12 rows created, one for each month?
Or would you like to obtain a date 7, 15, 30 or 120 days from the date the new row is created, depending on the option chosen?
Hey, Thank you for feedback.
Let’s say i choose “weekly” on [cadence], and [planned_start_date] with default value today(April 13 2022). I would like new rows will generated automatically based on starting date with “weekly” logic for a year.
it means new rows for 20, 27, 4 May, and so on automatically generated
Thanks Steve, it works