Set Default Value to field from Reference

[jenn123]

Is there a way to set the default value to a dot walked field of a reference field on the same table? See example below on the Change Order table. Would like to set the "Requested for" default value to be the business contact which comes from the Project itself (referenced in Project Number). Is there any way to do this?

[jenn123]

Hi Emily,

Thanks for the suggestion. Unfortunately it didn't seem to work for me

[Brad Tilton]

Hi Jennifer,

Have you validated that u_project and u_business_contact are the correct field names? Also, is u_business_contact a reference field to the user table? I would not do this through a client script.

[jenn123]

Yes, those are the correct field names. And yes, u_business_contact is a reference field to the user table, so is the Requested For field.

[Brad Tilton]

How is the u_project field getting populated on the record? If that field is not yet populated when the record is created then we may not be able to use a default value.

[jenn123]

It's being populated automatically to be whatever project is open when you click "New" from the Change Orders related list (which is on the Project form) - not sure if that answers your question? Thanks again for your help!