Button URL formula with cell value contained in the url

Question

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 Answer

Hi @Metalflex_WaggaAnything 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 · Answer

Hi @Metalflex_WaggaAnything 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:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded