Value list to populate portal row

[madman411]

Hey guys. I've got 3 individual portal rows that must be populated by three different Value Lists upon creation of a new record.

 

These portal rows track pass/fail tasks that the user must perform on equipment. These pass/fail tasks fall under three different categories. When the user has created the new quality control record for the asset they are testing, I would like them to click a Populate button above each of the three portal rows. I have all the values for these categories placed in their own Value Lists, which upon population, creates related records in their respective portal rows. How can I script FileMaker to pull values from a Value List and create individual related records? Is there a get() function I've overlooked?

 

The main Asset record holds a unique Asset ID.

The QC records for the Asset have a unique QCID and an Asset ID.

 

Thanks!

[Ocean West]

Don't exactly understand your data model but this illustrates how to create default records into a child table.

 

PopulatePortal.fmp12.zip

[madman411]

Thanks Ocean West. Your model has given me a good starting point. I'm assuming there could be a looping script that will create as many default records as there are values? I noticed only 3 records are created in the child table rather than the initial 4 that are in the values table.

 

In regards to my original question, is there any way for the script to use the custom values that are placed within a Value List as the source?

[Ocean West]

yes - here you go

 

 PopulatePortal.fmp12 2.zip