Discussions

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

    Posted 7 days ago
    Edited by George Bramhall 7 days ago
    *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 7 days ago
    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 7 days ago
    still getting "about:blank#blocked"

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



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

    Posted 7 days ago
    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 7 days ago
    Edited by George Bramhall 7 days ago
      |   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 7 days ago
    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 7 days ago
    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 7 days ago
    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 6 days ago
    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 5 days ago
    Bingo. Just overthinking things again. Thanks again Mark.

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