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?
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?
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:
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.
May 23, 2020 08:34 AM
May 23, 2020 08:38 AM
@M_k No, I don’t see any PMs from you since our last conversation wrapped in December.
May 23, 2020 02:01 PM
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:
May 24, 2020 06:51 AM
Yeah, this is a problem. Two basic approaches -
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.
May 25, 2020 07:29 AM
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?
May 25, 2020 07:41 AM
Yes yes, it works correctly. Too bad we cannot have it automatically.