@Adam Posegate, I am confused on a couple of points. You state provider records are being created and then account is being selected from a field there. Is the account field a required field as part of creating the Provider record? It seems it would need to be or the Provider records wouldn't have a Name populated until it was. I may just be interpreting your statement incorrectly.
The approach you outlined in your first post is a very common practice of mine as manually determining a "Name" for a related record is difficult for application users to understand so I use real-time workflows to populate the Name field quite often for the related record. I would make the Name field "Business Recommended" instead of "Business Required" and then the real-time workflow populates the Name of the Provider record.
But there is one very important thing to call out for your specific example. The Account field on your Provider table is a relationship to the Account table, so the Provider "Name" value will change if you change to a different Account value. However, if the name in the Account table changes, that will not automatically change the displayed value on your Provider table record.
I hope this helps!
------------------------------
Jim Lorrig
Senior Business Solutions Consultant
Heartland Business Systems
Little Chute
------------------------------
Original Message:
Sent: Jan 05, 2021 09:38 AM
From: Adam Posegate
Subject: Help? Setting name of record to account lookup value
@Jonathan Blackham The provider records are being created, and then account is being selected from a field there. The provider is a child of different custom entity.
------------------------------
Adam Posegate
Fox Valley Technical College
Appleton WI
Original Message:
Sent: Dec 28, 2020 12:05 PM
From: Jonathan Blackham
Subject: Help? Setting name of record to account lookup value
@Adam Posegate - A question about your user experience. Are you creating these provider records from the existing account record, or are you creating them as net new records and then choosing the account manually? If you are doing them from the existing account record, you should be able to create a mapped relationship between the account record and the provider record where the new provider record can inherit values from the associated account record it was created from.
------------------------------
Jonathan Blackham
Sales Operations Specialist
Valin Corporation
Original Message:
Sent: Dec 22, 2020 01:46 PM
From: Mike Hastings
Subject: Help? Setting name of record to account lookup value
Yep, I see what you are saying, its not an option in the SET options. How built out is the provider entity? If its new-er you could remove it and create another entity, then default the Primary field to something more valuable.
Otherwise, I think you did the right thing with a workflow.
------------------------------
Mike Hastings
Technical Consultant
Blue Horseshoe
PEORIA AZ
Original Message:
Sent: Dec 22, 2020 01:29 PM
From: Adam Posegate
Subject: Help? Setting name of record to account lookup value
Thanks, Mike. I'm running into an issue on this approach. The account field does not come up as one of the fields for me to select.
------------------------------
Adam Posegate
Fox Valley Technical College
Appleton WI
Original Message:
Sent: Dec 22, 2020 01:20 PM
From: Mike Hastings
Subject: Help? Setting name of record to account lookup value
You could turn it into a business rule. If NAME does not contain data and Account contains data. - Set Name to Account. Just make sure the scope is on more than just the form. If that doesnt make sense let me know and I can send some screen shots.
------------------------------
Mike Hastings
Technical Consultant
Blue Horseshoe
PEORIA AZ
Original Message:
Sent: Dec 22, 2020 11:20 AM
From: Adam Posegate
Subject: Help? Setting name of record to account lookup value
I have a custom entity named "Provider". When I create a new "Provider", I select an account from my list. I am also asked for a name. This is redundant for me, as I want the name to be the same as the account name.
My current approach to this is:
- Hide the "name" field on the form.
- Make account a required field.
- This creates the record with a blank, unknown, or "New Provider" label (it is unclear what is happening, exactly)
- Run a workflow (not a Flow) to automatically set the Provider record name field to the account on creation and on change when the account field changes.
Is there a simpler way to do this? It seems that there must be.
------------------------------
Adam Posegate
Fox Valley Technical College
Appleton WI
------------------------------