How to map a variable set selection to a field on a table?

[jaubert]

I have been tasked with an assignment to convert one of our forms into a record producer within SN.  I've created a table and created a record producer for our end users to complete and submit.  I may be a little confused on the associations within SN, so some clarity is greatly appreciated.  To my understanding a record producer is a form for the end users to submit a new record into a table.  While ITIL users have a different gateway, we can add new records directly on the table through the table's form.  I am expecting the user to fill out the form and when I view the table the values should appear with the mapped field.  I am wondering if this isn't the behavior for all field types, ie variable set of choice fields.

What I am trying to accomplish is on the record producer allow the end user to select multiple values from a variable set and those value update the table.  Please let me know if I am thinking of this the wrong way as there are still so many areas I am unfamiliar with in SN.  

[Allen Andreas · Accepted solution]

Hello,

Yes, record producers - produce a record on the target table.

For variable sets, since they can be used on multiple items/producers, etc., due to that, you're unable to use the "map to field" feature because:

1. It wouldn't work anyway
2. A UI policy hides the "map to field" field if the variable is associated with a variable set

for record producer scenarios, you would utilize the record producer script (on the record producer settings page, right in the middle) and map them yourself like so:

Example:

current.field_name = producer.field_name; //current is your target net new record and producer is the record producer

Please mark reply as Helpful/Correct, if applicable. Thanks!

[jaubert]

Thank you so much for the help and clarification.  One last question, what type of field would I need to use on the form to capture a variable set?  And would I need to write a line for each variable?

[Allen Andreas]

Hi,

Not sure what you mean by what type of field would you need to use on the form to capture a variable set?

Each variable within the variable set is it's own field.

You would need to write a line for each variable in the variable set to map it to the target (new record) field you want it to go to.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[jaubert]

"u_optionchoice" would be the "list" field from the target table and "current.option1" would be the variable within the record producer.  So if the user selects all 3 checkboxes would that update the field with all 3 choices from the list?

u_optionchoice = current.option1
u_optionchoice = current.option2
u_optionchoice = current.option3