
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 23, 2020 02:57 AM
When I print a view that contains links, they are not clickable in the PDF result. How to achieve that?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 23, 2020 05:04 AM
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?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 23, 2020 05:19 AM
Oh, the problem is I’m using the LOOKUP type to display such links, and they are not clickable then :confused:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 23, 2020 06:46 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 23, 2020 08:34 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 23, 2020 08:38 AM
@M_k No, I don’t see any PMs from you since our last conversation wrapped in December.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 23, 2020 02:01 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 24, 2020 06:48 AM
It’s a shame that Airtable doesn’t support fields that also have formulas as an attribute. :slightly_smiling_face:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 24, 2020 06:51 AM
Yeah, this is a problem. Two basic approaches -
- 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.
- Create a script block that copies the formula links into a real field.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 25, 2020 12:42 AM
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.
