Discussions

 View Only
Expand all | Collapse all

URL formula to to to a result from a query formula field.

  • 1.  URL formula to to to a result from a query formula field.

    Posted 01-14-2022 10:14
    Edited by George Bramhall 01-14-2022 10:15
    *Subject should read ^to go to...

    This URL formula in the parent record, where the query formula field ([Get Suplicate Values] a multi-select formula field) is built, is giving me a result "Blocked". Can anyone identify why this formula is resulting in a Blocked result?

    var text recid = Left(ToText([Get Duplicate Values]),4);
    URLEncode(URLRoot() & "db/" & [_DBID_PROPERTIES] & "?a=dr&rid=" & URLEncode("$recid"))

    ------------------------------
    George Bramhall
    ------------------------------


  • 2.  RE: URL formula to to to a result from a query formula field.

    Posted 01-14-2022 10:56
    var text recid = Left(ToText([Get Duplicate Values]),4);
    URLEncode(URLRoot() & "db/" & [_DBID_PROPERTIES] & "?a=dr&rid=" & URLEncode($recid))


    take away the "  " around $recid


    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: URL formula to to to a result from a query formula field.

    Posted 01-14-2022 11:39
    still getting "about:blank#blocked"

    ------------------------------
    George Bramhall
    ------------------------------



  • 4.  RE: URL formula to to to a result from a query formula field.

    Posted 01-14-2022 12:40
    Can you take away the button label on that URL to expose the code it is generated and then paste that into this Forum? Maybe there is something weird about the day that you were stuffing into the record ID field.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: URL formula to to to a result from a query formula field.

    Posted 01-14-2022 13:44
    Edited by George Bramhall 01-14-2022 13:46
      |   view attached
    Attached is a screenshot of the field in question. I don't have the button selected. How do I display this "code"?

    It is possible that since I am using a query field in this formula ([Get Duplicate Values]) that it's use is causing the query to be run before a result is given for this formula?

    ------------------------------
    George Bramhall
    ------------------------------



  • 6.  RE: URL formula to to to a result from a query formula field.

    Posted 01-14-2022 14:27
    is this what your looking for?
    http://https%3A%2F%2Fxxxx.quickbase.com%2Fdb%2Fbn22h7u55%3Fa%3Ddr%26rid%3D7255

    ------------------------------
    George Bramhall
    ------------------------------



  • 7.  RE: URL formula to to to a result from a query formula field.

    Posted 01-14-2022 14:49
    I was actually asking for you to temporarily remove the link text that says 
    Go to property record

    and copy that code.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 8.  RE: URL formula to to to a result from a query formula field.

    Posted 01-14-2022 16:46
    That was it above: http://https%3A%2F%2Fxxxx.quickbase.com%2Fdb%2Fbn22h7u55%3Fa%3Ddr%26rid%3D7255

    ------------------------------
    George Bramhall
    ------------------------------



  • 9.  RE: URL formula to to to a result from a query formula field.

    Posted 01-15-2022 12:43
    D'oh, I clearly see the issue now. Get rid of both URLEncodes.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 10.  RE: URL formula to to to a result from a query formula field.

    Posted 01-16-2022 16:51
    Bingo. Just overthinking things again. Thanks again Mark.

    ------------------------------
    George Bramhall
    ------------------------------