Trigger Update Field Value Help

Posted by Rollbase User on 04-May-2012 15:23

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

All Replies

Posted by Admin on 04-May-2012 15:40

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.

Posted by Admin on 04-May-2012 16:34

Thank you Nathan!!! I tried double quotes and () etc.

Posted by Admin on 04-May-2012 16:51

No problem!

Posted by Admin on 05-May-2012 04:27

Thanks Nathan!

This thread is closed