How to insert missing days of the week into a table

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.

Maybe a good starting point?



1 Like