Go trough a column of linked records and create a new record for each link in it, with corresponding info

Topic Labels: Scripting extentions
596 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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 …
Capture d’écran 2020-10-16 à 11.11.18

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
Capture d’écran 2020-10-16 à 11.28.07

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!

1 Reply 1
5 - Automation Enthusiast
5 - Automation Enthusiast

This tool might help you (I reckon :slightly_smiling_face: )