Help

Button URL formula with cell value contained in the url

Topic Labels: Formulas
Solved
Jump to Solution
3049 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Metalflex_Wagga
4 - Data Explorer
4 - Data Explorer

Hi All,

I am trying to create a button that one clicked will launch a web page that uses an internal url (or external) as the prefix with a cell value as the suffix.

For Example:

https://trsau.reecenet.org/pos/other-stock-on-hand/products/12345
The first part (https://trsau.reecenet.org/pos/other-stock-on-hand/products/) will be common in the formula with (12345) being the part that changes.

To achieve this i have been try to us the following formula:

image

The issue is that once pressed the i get the following error in the address bar.

image

1 Solution

Accepted Solutions
Jeremy_Oglesby
14 - Jupiter
14 - Jupiter

Hi @Metalflex_Wagga

Anything you put inside quotation marks in a formula is translated literally - thus, your URL is being populated with the unicode for “{” (%7B), the text “REECE”, and then the unicode for “}” (%7D).

You can use the concatenation operator (&) to add dynamic values, like the value in your field named “REECE”, to a literal string. That would look like this:

"trsau.reecenet.org/pos/other-stock-on-hand/products/" & {REECE}

See Solution in Thread

2 Replies 2
Jeremy_Oglesby
14 - Jupiter
14 - Jupiter

Hi @Metalflex_Wagga

Anything you put inside quotation marks in a formula is translated literally - thus, your URL is being populated with the unicode for “{” (%7B), the text “REECE”, and then the unicode for “}” (%7D).

You can use the concatenation operator (&) to add dynamic values, like the value in your field named “REECE”, to a literal string. That would look like this:

"trsau.reecenet.org/pos/other-stock-on-hand/products/" & {REECE}

You are a gentleman and a scholar. It seem so simple now. :slightly_smiling_face: