Hi

i want to create a script where i can import new records via excel . i want to be able to pick up the related parent table id and place it in the designated field in the imported sub file.

The PropertyIDF (see pic below) should get from parent table. see script below , unfortunately when i do the import it only places the propertyIDF for the first record in the foundset (see pic 2,) how do i script that all new records created should get the variable data in the selected field.   i would appreciate if one could help me out on this.

 

 

 

I think you can give the field an auto entry calculation (define  field options) so you wouldn’t need the script. Sorry if this is wrong but I cant test atm. 

Instead of 'Set Field' you could use the 'Replace Field Contents' script step, which would have the effect of putting the same value in the same field on the whole found set.

After an import, the found set is always the records that have just been imported.

Both methods above will work. The auto-entry option will be faster if you're importing a lot of records (say, over 1000) but that also depends on your network. If that's not an issue, I'd lean towards the Replace method because where possible, I prefer to keep my logic in scripts rather than the field entry options.