Hi all,


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!