Mark down Links with Spaces

[Currently_Jason]

Hi,

I have been trying to add a rich text field and use Markdown Language to create a “Pretty” URL Link

Clickme

I’ve come to realize, after googling that, it will only work using the API. So, I used Integromat to populate a Rich text field with Clickme in it.

The URL is made up fro a concatenated formula ad some of the URL’s have spaces i.e https://www.anywebsite.com/some%20spaces

This is not being created correctly when the URL has a space like this. Is there anything I can do?

I presumed this would be a quick job, it’s not looking that way :frowning:

Any help appreciated

Jason

[Currently_Jason]

It seems markdown works well in the forum (hope it still makes sense)

[Bill_French]

Currently.Jason:

I’ve come to realize, after googling that, it will only work using the API.

You’re speaking of a solution that looks like this, right?

[Currently_Jason]

Hi Bill,

Yes. I have the Hypertext created but the URL link behind it has spaces in so the link fails but also when dropped onto the report, it shows as the Markdown txt

[Translate][1] [1]: https://translate.google.com/?

[Bill_French]

Currently.Jason:

the URL link behind it has spaces

You have to remove these spaces because it’s technically not a URL until it is properly encoded. I believe you need to use this formula function to do that (if creating the links by formula).

ENCODE_URL_COMPONENT()

[Currently_Jason]

Still not working for me. I have recorded a Loom as I am probably doing a bad job of explaining myself.

Hope this helps

[Bill_French]

Currently.Jason:

I have recorded a Loom as I am probably doing a bad job of explaining myself.

You’re doing a find job of explaining the issue.

Here’s what’s happening (I thinkl)… when Integromat reads the content from Airtable it is unencoding it, thus eliminating all the great work you did in Airtable to properly encode the data.

When I mentioned that the URL needed encoding, the implication was that it would either occur when building fields that contained the URL in Airtable, or when any other external process generated such URLs; in this case, Integromat.

Integromat supports functions and formulas much like Airtable - indeed, the string functions include encodeURL and this would likely be the place to perform the encoding before updating the data back into your long text field in Airtable.

I have almost zero experience in Airtable but @cor has plenty. Perhaps he can guide from this point forward.

There’s at least a coin flip probability that you can achieve this without going around the barn into Integromat by using a simple Airtable script block to update the long text field (with fully encoded URLs) and in a format that looks as pretty as you’ve achieved with Integromat.

I realize you don’t have a lot of script experience and I am slammed for the next two weeks. But I recommend you make a plea in the Script Block category for a very simple ask that goes something like this:

Help! New Script Block User Trying to Learn Basics!
Need a script block that reads a URL field from each record and writes a long text field with a pretty Markdown link.

I’ll bet someone will see that as a challenge and lend a hand.

[cor]

Morning,
Thanks for the tag @Bill.French

@Currently.Jason perhaps we can do a quick call to look at your integromat scenario? And if successful you can report back to your post. If not successful we can both act like the call never happened :upside_down_face:

But I do agree with @Bill.French this should be very simple using the script block and new automation triggers (if you have a paid plan).

I will DM you my contact details.

Chat soon

Cor