Hi guys. Right now, we’re looking to implement a table for the workers, which needs to have a row for each day of the year. Is there a faster way to do that that’s not manually create a row for each day?
Hi @Pedro_Jimenez ,
Create a button on the canvas that fills out all the dates per employee like below. I first created a table with employees:
next a target table with a lookup Column for the PedroEmployees and a date formatted column for theDates:
In the button the below works:
Sequence(Date(2023,01,01),Date(2023,12,31)).ForEach(CurrentValue.WithName(allDates , PedroEmployees.ForEach(CurrentValue.WithName(theEmployees, Pedro.AddRow( Pedro.theDates,allDates, Pedro.employee,theEmployees ) ))))
Enjoy your 2023 planning!
He he, you’re so fast!!
Happy new year!
Yeah, that worked for what i did want to. Thanks, and happy new year!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.