How to insert missing days of the week into a table

[Eso_Surveyors]

hi, all, back to the community after a long while, but never away from appsheet.
excited about automation.
this is my challenge:
i import into an appsheet table this csv data:
State, Last Name, First Name, Shift Start Date, Shift Total Time.
5 states, 100 last/first names, most make entries for the week’s work but not all 7 days, for example Saturdays, Sundays.
i need to automate once weekly on report day, inserting the weekdays missing for each state+Last/First name with zero in Shift Total Time.
can’t get my head around how check record by record for a missing weekday in the file for that state/Last/First name then create a single line replicating all but ShiftTotalTime zero.
thanks in advance for any ideas.

[Steve]

Maybe a good starting point?

FAQ: Add rows for a date range Tips & Tricks 💡

Add a set of rows to a table, one row for each date, starting with a given start date and ending with a given finish date. Try the sample app! For this example, the table from which the row-addition process will be initiated is called Control Table. The table to which new rows will be added is called Target Table. Use your own names as you see fit. Note that they could even be the same table. Control Table must allow updates; Target Table must allow adds. Control Table must have at least thre…

[Eso_Surveyors]

legend