I am generating an invoice through PDF Monkey and saving it in Glide. The customer, on their end, can then generate a list of all their invoices and the Transactions get sent to them via a CSV file which has the Date, Transaction Type and Invoice. Currently the link is showing up as “https://storage.googleapis.com/glide-prod.appspot.com/uploads-”, is there a way to make a new column that can shorten/rewrite this link so I can send them that column instead and it just looks neater?
TDLR; is there a column to change/shorten a URL link?
2 ways you can achieve this:
- There is a integration named “Shorten URL” in glide.
- You can use a template and create a href tag in the template and show that column in richtext. Should work seamlessly.
So the invoice currently gets generated as a PDF and stored, this is the text being used to convert it with an href tag:
However the statement then gets sent as a CSV, including a link to the PDF. This is how it shows up in Excel:
Is it because CSV is plaintext not richtext or am I missing something?
Since you want it to come back as a CSV you can try the “Shorten URL” integration. The template solution is good for showing things in the Glide app itself.
2 Likes