- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-04-2019 01:25 PM
We are trying to map a variable on a record producer to a teamspace table (tsp2_demand).
The variable type is multiple choice, and the field type on the table is Choice.
We have set up the Question Choices on the variable (attachment1) to match the Choices on the table (attachment2), include making the label/text fields AND values match 1:1 (i.e., they are they same on both the variable and the field).
However, when we submit the record producer, it still inserts an additional option into the choices on the table (attachment3). The option inserted matches the VALUE of the choice selected on the record producer (the choice on the variable).
Is there any way to get this to map appropriately? We need to use these fields to trigger surveys, but as it keeps selecting the additional option, it never triggers. Any assistance is appreciated.
Solved! Go to Solution.
- Labels:
-
Service Catalog
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-05-2019 05:27 AM
It would appear that one system's cache may not be cleared to recognize the changed value you did, please go to that instance and type:
cache.do and press enter in your left-hand navigation to clear the cache and see if your new value shows up.
Also, if any reply is Helpful...even if not Correct, please mark as such if it is.
Please mark reply as Helpful/Correct, if applicable. Thanks!
Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-05-2019 08:40 AM
Glad it worked for you. Please take a moment and mark any other reply in this thread as Helpful, if it was.
Take care!
Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-04-2019 01:43 PM
Hi Andrew,
It seems you are using Producer script to map the field kindly have a look on your script. The value you are entering might be wrong and that would be the reason, kindly modify your script and enter the correct value in the Script.
Also, please verify only that the value of Question's choice, field choice and the script are exactly the same.
Kindly mark my answer as correct and helpful based on the impact.
Regards,
Chaitanya
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-05-2019 04:54 AM
Hi Chaitanya:
The Producer script was a last ditch effort to troubleshoot the problem before I submitted this question to the community; I just didn't remove it. If that's what we need to do to get this working, then that's what we'll do but it seems odd that a record producer multiple choice variable can't map to a table choice field.
I am a little unclear about what we are supposed to verify. In the screenshots provided, the Labels and the Values of the choices on both the variable and the table column are exactly the same.
Regards,
Andrew L.
