Automatize a table

1

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?

2

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:

image
image1270×862 25.4 KB

next a target table with a lookup Column for the PedroEmployees and a date formatted column for theDates:

image
image1115×1520 91.2 KB

In the button the below works:

image
image1530×1665 204 KB 

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
3

@Christiaan_Huizer

He he, you’re so fast!!

Happy new year!

P

2 Likes
4

Yeah, that worked for what i did want to. Thanks, and happy new year!

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.