Howdies. This is probably something really simple. But I can’t quite understand how to do this. I want a repeating group that displays each day, so I can search for timesheets that my staff has filled out for that day. At the moment, my repeating group is set out to search for the timesheets, however because my staff sometimes do three shifts a day, the results display in a different repeating group for the same day: example:
I want all timesheets to show up under one day, similar to this example:
How do I display a particular day in a repeating group, for example Fri 5/6/22 and then add one day to this date, so I can search for timesheets based on this day. I basically want one column for 5/6/22, one column for 5/7 and so on, instead of displaying the same day in multiple cells. I have tried “current date / time + 1 day” but all of the cells display the exact same day. I want to be able to add a day to each cell, and search accordingly.