PDF Export and Sync Problem - Have You Ever Faced This?

AppSheet AppSheet Q&A
, ,
1

Hi fellow developers, I hope you are doing well :)!

I am working on maintaining an application which was developed by another AppSheet developer. However, the app was partially developed once I was assigned to take charge of the app instead of the other developer.

[CONTEXT]

We have a table called Toolbox_Meeting in our app, where our company creates and submits the meeting form for auditing purposes in the future.

Thus, we do need the app to export a PDF file containing all the information retrieved from each meeting form submitted.

After submission, we will navigate to another tab called Monitor, this is where all the form submissions are shown as PDF files so that we can click the PDF button and download the files.

image
image1855×553 67.7 KB

____________________________________________________________________________________

[CURRENT ISSUE]

The issue that my users are currently facing is that:

  • If the users open “Monitor” tab and click on the PDF button. The PDF file does not show all the signatures of that specific toolbox meeting submission, it just shows only one signature of the one who created the form.

image
image578×792 42.2 KB

  • The users need to manually go to the “Toolbox Meetings” tab, click the “Create PDF” button, then a “Download PDF” button shows up, they click on it, and the PDF file now includes all signatures of who attended that toolbox meeting.

image
image506×802 39.2 KB

____________________________________________________________________________________

[QUESTIONS]

The thing is, this issue only happens with the Toolbox Meeting tab, other tabs on our system still can generate correct PDF files with full signatures expectedly, which is quite unusual to me.

I’m honestly not sure what is going on with the app backend and I have been trying to figure it out but it won’t work.

Have you ever faced an issue similar to this before?

Your answer and any suggestions would be truly appreciated!

Thank you so much :smiling_face_with_tear:

2

Hello @Lan_Nguyen,

Welcome to the AppSheet community!

It looks to me like the paper size is different for each one of the screenshots and the system is cropping the last part of the page. Please try the following steps in your AppSheet editor to configure your PDF page settings:

Navigate to the Task: Go to Automation > Tasks and select the specific task responsible for generating your PDF.

Verify Attachment Content Type: Under the settings pane, ensure the HTTP Content Type is explicitly set to PDF.

Set the Page Size: Locate the Attachment Page Size setting and select your preferred standard format (e.g., Letter, A4, A5) from the dropdown, or choose Custom.

Define Custom Dimensions (Optional): If you selected Custom, input your exact Attachment Page Width and Attachment Page Height in millimeters.

Note on Page Orientation: The layout orientation (Portrait vs. Landscape) is controlled directly by the design of your underlying template document (Google Doc or MS Word), rather than the AppSheet editor settings.

I hope this helps!

3

hi @Lan_Nguyen

Can you provide a screenshot of your pdf template (your google doc)? or check this link Learning AppSheet from YouTube and the AppSheet Community (Tutorial Links)

look at the automation in appsheet section, maybe there is something useful there.