Help

Re: How to print linkable URLs?

1478 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Kamil_Lelonek
5 - Automation Enthusiast
5 - Automation Enthusiast

When I print a view that contains links, they are not clickable in the PDF result. How to achieve that?

11 Replies 11
M_k
11 - Venus
11 - Venus

Hi @Kamil_Lelonek

I managed to find a thread of posts that might help.

Hope this might help.

Mary Kay

If this does help, can you type SOLVED in the subject line?

Kamil_Lelonek
5 - Automation Enthusiast
5 - Automation Enthusiast

Oh, the problem is I’m using the LOOKUP type to display such links, and they are not clickable then :confused:

In the article that @M_k linked, it was mentioned that formula-generated URLs would also create clickable links in PDFs, so I thought it might work to pull the URL from the lookup field via formula. However, something has changed since then, and this is no longer the case. I ran several tests, and could only get a live link using an actual URL field.

Hi @Justin_Barrett

Thank you.

I sent you a PM last week. Did you get it?

Mary

@M_k No, I don’t see any PMs from you since our last conversation wrapped in December.

Hi @Justin_Barrett

I just sent you a PM. Hopefully you got it.

Mary

It’s a shame that Airtable doesn’t support fields that also have formulas as an attribute. :slightly_smiling_face:

Yeah, this is a problem. Two basic approaches -

  1. Create an external API process that either builds your PDF from scratch (Google Apps Script can do this), or pre-populates (and sustains this population) of link fields that are not actual formula fields.
  2. Create a script block that copies the formula links into a real field.
Kamil_Lelonek
5 - Automation Enthusiast
5 - Automation Enthusiast

What I did was:

let table = base.getTable('Plany');
let view = table.getView('Grid view');
let result = await view.selectRecordsAsync();

for (let record of result.records) {
    let link = record.getCellValue('Link')[0];
    await table.updateRecordAsync(record, {
        'URL': link,
    });
}

Let me know whether that’s correct.

Only you can decide if it’s correct because we cannot see your table or the data types of the fields. Does it work when you run it?

Kamil_Lelonek
5 - Automation Enthusiast
5 - Automation Enthusiast

Yes yes, it works correctly. Too bad we cannot have it automatically.