Formula URL Syntax Error (Case Function)
Hello - I'm unable to resolve a syntax error. I copied a formula and tried to add a Case function, but am now getting a syntax error. The original formula that works fine: URLRoot() & "db/" ...
Forum Discussion
I think I figured it out. Why is it that you can try to resolve something for an hour, finally decide to ask for help, and then the solution comes to you right after you request help?
I added &" to the second to last line:
"Early Phase (Clinical)","20") &"
QB then allowed me to save the field, and appears to be applying the Case function as intended.
I do have a follow up question though: After I saved the field and reopend it, the last line of code appears as:
"Early Phase (Clinical)","20") &"\n&_fid_38=" & [Record ID#] & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#])
Any idea why the \n was automatically added here: &"\n&_fid_38?
------------------------------
Melanie Mercadel
------------------------------
I added &" to the second to last line:
"Early Phase (Clinical)","20") &"
QB then allowed me to save the field, and appears to be applying the Case function as intended.
I do have a follow up question though: After I saved the field and reopend it, the last line of code appears as:
"Early Phase (Clinical)","20") &"\n&_fid_38=" & [Record ID#] & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#])
Any idea why the \n was automatically added here: &"\n&_fid_38?
------------------------------
Melanie Mercadel
------------------------------
