Need help approaching a LOOP or INPUT() Problem

[JpChapron]

Hello all,

I'm tackling a problem and I'm not sure where to start with it.

I have a list of users, this is the PArent, and a list of Exams for those people, this is the child.

Now, when I'm creating a new user, I want the childs to be automatically created has to have all the mandatory exams for said user. And to do that, I've created another table which contains the "Default" exams to be created.

Now onto the problem, I need to automatically populate the EXAM table, and I'm really not sure on where to begin with this, at first I tought it would be an easy loop to create, check the [Related exams] in comparison to the Defaul Exams table, then create the ones that don't exist. Easy right ? well. no, I went with the loop from @MultiTech https://www.youtube.com/watch?v=q4xCzxPgbaU

however when I'm trying that well I can't INDEX() the specific collumn I want for each row that I need, the INDEX function cannot draw from a SELECT() Expression... !

So now I'm thinking.. INPUT()?

but input would required not only hard coding some values, but also a lot of actions to be created...

Which way do you think I should go?

thanks

[Marc_Dillon]

I've created another table which contains the "Default" exams to be created.

---

Use an "execute an action on a set of rows" action on the pre-defined list of exams, to create new child records for the latest (MAXROW) parent record.

[MultiTech · Accepted solution]

The video you might check out is the following:

• https://youtu.be/tHQumluhL4Q

I call the technique "Blueprint Tables" - but it's the exact thing you're talking about. I have one set of tables that serves as the blueprint of what I want, I have another set of tables that serve as the parent records, and I have a Target table that serves as the place where I want to copy the records from the blueprint table into the target table ref connected to the parent table.

The concept that this centers around is not action looping, but instead executing an action on a set of rows.

• From the perspective of the parent record, you execute an action on all of the blueprint records
• The blueprint record action you're doing creates a copy into the target table
• To ref connect the new records you could either use a hot linking type of system (https://youtube.com/shorts/UkiZaCqI0bo?feature=share), or you could utilize input() to push the value from the parent record. 

Once you get things established and you understand the ins and outs of how things work, you could even make a way to execute this server side - taking advantage of that sweet sweet parallel processing. 💪

[JpChapron]

Thanks a lot Matt,

I did exactly as you said in this video, and well, it worked perfectly ! 

I'm not going with the server bot because a lot of the app needs to be able to happen offline, but it's a really nice touch that I might implement on other, more demanding and not offline requiering options.

last but not least, Is there a fedora color you DON'T have ! I love them all !

Thanks so much for your time and all the work you've done for this community