record producer unable to update selected category and subcategory on custom request table

[runfast]

I have two custom tables (category_table and subcategory_table), the  mapping works fine on the form. But when submitting no category or subcategory gets updated.

My variables are:

category

subcategory

I tried to use the following script inside the record producer without any luck.

current.category_table.fieldname = producer.category;

current.subcategory_table.fieldName = producer.subcategory;

Any guidance or direction greatly appreciated.

thanks

[Periyasamy P]

As you mentioned category and subcategory is reference column, make sure you are sending sys_id of category and subcategory  from your variables producer.category and producer.subcategory.  Otherwise make necessary translation, and get sys_id before setting category and subcategory. 

[runfast]

Hi Periyasamy - Thanks for looking into this!

But I am still struggling to get this to work.

May be more detail would help:

Here is my category variable setup:

Here is my sub-category setup:

Here is my script setup:

[Periyasamy P · Accepted solution]

Didn't see any issue in variable setup. And also, variable type is lookup select box and it will not support dot walk.

Please verify column and variable name.

current.<column name> =  producer.<variable name>;

[runfast]

Thank you Periyasamy!

As you pointed out, the issue was with the actual column name and the variables. 

All works OK now:)