Discussions

 View Only
  • 1.  Error 0

    Posted 09-17-2020 23:06
    Edited by JENNIFER PASCHAL 09-17-2020 23:30
    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
    ------------------------------


  • 2.  RE: Error 0

    Posted 09-18-2020 08:51
    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
    ------------------------------