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
------------------------------

markshnier__you · 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
------------------------------

jenniferpaschal · Answer

Thank you! I updated formula as shown (had to make one change; added quotes to this URLEndcode("Return to Submitter")) but still no luck on the edit record i.e fields 94 and 43 were not updated.

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

markshnier__you · Answer

Are you editing the correct Table? &nbsp;Is [_DBID_TABLE_1] the correct table?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

michaeltamoush · Answer

Not sure about field 43, but Mark, correct me if I'm wrong but if field 94 is a checkbox doesnt it need to be =1 (versus = true)?Also, I always use ?a= instead of ?act, but I do not know if that makes a difference. Mark, do you know the difference between a and act?------------------------------Mike Tamoush------------------------------

markshnier__you · Answer

I always use act=&nbsp; but I think that a= works as well.I also use 1 for true, but 1 did think that true works as well.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

URL Formula Edit Record

Related Content

Using Grid Edit to Edit Multiple Records at Once

Edit Multiple Records at Once with Grid Edit

Formula URL - Edit then Add

Button: save the new record and edit the new record

Custom Record Titles