Hi! First post here. Very beginning JS user but excited to learn!
I’m working on a pretty basic script in a base I’m working on. I’ve been learning JS but I’m not quite at the point where the examples are making sense to me.
I have 2 Tables in my Base, “Projects” and “Judges”. In Projects, I will assign 3 judges from the Judges table in one Linked Record column. Then, in a third Table, “Scores”, I want to use the Script block to have three unique rows generated - one for each judge with the same project.
So for example: Project “Coral Reef Building” gets assigned “Mark”, “Sam”, and “Amy” as judges. In “Scoring”, three rows are generated:
“Coral Reef Building, evaluated by Mark”
“Coral Reef Building, evaluated by Sam”
“Coral Reef Building, evaluated by Amy”
I was thinking that .forEach method might be useful here, but I’m getting confused with the exact terminology around tables and queries and records.
Thanks all for your help & advice! Even pointing me in the right direction of some specific functions or frameworks that might help would be useful.