Record Producer item order

[williammorton]

Hi

I am generating some test forms in the record producer of ServiceNow. I have been adding variables with no problems at all:

(Field names removed to anonymise the data)

On a colleague's advice, I spaced each data field 100 apart in case I need to input more fields later.

I am also using Variable Sets as there are 3 fields that appear on the top and one field at the bottom of the form. Therefore I set the first 3 as a single variable set with 100 as the Order value. this worked fine, but when I came to add the bottom value I first tried to add it as a variable which I had previously used, but found that the Edit button I needed to do this was not there:

Therefore I tried to create it as a variable set with a single field in it, which worked fine, but I tried to set it as Order value 900 to be below everything else:

However, when I saved it, it defaulted back to the value of 100.

Can somebody please:

A) Tell be how to save a variable so I can use it again

OR

B) Tell me how to set the variable set to have a higher Order value to make it appear at the bottom of the form

[scott barnard1 · Accepted solution]

If you go to the main record producer page and scroll down to the related lists and select variable sets tab

Click on the i icon next to your variable set and a little pop up box appears so you can change the order.

This changes the order for that record producer and not all the other items that use that variable set.

Not sure it's what you are after but it may help you in layout

[williammorton]

Thanks Scott, this worked fine.

[valerie_gallot]

I had the same problem before.

It is because there is a confusion between :

#1. the field "Order" that is defined on "Variable set" (table "item_option_new_set) => I don't know what it is for, we do not use it.

#2. the field "Order" that is defined on a variable set instance (table "io_set_item") which represents the utilisation of a variable set inside a record producer. => this one is useful.

Take care to display the right column!

On the related list of the variable sets (at the bottom of your record producer), personalize the columns to add "order".

Here you can set an order (the order is "global" for variable and variable sets)

For example :

VARIABLE RELATED LIST :

varA - 50

varB - 60

VARIABLE SET RELATED LIST :

varsetC - 40

varsetD - 70

We will get that on your record producer :

varsetC - 40

varA - 50

varB - 60

varsetD - 70