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!
Cheers, Christiaan
3 Likes
2 Likes
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.