Is there a way to generate a pdf via a workfl...

AppSheet AppSheet Q&A
1

Is there a way to generate a pdf via a workflow but have it store in the record instead of being emailed?

I ran into an issue with regard to “who” the email would go to and we can not use generic email accounts.

Need an alternate way to get them access to the pdf so they can open it and print.

Any suggestions would be appreciated.

Thanks

2

@Tammi_Canelli Create File type column and with an AppFormula construct the full path of your PDF file within the same table that you create the WF. In the WF send the email to yourself as you cannot leave the recipient field blank. The file will accessible thru the app, users can open the file from their desktop browsers and either print it from there directly or choose to download & print.

3

Is that for already existing files?

The pdf wouldn’t be generated until a certain action happens in the app.

Currently the workflow is setup to email after the person is checked in.

4

@Tammi_Canelli It is for newly generated PDF workflows. To make it work with the older records, you shall manually construct the exact file path and record in that FILE column directly from the gSheet itself.

5

Siguiendo Translate

6

@Tammi_Canelli

Basically I’m talking about this. Pay attention to the marked-up area where the PDF file links are. The Open File system action next to the field text, opens the PDF directly in the browser. The PDFs are generated by a WF rule, emailed to the admin and there’s an inbox rule in the admin’s mailbox which deletes and trashes-out the email received.

File links are auto-created by an AppFormula with a simple CONCATENATE function.

To create file links for your existing records in the gSheet, you can also do the same with an ARRAYFORMULA and CONCAT function combination. Than you can COPY the range and then PASTE AS VALUES.

7

Will this work if using a SQL db or does it need to gsheet or smartsheet?

8

@Tammi_Canelli with SQL, all the blobs (images, files, etc.) will be in the cloud associated with your AppSheet account. So it should work the same.

9

following. I’ll be needing this on my next app

10

Levent_KULACOGLU:

@Tammi_Canelli Create File type column and with an AppFormula

Old thread, but How would one create this link?
I would to Create PDFs on form save via workflow and than set the link to the view in the Column of the corresponding row, just not sure at all how one would create the link.If anyone has done this before would be extremly thrilled if you could share some insight.

11

@Jonathan_S
Add a second step to the same PDF workflow with webhook option using preset AppSheet Edit Row option with a simple payload:

{
	"Action": "Edit",
	"Properties": {
	   "Locale": "en-US",
	   "Location": "47.623098, -122.330184",
	   "Timezone": "Pacific Standard Time"
	},
	"Rows": [
		{
		"KeyColumn": "<<[KeyColumn]>>",
		"FileColumnn": "<<_ATTACHMENTFILE_URL>>"
		}
	]
}
1 Like
12

wooaaa.

This is completely new to me.

Locale? Im in Canada, how would that work
Location?
Timezone? Im EST

13

Makes no harm actually:

3X_c_f_cfb51824896941a0ad2bd1ab84791aecf39cdac4.png
3X_c_f_cfb51824896941a0ad2bd1ab84791aecf39cdac4.png1290×228 16.5 KB

But if you want you can change it to > “Timezone”: “Eastern Standard Time”

14

Ok, but the attachment url?

This is generated from appsheet with the workflow?

Also, this payload that your talking about. this goes in the Body of this Webhook?

15

@Jonathan_S

3X_3_4_34586f246086a4ba0efe02dd9295f125a40b19b2.png
3X_3_4_34586f246086a4ba0efe02dd9295f125a40b19b2.png1574×1509 185 KB

Worth checking docs below

1 Like
16

Let me dig into this alittle. Think I found another gold mine.

17

Enjoy my friend