Save an email attachment to a "related Documents" table within the app

I have built an app with a “Customer” table. I also have a “Documents” table that is related to the Customer i.e. (Related Documents).
I generate an email (with attachment) through “workflow”.
I want to save the attachment PDF to the related Document.
Is this possible?

fenapp:

I want to save the attachment PDF to the related Document.

What do you mean? Please elaborate.

1 Like

My app has a “Customer” table
I have workflow rule to send an email with a PDF attachment.
I need to save the PDF attachment to a table “Documents”
(The Documents table is related to the Customer table).

I may advise start reading from here initially:

[Guide on How To Create a Community Post](https://community.appsheet.com/t/guide-on-how-to-create-a-community-post/35855) Tips & Tricks ?

Dear valuable members and users, For a long time I’m seeing a lot of multiple and concurrent posts, posts like novels seeming to aim the Pulitzer Price, exactly the same questions by the same user but paraphrased/re-phrased etc. Being a dedicated community member and an AppSheet developer who is reading around 2.5K posts per day, I urged myself to tip on some good advice and best practice BEFORE posting something in the community: #1 - APPSHEET DOCUMENTATION AppSheet has a very good help do…

And then perform some research…

[Attachment template incorporate to his refferal row](https://community.appsheet.com/t/attachment-template-incorporate-to-his-refferal-row/17098/2) Questions

Saving the files, pdf, images, word and/or excels which Appsheet support to save are always go to the default cloud service provider you define. When you set up your workflow to email to someone, then make sure to set attachANDarchive. Then whenever the workflow is triggered, i.e. email is sent then the same PDF file is saved in your cloud service. To get the path automatically to those file, please generate the virtual columns, with expression which construct full path (URL) to that file. T…

[Retrieve URL to Appsheet-generated PDF](https://community.appsheet.com/t/retrieve-url-to-appsheet-generated-pdf/19897) Questions

I wasn’t able to find something on this, though that might likely be on me, however: How do I get the URL to a PDF that AppSheet automatically generates through a workflow? In particular, I’d like it so that whenever I add a row to a table, which has a workflow attached to it that generates a PDF, the URL to that PDF should be stored in the same row in that table (in a specific column of course). Of course, in the workflow rule, I have the (relative) path to the folder where the PDFs are stored…

[What is the best way to retrieve and view files in app that are generated from templates?](https://community.appsheet.com/t/what-is-the-best-way-to-retrieve-and-view-files-in-app-that-are-generated-from-templates/13284) Questions

I use workflows to generate and send customer pdfs from templates in Google. Currently, I use the archive option to save the generated result in the default location in Google with the current timestamp to ensure file name uniqueness. When certain record info changes, a new file is generated with the updated details and saved as a new file. I would like to be able to retrieve the history of all saved files associated with a certain record and display them in the app - as a list or gallery. W…

3 Likes