Map to Field on Multiple Choice Field on Record Producer

[Andrew Linenber]

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.

[Allen Andreas]

Hi,

So from this I see 2 things:

1) One instance looks like it's Madrid or newer? (doesn't matter -- as much, but they aren't the same instance version). I only mention this because some options and features were only made available in specific versions and newer....and if one instance isn't on the same version...some settings won't come over correctly.

2) The value that is showing is more_1000 ...so....that's coming from somewhere. I don't think SN is making up a choice of more_1000 on it's own? So you'd want to look in to where that is coming from. Could be some sort of UI Policy script or Client Script because it's very close to wording like more_thousand...so I think someone did something in script and confused those two options. Is there any "addOption" type stuff going on in any scripts associated here? Both on record producer OR the form itself? I'd look those over.

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

[Andrew Linenber]

Hi Allen:

Thanks for the response.  Both instances are on the same version of Madrid.

As far as I can tell we don't have any associated scripts, but I'll take a look and get back.  Originally, that "more_1000" value was what the choice value was that we were hoping to map, but we went back and changed them to make sure they exactly met the same value.

[Allen Andreas · Accepted solution]

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!

[Andrew Linenber]

Thanks Allen!

Of course I skipped the most basic troubleshooting issue.  That fixed it.

Best,

Andrew L.