Skip to main content

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.


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}

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

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}

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

 

Reply


Terms & Conditions