Discussions

*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
------------------------------

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
------------------------------

Original Message:
Sent: 01-14-2022 10:14
From: George Bramhall
Subject: 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
------------------------------

still getting "about:blank#blocked"

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

Original Message:
Sent: 01-14-2022 10:56
From: Mark Shnier (YQC)
Subject: URL formula to to to a result from a query formula field.

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

Original Message:
Sent: 01-14-2022 10:14
From: George Bramhall
Subject: 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
------------------------------

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
------------------------------

Original Message:
Sent: 01-14-2022 11:38
From: George Bramhall
Subject: URL formula to to to a result from a query formula field.

still getting "about:blank#blocked"

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

Original Message:
Sent: 01-14-2022 10:56
From: Mark Shnier (YQC)
Subject: URL formula to to to a result from a query formula field.

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

Original Message:
Sent: 01-14-2022 10:14
From: George Bramhall
Subject: 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
------------------------------

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
------------------------------

Original Message:
Sent: 01-14-2022 12:39
From: Mark Shnier (YQC)
Subject: URL formula to to to a result from a query formula field.

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

Original Message:
Sent: 01-14-2022 11:38
From: George Bramhall
Subject: URL formula to to to a result from a query formula field.

still getting "about:blank#blocked"

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

Original Message:
Sent: 01-14-2022 10:56
From: Mark Shnier (YQC)
Subject: URL formula to to to a result from a query formula field.

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

Original Message:
Sent: 01-14-2022 10:14
From: George Bramhall
Subject: 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
------------------------------

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

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

Original Message:
Sent: 01-14-2022 12:39
From: Mark Shnier (YQC)
Subject: URL formula to to to a result from a query formula field.

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

Original Message:
Sent: 01-14-2022 11:38
From: George Bramhall
Subject: URL formula to to to a result from a query formula field.

still getting "about:blank#blocked"

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

Original Message:
Sent: 01-14-2022 10:56
From: Mark Shnier (YQC)
Subject: URL formula to to to a result from a query formula field.

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

Original Message:
Sent: 01-14-2022 10:14
From: George Bramhall
Subject: 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
------------------------------

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
------------------------------

Original Message:
Sent: 01-14-2022 14:26
From: George Bramhall
Subject: URL formula to to to a result from a query formula field.

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

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

Original Message:
Sent: 01-14-2022 12:39
From: Mark Shnier (YQC)
Subject: URL formula to to to a result from a query formula field.

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

Original Message:
Sent: 01-14-2022 11:38
From: George Bramhall
Subject: URL formula to to to a result from a query formula field.

still getting "about:blank#blocked"

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

Original Message:
Sent: 01-14-2022 10:56
From: Mark Shnier (YQC)
Subject: URL formula to to to a result from a query formula field.

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

Original Message:
Sent: 01-14-2022 10:14
From: George Bramhall
Subject: 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
------------------------------

That was it above: http://https%3A%2F%2Fxxxx.quickbase.com%2Fdb%2Fbn22h7u55%3Fa%3Ddr%26rid%3D7255

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

Original Message:
Sent: 01-14-2022 14:49
From: Mark Shnier (YQC)
Subject: URL formula to to to a result from a query formula field.

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

Original Message:
Sent: 01-14-2022 14:26
From: George Bramhall
Subject: URL formula to to to a result from a query formula field.

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

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

Original Message:
Sent: 01-14-2022 12:39
From: Mark Shnier (YQC)
Subject: URL formula to to to a result from a query formula field.

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

Original Message:
Sent: 01-14-2022 11:38
From: George Bramhall
Subject: URL formula to to to a result from a query formula field.

still getting "about:blank#blocked"

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

Original Message:
Sent: 01-14-2022 10:56
From: Mark Shnier (YQC)
Subject: URL formula to to to a result from a query formula field.

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

Original Message:
Sent: 01-14-2022 10:14
From: George Bramhall
Subject: 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
------------------------------

D'oh, I clearly see the issue now. Get rid of both URLEncodes.

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

Original Message:
Sent: 01-14-2022 16:46
From: George Bramhall
Subject: URL formula to to to a result from a query formula field.

That was it above: http://https%3A%2F%2Fxxxx.quickbase.com%2Fdb%2Fbn22h7u55%3Fa%3Ddr%26rid%3D7255

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

Original Message:
Sent: 01-14-2022 14:49
From: Mark Shnier (YQC)
Subject: URL formula to to to a result from a query formula field.

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

Original Message:
Sent: 01-14-2022 14:26
From: George Bramhall
Subject: URL formula to to to a result from a query formula field.

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

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

Original Message:
Sent: 01-14-2022 12:39
From: Mark Shnier (YQC)
Subject: URL formula to to to a result from a query formula field.

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

Original Message:
Sent: 01-14-2022 11:38
From: George Bramhall
Subject: URL formula to to to a result from a query formula field.

still getting "about:blank#blocked"

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

Original Message:
Sent: 01-14-2022 10:56
From: Mark Shnier (YQC)
Subject: URL formula to to to a result from a query formula field.

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

Original Message:
Sent: 01-14-2022 10:14
From: George Bramhall
Subject: 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
------------------------------

Bingo. Just overthinking things again. Thanks again Mark.

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

Original Message:
Sent: 01-15-2022 12:42
From: Mark Shnier (YQC)
Subject: URL formula to to to a result from a query formula field.

D'oh, I clearly see the issue now. Get rid of both URLEncodes.

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

Original Message:
Sent: 01-14-2022 16:46
From: George Bramhall
Subject: URL formula to to to a result from a query formula field.

That was it above: http://https%3A%2F%2Fxxxx.quickbase.com%2Fdb%2Fbn22h7u55%3Fa%3Ddr%26rid%3D7255

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

Original Message:
Sent: 01-14-2022 14:49
From: Mark Shnier (YQC)
Subject: URL formula to to to a result from a query formula field.

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

Original Message:
Sent: 01-14-2022 14:26
From: George Bramhall
Subject: URL formula to to to a result from a query formula field.

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

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

Original Message:
Sent: 01-14-2022 12:39
From: Mark Shnier (YQC)
Subject: URL formula to to to a result from a query formula field.

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

Original Message:
Sent: 01-14-2022 11:38
From: George Bramhall
Subject: URL formula to to to a result from a query formula field.

still getting "about:blank#blocked"

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

Original Message:
Sent: 01-14-2022 10:56
From: Mark Shnier (YQC)
Subject: URL formula to to to a result from a query formula field.

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

Original Message:
Sent: 01-14-2022 10:14
From: George Bramhall
Subject: 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
------------------------------