Hi everyone,
I am at the point of pulling my hair out as cannot get this issue resolved!
I have am trying to create an automated rota by doing the following:
I create a user account and then want to be able to load a page that has a repeating group pulling data from a table named DaysoftheYear. This table has a row for each day of the year with the day name, date, week number, rota week number, day of the year from 1 - 365.
Within this repeating group I have added a drop down menu to the row which has a value (In, Off, Sick, Holiday, etc).
On the page I have an input with the User Unique ID.
I also have a 14 drop downs for each day of the two week rota.
Week 1 - Mon, Tues, Wed, Thurs, Fri, Sat, Sun
Week 2 Mon, Tues, Wed, Thurs, Fri, Sat, Sun
When I change any of these dropdowns I want the relevant dropdowns in the list to change to the relevant rota week no.
For example … 1st Jan 2022 is a saturday. Our rota week is week 1. So when I change Week 1 Mon dropdown. The dropdown in the row Jan 1st will change the display to the Week 1 Mon.
All this I can do fine!
What I want to be able to do is to then ADD each row of the date/week no/user unique ID, and the updated rota status to a table called RotaTable.
This is so we can create an automated rota by clicking one button.
I cannot find a way to add each row of the repeating group dayoftheyear with the added rota dropdown to the table RotaTable.
I have been looking at tons of tutorials for API workflows on a list but the examples do not relate to what I want to do and I am stuck as cannot get it to work.
I did an original process where I had to set up 365 dropdowns on a page. I then used the 2 week dropdown to choose their rota pattern which updated the relevant dropdowns. I then had to add 365 workflows for each adding the data such as date, rota dropdown status, dayoftheyear and the user ID. This has stopped working and was a nightmare to complete.
Please can someone help me?
Thank you in advance!