
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-08-2014 10:52 PM
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??
Solved! Go to Solution.
- Labels:
-
Ask the Expert
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-09-2014 12:30 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-09-2014 12:30 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-08-2014 11:29 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-09-2014 01:18 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-09-2014 01:36 AM
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.