Have you tried using multiple URLs in a Long Text field?
Have you tried using multiple URLs in a Long Text field?
Yes, and it’s clunky and frustrating, they can’t be clicked/opened easily, etc. I really need each link to be its own entity and not part of a block of text.
Natalie:
Something that might work.
We are a theater. We have productions(plays) and often have multiple online reviews of our shows.
I thought I could solve the multiple URL problem by having a URL table with autonumber primary column. Column 2 is multiple links to the production table entries and column 3 is the single URL .
A show with multiple reviews has a row per review/URL.
Then, I added a Lookup column to the production table pointing to the URL table.
When a new review comes in, I just add it to the URL table and voila, it shows up when people access the production.
Yes, a little clunky and still limited when the lookup URLs column won’t expand so you have to expand the whole row to see all the URLs if there are several.
Maybe there are even better solutions.
Good luck.
I also need to list multiple live URLs in the same field. I was going to try to list each one separately in a field, then create a formula which would display all of them in one field. Is there a formula for this?
I also need to list multiple live URLs in the same field. I was going to try to list each one separately in a field, then create a formula which would display all of them in one field. Is there a formula for this?
Once you have the individual URL fields, you can concatenate them with the newline
character, '\n'
, as a separator, like so:
URL1&'\n'&URL2&'\n'&URL3&'\n'&URL4&'\n'
; in conjunction with Airtable’s new adjustable row heights, this will let you stack up to four active URLs in a single field. Note it remains a two-click action: {Click 1}
selects the field instance; {Click 2}
opens the targeted URL.
You can also use newline
as the designated separator in a rollup field with the ARRAYJOIN()
aggregate function:
ARRAYJOIN(values,'\n')
Once you have the individual URL fields, you can concatenate them with the newline
character, '\n'
, as a separator, like so:
URL1&'\n'&URL2&'\n'&URL3&'\n'&URL4&'\n'
; in conjunction with Airtable’s new adjustable row heights, this will let you stack up to four active URLs in a single field. Note it remains a two-click action: {Click 1}
selects the field instance; {Click 2}
opens the targeted URL.
You can also use newline
as the designated separator in a rollup field with the ARRAYJOIN()
aggregate function:
ARRAYJOIN(values,'\n')
Thanks for this info! I have dozens of urls to keep track of for each client on one record. Social media profiles etc. that can number up to 20+. Would this method still work? If so, can you help outline it a bit more step by step as I am new to Air Table and haven’t used the formula or rollup field type before.
If I understand correctly, I’d be limited to listing just 4 live URLS?
I was thinking of creating an evernote file then upload as an attachment for each client, but whenever the evernote file is updated, it will require me to re-upload the file.
What would you do for a solution to this issue? Thoughts on a better way? Much appreciated!
Thanks for this info! I have dozens of urls to keep track of for each client on one record. Social media profiles etc. that can number up to 20+. Would this method still work? If so, can you help outline it a bit more step by step as I am new to Air Table and haven’t used the formula or rollup field type before.
If I understand correctly, I’d be limited to listing just 4 live URLS?
I was thinking of creating an evernote file then upload as an attachment for each client, but whenever the evernote file is updated, it will require me to re-upload the file.
What would you do for a solution to this issue? Thoughts on a better way? Much appreciated!
Sorry for the delay; wanted to double-check before replying.
If the URLs are relatively static — that is, they don’t change often, which appears to be the case with yours — I’d probably just define a Long Text field called {ClientURLs}
(or whatever). You could then enter essentially unlimited URLs in the field, each as its own line.
This isn’t a solution that would work for everyone — and it might not work for you. However, from your description I assume you are a social media facilitator/proxy/ghost for your clients, where your value-add comes from your content rather than, say, the sheer volume of transactions. (If you are a Twitter bot, this solution may not apply.) Accordingly, having to click twice to activate a URL, for instance, should not be enough of a downside to outweigh the benefits of managing your workflow from a single base.
With row height set to maximum, you should be able to display 6 (not 4) URLs in a field. Any of those URLs can be selected with a two-click process: The first click ‘activates’ the field, making the URLs clickable links; the second click opens the URL in a new tab.
Not you are not limited to 6 URLs — it’s just that a maximum of 6 will show in the row. URLs 7 through infinity(ish) can be accessed by opening the Long Text field. (This adds a couple of additional clicks to your process, so you should toss something together to make certain you can live with it before committing to the base.) To open a URL not in the first 6, you would
- Click in the field to activate it.
- Instead of clicking on one of the URLs, click on the double-headed arrow icon (’
⤢
’) in the upper right of the cell. This will expand the field.
- Click on the URL you wish to open. Hah! Fooled you! Instead of opening (even though it is highlighted as if it is an active link), a URL pop-up appears.
- Select the URL pop-up, and the URL opens in a different tab.
If I’ve misread your needs, let me know, and I’ll try to respond more appropriately.
Thank you so much for the detailed reply. I have been using the long text field and it is is working very well for what I need!
Much appreciated!
I think this topic should be included in Feature Request. I also needed that and it could be simple for the developers to make this.
Once you have the individual URL fields, you can concatenate them with the newline
character, '\n'
, as a separator, like so:
URL1&'\n'&URL2&'\n'&URL3&'\n'&URL4&'\n'
; in conjunction with Airtable’s new adjustable row heights, this will let you stack up to four active URLs in a single field. Note it remains a two-click action: {Click 1}
selects the field instance; {Click 2}
opens the targeted URL.
You can also use newline
as the designated separator in a rollup field with the ARRAYJOIN()
aggregate function:
ARRAYJOIN(values,'\n')
I know this is old but can someone explain in detail how this works. Newbie here. Thank you.
I know this is old but can someone explain in detail how this works. Newbie here. Thank you.
Yes I need help too. Is there an update to doing this?
+1 for this as a necessary feature
need multiple URL option as well!
You can use a Long text field with Rich formatting enabled:

Then you can add rich text with as many URLs as you like: select text, press Ctrl+K to open the Add link pop-up.
