When both a Record Producer field & a Table field is using sys_user as reference, a problem emerges...

C_dric Chen · ‎05-19-2022

This problem has been haunting me for ages, and I don't think I can circumvent it any longer.

As illustrated in the image above, I have a record producer that generates new records for a table. Both components have field "Requestor", both fields use the same reference: the sys_user table that come with the system, and both fields are as mandatory as filing your taxes.

Here's the problem: After I populate all the mandatory fields and click on the "Submit" button in the record producer, a new record is created in the table, but the "Requestor" field in that particular record in the table would be empty, which is not supposed to happen.

Does anyone know the reason behind this?

Kartik Sethi · ‎05-20-2022

Hi @Cédric Chen

I think I got your issue.

Field: Type → Reference
Variable: Type → Lookup Select Box

Your variable's Lookup value field might be configured as some field but NOT Sys ID and that's why Field on the table is not getting populated.

To solve your issue, you can check the variable provided below (for some reason I am not able to paste screenshot)

This is an OOTB variable: User (https://<instance_name>.service-now.com/item_option_new.do?sys_id=f548305b53131300afffddeeff7b12a2)

So you have to modify your variable in a similar manner.

Please mark my answer as correct if this solves your issues!

If it helped you in any way then please mark helpful!

Thanks and regards,

Kartik

View solution in original post

C_dric Chen · ‎05-20-2022

Hello, Kartik.

I changed the "Look up field" setting from "Name" to "Sys ID", and the problem appears to have disappeared.

Thank you very much for your help!

Kartik Sethi · ‎05-20-2022

Hi @Cédric Chen

I urge you to please mark my reply as correct so that other community members facing similar issues might get a solution to their issues!

Thanks and regards,

Kartik