AnsweredAssumed Answered

script for creating records with a location assigned and date assigned

Question asked by j.baegs on Dec 13, 2018
Latest reply on Dec 20, 2018 by j.baegs

So I have a work schedule and I'm looking to be able to press a button and it assign the locations from my locations table to each day so when a new day is created the locations are auto populated with those locations.

 

I have an assignments table which contains location id and the date and i would want a button or script that would run creating records for locationID 1 to the 1/1/2018 then locationID 2 to the 1/1/2018 etc up to how many locations i have then would do locationID 1 to the 2/1/2018 etc etc. for however many days you wanted to create.

 

Is this possible and how would you go about it.

 

any help is much appreciated.

Outcomes