record producer

Mouli Praneeth
Mega Expert


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??

1 ACCEPTED SOLUTION

There is 2 mistakes:




  1. 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.
  2. 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

8 REPLIES 8

There is 2 mistakes:




  1. 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.
  2. 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.


ankit_sharma487
Kilo Guru

I am not sure of your question correctly but I think if you use the CHECKBOX option it may be useful in terms of TRUE/FALSE


sudharsanv36
Kilo Guru

Hi Mouli, You can maually map that particular field to the respective table value. Otherwise, it will get mapped automatically if, technical name of the field is same as the label of the field as @Manolis Sgouros said.



I have made a similar thing in the "demo014.service-now.com". Name of the record producer is "Sample_Record_Producer"



You can find the things getting reflected in the Incident table.


Thanks Sooz since the field from record producer is a Yes/No kind and the field in the table is of boolean type its not working but i did that through scripting as follows:



if(producer.Choice == 'Yes')


{


      current.u_choice = true;


}



The Table choosen should be the one which refers the record producer.