Automation to update One Custom Field based on another based on the value position in the list order

Chris Rose_pgccir

Hi,

 

I have two fields of over 600 options, and I want to run automation to fill out the second field with a value that is in the same position in the first fields list.

 

For example:

Custom Field One Values: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10....600

 

Custom Field Two Values: A, B, C, D, E, F, G, H, I, J...ZZZZ

 

 

I would want it to match up based on the position of each list like this:

A|1

B|2

C|3

D|4

E|5

 

Can that be done through JSON? Or is there any other method to add this in without manually entering over 600 automation rules?

Mikael Sandberg

It should be possible to get the value by using the Send web request to the REST API to get the value for the second field. You can find the API call to use here.