I have created a table with teachers and their availability.
Each line corresponds to a teacher, and my columns are the different weeks of the year.
The field type of my columns is a linked record, so that I can have multiple date filled in for one week.
It looks like this: Name of the teacher // availabilities w1 // availabilities w2 // availabilities w3 // …
Tom Sawyer // Mon. Jan. 1st, Tue. Jan. 2nd, Wed. Jan. 3rd, Thu. Jan. 4th, Fri. Jan. 5th // Mon. Jan. 8th, Tue. Jan. 9th // Mon. Jan. 15th …
I would like to write a script to go through these “availability” columns and for each record in it, create a record some place else.
So that I would have something like: Name of the date // Name of the teacher
Mon. Jan. 1st // Tom Sawyer
Tue. Jan. 2nd.// Tom Sawyer
and so on
Then, I could match the records with the same name, so that I have all my teachers available for one given date.
Is there anyway to do this using the scripting app?
I am very new to js so don’t really know where to start…
I don’t know if this is very clear,
Thank you so much for your help!