AnsweredAssumed Answered

Set field in several records

Question asked by JavierDura on Apr 19, 2015
Latest reply on Apr 19, 2015 by JavierDura

Hi.


I am in LayoutA (from TableA).

Using a script, I set a variable ($ids) with a list of ids of records from TableB:

 

 

E26D13DE-277F-468A-A9F1-A80326768C80

ABC90A1F-864B-4B1B-ACFE-6CC8104C7728

564080C8-2E4E-4E9E-A9A6-D9CF7B604D02

 

Using the same script, I set another variable ($values) with a list of new values:

 

34

12

7

 

 

TableB has two fields:

id

value

 

My intention is to "set field" and insert the values from $values in the records of TableB according to the $ids list.

 

So, 34 will be set in record E26D13DE-277F-468A-A9F1-A80326768C80,

12 will be set in record ABC90A1F-864B-4B1B-ACFE-6CC8104C7728

and 7 will be set in record 564080C8-2E4E-4E9E-A9A6-D9CF7B604D02.

 

What would be the FASTEST way to do that?

Thanks.

Outcomes