Forum Discussion

JENNIFERPASCHAL's avatar
JENNIFERPASCHAL
Qrew Trainee
5 years ago

Error 0

Hello,

I have a Formula - URL button with the following formula: If([Status] = "PACE - Rapid Request",URLRoot() & "db/" & [_DBID_INTAKE] & "?act=API_EditRecord&rid=" & [Record ID#] & "&_fid_89=Solution Squad - Review" & "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_INTAKE] & "?a=dr&rid="& [Record ID#]),"")

When I click the button I get the following error message but the record is successfully updated. Why is this message displaying?


Edit: I have another formula - url button doing a similar thing as well, but this one is not updating the record.

If([Status] = "Solution Squad - Review",URLRoot() & "db/" & [_DBID_INTAKE] & "?act=API_EditRecord&rid=" & [Record ID#] & "&_fid_89=PACE - Review" & "rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_INTAKE] & "?a=dr&rid="& [Record ID#]),"")


------------------------------
Thanks in advance,
Jennifer Paschal
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    Can you try this change

    If([Status] = "PACE - Rapid Request",
    URLRoot() & "db/" & [_DBID_INTAKE] & "?act=API_EditRecord&rid=" & [Record ID#]
    & "&_fid_89=" & URLEncode(Solution Squad - Review")
    & "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_INTAKE] & "?a=dr&rid="& [Record ID#]),"")

    The issue may be that you are building a URL and they do not like spaces or special characters, so text which may have that needs to be URLEncoded.

    ie need to URLEncode the phrase

    Solution Squad - Review

    has spaces in it.

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