I am a bit new to this discussion system.
I have created a lesson tracking points systems for my school that is based on the 'Invoices' starter solution.
It consists of 4 tables - Students ( Customers), Products, Invoices, Invoice data
I have added in all the student names to the customer table
I have created 5 records in the products table - Monday, Tuesday, Wednesday, Thursday, Friday.
Every week I create a 'new invoice' for each student and add in the 'Products' Monday, Tuesday, Wednesday, Thursday, Friday.
The 'Invoice Data' table has Lesson 1 to Lesson 6 for each of the days and the calculations to total them.
So Monday has lesson 1 ,lesson 2 etc and the same to each day.
So in effect, I would create an invoice for 'Pupil A', with a date of 'Week 1' and allocate Monday, Tuesday,Wednesday, Thursday, Friday , which would create each lesson for each day for that invoice.
My issue I need help with is I have to create a new record for each student on friday afternoon ready for the start of the following week. Is there a script/button that I can create to automatically create a new record for 'Week 2' for every student and that would then add in the 'Product' of Monday, Tuesday etc.
Please can anyone offer some advice.
Thank you so much