Button URL automation problem

[Metalflex_Wagga]

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:

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

[Jeremy_Oglesby · Accepted solution]

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}

[Metalflex_Wagga]

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

[Valerie_Miles]

THANK YOU!! I just had the lookup filed inside the quotes.  Learned something today that I can use across many other button fields.