I wish to create Metadata Reports that include a URL to the actual document in each row.
The only way I have found to ahcieve this is to include the Entry ID on the export (column A), insert a column with the starting part of the URL (column B), combine the data from columns A and B in a formula to produce the URL link in column C. Although I can create a teamplate with a macro and then copy the export to the template to speed up this process, it is still manual and cumbersome. Is there a better way?