How can we update reference field value on table using Glide Record?

[Harshal Sonawa1]

contractNumber = 'FSD1111';

gr.setValue('u_contract', contractNumber);

gr.update();

I m trying to update using setValue() but its not working

[Harshal Sonawa1]

Hi Shloke,

Value is not updating in reference field. Below is the output

*** Script: query Count: 2
*** Script: before update: FCON0004614 serial number:S315253X8125902
*** Script: AFter update: FCON0004614
*** Script: before update: FCON0004330 serial number:2Z6TFZ1
*** Script: AFter update: FCON0004330

[shloke04]

okay not an issue. We can debug this and get you to a solution.

Can you share the screenshot of your Table form, like screenshot of the form of which all tables you are using here in your SCRIPT. I believe Asset and a Custom table you are using.

Screenshot of your script where you have written this script  like a BR or something else?

Regards,

Shloke

[Harshal Sonawa1 · Accepted solution]

Hi @shloke04 ,

Thanks a lot for helping and having patience. Finally, I am able to resolve this.

ac.update() will not work for saving(updating) values in table for reference field.

ac.updateWithReferences(); is correct method for it.

[shloke04]

Okay, then please mark the appropriate answer as correct and close this thread for other folks, will be helpful for someone viewing this post later for reference.

Regards,

Shloke