Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Button URL formula with cell value contained in the url

Topic Labels: Formulas
Solved
Jump to Solution
616 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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: