How to print linkable URLs?

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?

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.

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.

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,
    });
}

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?

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