Skip to main content
Question

Error 0

  • September 18, 2020
  • 0 replies
  • 32 views
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
------------------------------
Thanks in advance, Jennifer Paschal
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24
    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
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement