Generating a PDF version of forms filled though AppSheet

[Justlookinghere]

Hi everyone,

I was wondering if there's a method to generate a PDF version of a form filled through AppSheet. In my AppSheet application, there are several questions needed to be answered in the form and I also provided an option where the user can upload several images. I was wondering if it's possible for the individual forms along with the attached images to be generated as a PDF version of it. Basically taking a screenshot of the filled forms (along with the uploaded images) but in actuality is a PDF version.

Thank you everyone!

[Suvrutt_Gurjar · Accepted solution]

Yes, you can create a PDF of the filled form using BOT with all images , but not as a "screenshot" of the form but as a PDF created through BOT template.

The below article is on Workflows that have been superceded by Automation but the concept is described well.

https://help.appsheet.com/en/articles/961707-workflow#sending-email-from-an-action-button 

[Justlookinghere]

Thank you for the response, I did manage to get a PDF version of it through the BOT. I'm wondering, is there an action button which we can set in the form view for users to get the PDF generated through the BOT?

[Suvrutt_Gurjar]

You cannot have actions in form view. You could set the action to invoke on form save event though.

https://help.appsheet.com/en/articles/1013286-view-events

[Justlookinghere]

I'm not too sure how to go about with this, but is the way to invoke the action to view the PDF after the bot has been triggered to generate the PDF view?

[Suvrutt_Gurjar]

Could you please mention, is your first requirement of firing the PDF BOT answered?

Is this subsequent query? The two are totally different and hence the query please.

[Justlookinghere]

Yes, the first requirement of firing the PDF BOT has been answered and the file saved into my Google Drive which I've set to Updates_Only. Sorry for the subsequent query. 

[Suvrutt_Gurjar]

Hi @Justlookinghere , thank you. You need not be sorry, just wanted to ensure the queries are different. There are ways to see the files saved in the folder.

Of late ApPSheet allows GDrive to be be set up as folder. Please explore if that helps. Or else there are more ways but with little more complex implementation. You could set up your PDF folder as a table to be accessed in the app.

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Document-Processing-Folder-as-a-Table/m-p/28319...

[Justlookinghere]

I have a subsequent query again @Suvrutt_Gurjar , how many PDF files can a BOT generate at one time? I have a table and had set a conditional filter to only generate files based on the condition and when I test run this one table (containing 47 files), it only generated up to 25 files. I was wondering if there's a limit for a BOT to generate files within the Scheduled time.

[Steve]

The test feature has definite limits. A normal run would not be limited.