I am currently working with a table in forms that has 7 days (mon-sun) of calculations the initiator fills out. The initiator will select a 'Request Date' shown in the image that will allow them to select only a Monday for the week they are needing a Per Diem form.
Here is my dilemma:
Once the initiator selects the date needed, it automatically fills area 2 with the previous weeks dates for the days of the week. This area will be hidden once the form is pushed out.
Area 3 is where the issue occurs. I am trying to grab the dates populated from area 2 and fill those dates in the Field Labels in area 3, for example Date Mon populates '3/31/25' when the Request Date is 4/7/25 but the form still shows the field label as "Mon {dataset/d_mon}".
Does anyone know a possible solution or a workaround?