record producer

Mouli Praneeth · ‎09-08-2014

How to access the true/false field in a table from a record producer.

Iam using Yes/No variable in RP but when i change the option to yes in RP it is not getting reflected in the table.

How to do that??

manolis_sgouros · ‎09-09-2014

There is 2 mistakes:

You had a Yes/No type on your record producer, this field has values Yes and No but the checkbox field on your custom table is true/false. These values don't match.
The name of the variable must match with the name of your field. In your case you have name of the field "u_choice" and name of the variable "Choice"

I changed the name of the variable to "u_choice" and the type to checkbox. Now you can test, is working.

Cheers,

Manolis.

View solution in original post

manolis_sgouros · ‎09-08-2014

Hello Mouli,

Normally, if your record producer variable has the same name as the technical name of the field in the the table, will work.

For more information, please check the wiki article:

Record Producer - ServiceNow Wiki

Best regards,

Manolis.

Mouli Praneeth · ‎09-08-2014

No it is not working. i have created a table and for that table i have created a record producer.

My Requirement is :

In table, the field type is True/False and in RP the variable type is Yes/No. So when i select Yes from RP then the field in the table should be automatically checked.

But it is not working like that.

manolis_sgouros · ‎09-08-2014

What is the technical name of your field in the table and what is the name of your variable?

Mouli Praneeth · ‎09-09-2014

same name for both the field and variable.

I m working on demo007a and the record producer name is working. Kindly have a look