Forum Discussion

GeorgeBramhall2's avatar
GeorgeBramhall2
Qrew Cadet
3 years ago

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

*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
------------------------------
APIs and custom code
Formulas and functions

9 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years 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
    ------------------------------
    • GeorgeBramhall2's avatar
      GeorgeBramhall2
      Qrew Cadet
      3 years ago
      still getting "about:blank#blocked"

      ------------------------------
      George Bramhall
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        3 years 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
        ------------------------------