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

User657785 · ‎05-19-2022

What field names are you using?

Question and name?

Label and name?

Hitoshi Ozawa · ‎05-19-2022

Hi Cédric,

In Record Producer's Requester's field definition, is the field mapped to the table?

Kartik Sethi · ‎05-19-2022

Hi @Cédric Chen

If you have properly mapped the variable to Field then ideally values should get mapped.

Please share the screenshot of the reference type variable that you created.

Thanks and regards,

Kartik

C_dric Chen · ‎05-20-2022

Greetings, Hitoshi and Kartik.

To respond to both of you: the field in the record producer is mapped to the main data table of the app (not to sys_user) as follows:

The field in the record producer:

The column in the main data table:

(Apologies for all the redactions.)