URL Formula Edit Record

Question

Hi

I have a URL formula (screenshot and text below) that is only partially working. When the button is clicked, the edit record piece is not working. There is no error thrown but the fields defined in that part of the formula (highlighted/underlined in red) remain unchanged. The add record piece is working just fine.

Can you help me spot the issue?

If([Status] != "CIA Draft Saved",URLRoot() & "db/" & [_DBID_TABLE_1] & "?act=API_EditRecord&rid=" & [Record ID#] & "&_fid_94=true&_fid_43=CIA Submitted" & "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_RETURN_TO_SUBMITTER_NOTES] & "?act=API_GenAddRecordForm&_fid_8=" & [Record ID#] & "&_fid_7=Return to Submitter&_fid_12=" & [Date Created] & "z=" & Rurl()),"")

------------------------------
Thanks in advance,
Jennifer Paschal
------------------------------

MarkShnierYou · Answer

It might be due to the lack of URLEncoding of content with spaces.

If([Status] != "CIA Draft Saved",
URLRoot() & "db/" & [_DBID_TABLE_1] & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_94=true&_fid_43=" & URLEncode("CIA Submitted")

& "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_RETURN_TO_SUBMITTER_NOTES]
& "?act=API_GenAddRecordForm&_fid_8=" & [Record ID#]
& "&_fid_7=" & URLEncode(Return to Submitter) & "&_fid_12=" & [Date Created]

& "z=" & Rurl()),"")

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community