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
MarkShnier__You
Qrew Legend
Qrew Legendtry this
URLRoot() & "db/" & [_DBID_TP_MODEL_RESOURCE] & "?a=API_AddRecord&apptoken=dkmnkvc6xxfffbyjn4imbopoynw&_fid_55=" &
Case([TP Model Def - Name],
"Clinical","32",
"Syn One","27",
"GCS","23",
"REMS","25",
"FSP","29",
"Systems Only","1",
"Early Phase (Clinical)","20")
& "&_fid_38=" & [Record ID#] & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
URLRoot() & "db/" & [_DBID_TP_MODEL_RESOURCE] & "?a=API_AddRecord&apptoken=dkmnkvc6xxfffbyjn4imbopoynw&_fid_55=" &
Case([TP Model Def - Name],
"Clinical","32",
"Syn One","27",
"GCS","23",
"REMS","25",
"FSP","29",
"Systems Only","1",
"Early Phase (Clinical)","20")
& "&_fid_38=" & [Record ID#] & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------