Appsheet Episode 15: How to generate PDF using Automation.

[@ЯрославСаган-э9т]

Супер. Дякую за відео!

[@GuidoADELFIO]

You're great! As usual!

[@aris_azhar]

You're the best!

[@alhajaboahmad]

good,,,,great god job

[@aris_azhar]

Thank you! 😃

[@ganeshramu5083]

Thanks to you Good presentation I tried and worked good

[@aris_azhar]

That's great news Sir Ganesh! I am happy it worked out well for you.

[@clarae1781]

Good video, thanks!

[@aris_azhar]

Glad you liked it!

[@mgskpgamage]

Great tutorial ❤️❤️

[@aris_azhar]

Thank you! 😊

[@weilungchen5835]

Great tutorial, very clear steps and easy to follow. Thank you for sharing this!😃

[@aris_azhar]

you're most welcome ! happy to see you here..thank you!

[@niroshansenevirathne7854]

Awasome , very clear presentation wish you good luck bro.

[@aris_azhar]

Thank you Niroshan! Happy to see you here..appreciate the kind words and support

[@glauterlima]

Thanks a lot!

[@aris_azhar]

You're welcome! Anytime...Hope you find the videos useful.

[@SteveWeaver-d8n]

Great video. Can you tell me please - how do I get the Bot to return all my Table data in the PDF report? (I have a table with 30 questions/answers, but your demo Bot only shows the latest, updated entry in the PDF report, not all 30 entries). Thank you.

[@aris_azhar]

Hello! thank you for sharing me this. I think this can be address on my next video i'm posting today..stay tuned!

[@MichaelAngeloAcorda-s4y]

Deserve a like and share.

[@aris_azhar]

and you deserve all the good things in life! thank you!

[@ronaldo.garetti]

obrigado, mesmo sem entender sua língua, conseguir resolver meu problema

[@aris_azhar]

você é muito bem-vindo! estou feliz por poder ajudar

[@ChrisParent-x8z]

Thanks for this video! I have adjusted the format in a new template, but since doing so, it seems it is no longer creating the PDF when I update information or even add a whole new entry. Any ideas why?

[@aris_azhar]

I am assuming something must have break in between the code which is a good sign that you're in the right direction. We just need some extra tweaking.. perhaps share with me your template so that i can have a look? some insights of your table structure would help too

[@ChrisParent-x8z]

@@aris_azhar Thanks for the response. I believe my issue was with my formatting. I was able to get it figured out. I am, however, wondering if you know of a way to apply different color coding to responses in the PDF based on responses. An example would be for some Yes or No question prompts that are answered.

[@aris_azhar]

That seems possible, in fact very interesting thought you have there good Sir..let me see if i can work out one tutorial for you

[@ChrisParent-x8z]

@@aris_azhar That would be amazing!

[@TamaNikodemus]

Thanks for your info its very useful, but i have difficulty to set the PDF file to have a fix header and footer, when i entered a long data (in this case to create a sales quotation) the table is so long but the header that a set up doesnt repeat it self on the second page. Please help

[@Amirsoll]

Hi Bro, great video ! WTA, do you happen to know how to generate 2 pdf in one email using the bot? is it possible or not?

[@missnisa91]

Good sharing sir. But i have little problem and i hope u can help me. I'm tried to make multiple sheets with header in a single PDF. But Appsheet only generate PDF document 1st page only with header and the rest without header. Can u help sir?

[@arpa1520]

good👌 It is possible to create a PDF file that contains multiple pages. For example, if an invoice has 5 items, I need to create 1 PDF with each of those individual items, and for the PDF to have the 5 individual pages to be able to print all the labels for each item. that bill?

[@aris_azhar]

Sounds like an interesting concept! Do you have a mockup that you would like to share? email it to me [e-mail] and i will have a look what can be done for this

[@arpa1520]

@@aris_azhar I sent you a idea

[@edel-optics.dearena3616]

Thanks for the tutorial. How do I store PDFs in my OneDrive?

[@williamholloway464]

Great video! I was able to get the pdf to generate, but I could not get AppSheet to locate the file in Onedrive. Any help?

[@compostae]

s it possibe to use a Power point ouExcell document as Template ? Or Only Word ?

[@MrImGaBo]

Ty, please example with Google Drive Link

[@aris_azhar]

i will look into it sir!

[@bohdanstyslo]

Please help: I can't create a direct link to a Google Drive directory. Specifically, the "Direct link" / "File name" construction isn't working.

[@aris_azhar]

Sorry to hear that. Anyways good news for you..i've made a new video for PDF (Gdrive) edition. Check this out kzbin.info/www/bejne/bGbMqZR5itmSj5o

[@sengthongvernavong9778]

Hello, I would like to ask a question. When generating a PDF and now we go back and edit the AppSheet data and generate it again, it is still the old data. What should I do?

[@aris_azhar]

Hello there! if i were to be in that situation, basically two things to check, 1) The trigger event for the both. Whether it is based on data change or schedule. If data change, what is the condition that is required for the trigger eg: Timestamp=NOW() etc 2) To check whether the PDF is overwriting the old file or generating a new one. To check this, ensure "Disable timestamp" is selected. Let me know if this is the case.

[@vernavong]

I don't understand what's you mean? Do you have a simple video for suggestions? Please

[@fiblondenacci]

Hi tq for tutorial. However, this can only generate when a user updates the table. What if, I want to generate a report on demand? Meaning, a button where it just prints the whole info on the table and create a pdf. Tq kindly.

[@aris_azhar]

You can do similar by just creating an action that generates a PDF on demand..i will do a video on this this week just for you.

[@DieterClaessens-ex1rm]

great tutorial, could i cnatact you for a specific problem i got?

[@aris_azhar]

Sure thing! What's the problem youre facing at the moment?

[@muhammadfadhlilaziz]

Hi, are you have tutorial to print multiple data rows with generate PDF ?

[@Program_Improvement]

Great tutorial! Is there a way to email the PDF template directly to the user instead of sending it to Google or One Drive?

[@Laboratorio-j3n]

Muy buen tutorial, lo malo es que debes de copiar el link por cada registro y pdf si lo quiere visualizar de la app u escritorio.

[@MingAnIsAwesome]

Great tutorial bro, how can I store the files in OneDrive Biz as shown in the video above?

[@aris_azhar]

Thank you! anyways, for my case is by default since my account is created via microsoft. But if you're using google or others instead, simply set the file path in your automation to the OneDrive path.

[@marziahabdulwahabktn3458]

any tutorial how to create "Share" button ?

[@pepepopnpn]

Perfect! I just need this tutorial. I have 2 questions relating to it: 1. How do we connect google drive if drive locates files using unique url per document instead of file name? 2. Is there a way to generate pdf of the list (in your example the Employee Data view) instead of the individual profile? Thanks heaps 🥳

[@pepepopnpn]

I found the tutorial for gdrive connect. Will watch it ✌️

[@AlutracoNiger]

HELLO Mr Aris. Thank you for the tutorial. I have two tables with parent and child configuration, so when try to print a pdf when adding data in the parent table, the child table does not appear in the pdf. Could please you explain to me why? thank you

[@NasserGabaj]

I follow your steps all the way till I pasted the link for the file, that's where I'm lost, onedrive is not allowing me to copy the path :(

[@Yagnik_Sojitra]

Do we need any paid subscription for this ?

[@AlMuradTech]

Can we Open xlsx file in another tab like pdf file ?

[@AlMuradTech]

it ask to save the xlsx file and download it but can we just open the file in another tab

[@marcohama1]

I want to use image as background, i test text lose format

[@Zaizen182]

Please help me, when I try to create it for a data type other than text, why doesn't it appear?

[@2519Tim]

Dear Sir, I would like to ask about the PDF file after export have a not same original, because in doc have pictures input togather, when picture have rotate to landscape , How to fix flame picture and positioning. please kindly comment solution Thanks in advance.

[@valdirdespesassantos]

How do I read only the first line, how do I make this condition

[@yavuzusullu]

Hello sir, How can i save to pdf file in my phone? I don't wanna save on my drive sir.

[@aris_azhar]

i will look into some options for you and share back soon! sorry for my late response brother

[@yavuzusullu]

@@aris_azhar ty my friend🙏

[@yavuzusullu]

@@aris_azhar Still waiting :*)

[@aris_azhar]

@@yavuzusullu Oppsss sorry for my late response, was kindda away the other week. Anyways, for your case.. the PDF file generated will automatically be saved into your drive regardless. But to save it to your phone, use the "FILE" url type and set the directory of the file path into the column so that you can open the PDF file from the app. From there, open the PDF file and save it to your device. Alternatively, you can use an email action (Create an action that will email to you or any email column) and use automation that will trigger when to initiate the action. Another option that i would take is using the telegram bot since they can store the file with no issues. Create a group and set the automation to send the pdf file there.

[@yavuzusullu]

@@aris_azhar thank you so much bro. I will try it

[@infoguiahn]

Hello, How can I generate the PDF from an action button?

[@stefaaneeman]

While opening file I always get the message “bad request” what am I doing wrong?

[@aris_azhar]

My assumption for now would be invalid URL..can you confirm whether the PDF file is being generated in any folder that you've set?

[@stefaaneeman]

@@aris_azhar I’ll check it out, thx.

[@stefaaneeman]

How can I find the path if I use Dropbox?

[@AdityaMittalMIS]

How to add pdf link if using Google Drive

[@mdjewelmolla7007]

How to create post system in Google appsheet

[@ismaelsilva5948]

Oi bom dia fui tentar colocar URL pasta file não está abrindo links

[@andruskumel3144]

Great tutorial. I did get all previous stepst done. PDF is created and sits in Google drive. That part works well, but when I try to open PDF from app I get 400. That’s an error. The server cannot process the request because it is malformed. It should not be retried. That’s all we know. I double checked the expression and I changed File URL and [Name]. Everything looks fine. No errors. When I remove .pdf" from formula. Opens nicely Google drive folder that contains PDF, but with the end .pdf" it shows error.

[@mradelphi02]

I have the same issue. Can someone help with this