I wonder how to approach this - I need to recreate the image below, I will display info in repeating group(s) but on the left I need to section the rows into ‘this week’, ‘week2’, ‘week3’ etc.
The user needs to be able to show more weeks or go back a view expired weeks. I can’t show show the first week using ‘current date/time +7 days’ because a week start date shouldn’t change if you view it again tomorrow … it needs to be like a calendar where skipping forward a week retains the week start dates.
I assume each record (line item) has a *date to represent the week they’re in. You can use the “Group by” function to group records by the date. I believe you can group by the specific week using the “Group by” function. The function should return a list of dates/weeks. That would be your first repeating group.
Inside your first repeating group, you should have a 2nd repeating group to list all of the records that are within the current cell’s week.
In terms of making the first week the current week, that should be quite simple after you have a solid setup.
Apologies for not going deeper into this. I’m a little time restricted. Hope this pushes you in the right direction.
