I'm starting to create a formula that, when clicking on the Add Contact Button, will copy over the address information from the parent record to the child record. However, I keep getting a QB error that I just can't understand. My formula looks correct, but obviously, it is not.
URLRoot() & "db/" & [_DBID_CUSTOMERS] & "?a=API_GenAddRecordForm&_fid_36=" & URLEncode ([Record ID#])&
If([Address - Street 1]<>"",
"&z=" & Rurl()
Formula syntax error - The argument list of the function z must begin with a left parenthesis.
As far as I can tell, I have all the right parentheses.