auto-displaying fields within a record producer based on previous user input

[nathantenaglia]

Hi everyone,

I've created a record producer that's using the sc_cat_item view which obviously has some limitations in what is and isn't supported in comparison to the traditional record producer view.

I'm trying to create some variables that are saved to the sys_user table and then auto-display for the users the next time they open the form (based on feedback, saving them time from having to add the same information each time).

I've got a script within the record producer that saves this data to the associated sys_user fields I've previously added:

Here's an example of the completed sys_user fields:

The problem is that my record producer isn't auto-displaying these custom fields (it does work for the display name, phone number and email address though)

I'm really stuck. Any idea?

[Chaithra Srini1]

Hi All,

This code worked for me if field is a single line text - gs.getUser().getRecord().getDisplayValue('u_building');

But it isn't working if field is a Reference type. 

PLease advise how to fetch the display value of a field from the user form in a record producer form if the field is a reference type.

Regards,

Chaithra

[deepakgarg]

It will work in reference field as well, if the reference field is pointing to the correct table. Also, use `getValue` instead of `getDisplayValue` function.

deepak;