Newbie here, just starting to learn how to code via trailhead and anything I can find online, while also trying to solve org problems in the real world of salesforce CRM, so am hoping someone can help me find or provide examples online to get me on the right track!
Scenario:
- I have a custom object = Sessions
- I need to relate Sessions to the standard object, Accounts, so I have created an Account Lookup text field on the Sessions object
- Sessions entries are submitted via webform, so I am using a custom field to capture the Account name = Account Submitted
- The idea is that the Account Submitted is what the user submits and believes to be correct, and what I want to do is have a trigger or process that looks up the Account Submitted, determines if there is an exact match to an Account Name in the system, and if so, update the Account Name lookup field on the custom Sessions object to create the association between standard object parent and custom object child
- the leftovers will be managed manually as this is not a heavily used form, several per day at most.
I was hoping to use flow or process builder, but am stumped, and haven't coded my own trigger outside of the trailhead examples, which aren't helping me figure this out.
Any and all pointers are appreciated as I'm just getting started in the world of process and triggers, but this is a current problem I need to solve.
If you've found similar answers on stackexchange, please point me to them, as the words I've chosen to search aren't turning up the results I was hoping for!