Show png/jpg URL as image?

Josephine · 11-16-2020 01:20 PM

Hi!

I have created an app that we are using for invoice processing, which also uses Zapier - email comes in to our invoices@… address, Zapier checks if it has an attachment, and if so adds a record to a spreadsheet and stores the attachment in drive.
The invoice attachment can then be processed through AppSheets and checked before payment - that’s all working fine.

But, we are getting lots of little png / jpg attachments (e.g. facebook / twitter icons) which should be deleted. I could expand Zapiers rules to exclude those, except every now and then we’ll have a vendor who will take a picture of a handwritten invoice and send that through, so we run the risk of losing them.

My thoughts were to create a card view which would preview the png / jpg images, and the team could easily reject / process them based on that. I’ve used some information found at https://help.appsheet.com/en/articles/2155495-how-to-display-videos-and-images-in-your-app and https://help.appsheet.com/en/articles/961605-displaying-images-and-documents, however I get a 404 error.

I have set a virtual column as an image and used this formula:
CONCATENATE( "https://www.appsheet.com/template/gettablefileurl?appName=", ENCODEURL("SCCIPDevelopment-1667690"), "&tableName=",ENCODEURL("New Invoices"), "&fileName=",ENCODEURL([Filename]))

Any ideas on how I can make this do what I want? Highly possible that it’s something glaringly obvious that I’m missing!

Thanks in advance

Eric_White

Hi Jo,

Where are the images being stored, from your text I am assuming they are copied to Drive.

As mentioned in the docs you reference. you need to use the “get sharable link” to get a public url.

Josephine

Hi @Eric_White
The idea is that I don’t have to manually get a shareable link for each item, as that will be too onerous and negate the aim of deleting through the app.

Attachments (pdf, jpg, etc) are stored in Drive automatically. PDFs are fine to be viewed as they will go through the normal invoice processing queue. Images however will clog up the list, so my thinking is that image-type files are able to be seen visually in another view where they can easily be marked as an invoice or not.

So, basically I’d like to use the google link (e.g. https://drive.google.com/drive/u/0/folders/…) to be converted and shown in an image column.

Does that help to clarify?

Thanks

Eric_White

It clarifies that I think that is the issue with displaying the images.

As stated in the doc you referenced. the doc link created during the upload of an image is not visible to external apps/people. as google redirects based on authentication.

Only the sharable link is visible to the app.

Not a helpful answer but that is the issue I think.

Josephine

Ok I guess I am now just seeking clarification:
Is there a way to show a thumbnail / preview of a Google Drive document, in AppSheets?

Perhaps @LeventK, @Steve, @Aleksi might be able to advise?

Marc_Dillon

Nope.

Unless you can generate the thumbnail image some other way (like manually), and link it to the same record.