I have created a update field value trigger that when a checkbox is checked, it takes whatever is in {!R8304.street_address_1} and updates the field in the related table {!applicant_street_add}. The trigger is running but I am getting an error. I know it's because my Change Value Formula is failing (though it validates but doesn't pass on the debug) In my non-programmer mind, I thought I could just put the field that I wanted to retrieve the value from in the formula. Can you tell me the right syntax for the formula? I get this error on formula debug: Original Formula {!applicant_street_add} Parsed Formula 001 17 White Oak Road, Suite a Formula return type: String Error Error missing ; before statement (line #1) in formula: 17 White Oak Road, Suite a
Hey Parker - You're very close. You just need to put quote marks around the merge token. So:
'{!applicant_street_add}'
That will parse to:
'001 17 White Oak Road, Suite a'
And it should work fine.
Thank you Nathan!!! I tried double quotes and () etc.
No problem!
Thanks Nathan!