Тёмный

Appsheet Episode 15: How to generate PDF using Automation. 

Aris Azhar
Подписаться 9 тыс.
Просмотров 49 тыс.
50% 1

In this video, I'm sharing how to generate PDFs using Automation in Appsheet. By using Automation, you'll be able to streamline your PDF creation process and create PDFs quickly and easily.
If you're part of a team that needs to create PDFs frequently, then this video is for you. By learning how to use Automation in Appsheet, you'll be able to create PDFs quickly and easily, saving you time and money in the long run.
Expression used :
CONCATENATE("FILE URL",[Name],".pdf")
______
ABOUT THIS CHANNEL
My channel is about Technology and General videos. We cover lots of cool stuff such as Appsheet tutorial, highlights and day to day stuff.
Don’t forget to subscribe!

Опубликовано:

 

14 окт 2022

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 75   
@user-bq9wh3zr8k
@user-bq9wh3zr8k 8 месяцев назад
Супер. Дякую за відео!
@weilungchen5835
@weilungchen5835 Год назад
Great tutorial, very clear steps and easy to follow. Thank you for sharing this!😃
@aris_azhar
@aris_azhar Год назад
you're most welcome ! happy to see you here..thank you!
@mgskpgamage
@mgskpgamage Год назад
Great tutorial ❤️❤️
@aris_azhar
@aris_azhar Год назад
Thank you! 😊
@niroshansenevirathne7854
@niroshansenevirathne7854 Год назад
Awasome , very clear presentation wish you good luck bro.
@aris_azhar
@aris_azhar Год назад
Thank you Niroshan! Happy to see you here..appreciate the kind words and support
@user-rf9lr9st3j
@user-rf9lr9st3j Год назад
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.
@ganeshramu5083
@ganeshramu5083 Год назад
Thanks to you Good presentation I tried and worked good
@aris_azhar
@aris_azhar Год назад
That's great news Sir Ganesh! I am happy it worked out well for you.
@clarae1781
@clarae1781 Год назад
Good video, thanks!
@aris_azhar
@aris_azhar Год назад
Glad you liked it!
@glauterlima
@glauterlima Год назад
Thanks a lot!
@aris_azhar
@aris_azhar Год назад
You're welcome! Anytime...Hope you find the videos useful.
@alhajaboahmad
@alhajaboahmad Год назад
good,,,,great god job
@aris_azhar
@aris_azhar Год назад
Thank you! 😃
@ronaldo.garetti
@ronaldo.garetti 5 месяцев назад
obrigado, mesmo sem entender sua língua, conseguir resolver meu problema
@aris_azhar
@aris_azhar 5 месяцев назад
você é muito bem-vindo! estou feliz por poder ajudar
@Program_Improvement
@Program_Improvement 9 месяцев назад
Great tutorial! Is there a way to email the PDF template directly to the user instead of sending it to Google or One Drive?
@user-tv9ir3lh9t
@user-tv9ir3lh9t 10 месяцев назад
Deserve a like and share.
@aris_azhar
@aris_azhar 10 месяцев назад
and you deserve all the good things in life! thank you!
@missnisa91
@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?
@pepepopnpn
@pepepopnpn 6 месяцев назад
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
@pepepopnpn 6 месяцев назад
I found the tutorial for gdrive connect. Will watch it ✌️
@NasserGabaj
@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 :(
@user-gc3cu6zi1k
@user-gc3cu6zi1k 11 месяцев назад
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
@aris_azhar 11 месяцев назад
Hello! thank you for sharing me this. I think this can be address on my next video i'm posting today..stay tuned!
@MingAnIsAwesome
@MingAnIsAwesome Год назад
Great tutorial bro, how can I store the files in OneDrive Biz as shown in the video above?
@aris_azhar
@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.
@edel-optics.dearena3616
@edel-optics.dearena3616 Месяц назад
Thanks for the tutorial. How do I store PDFs in my OneDrive?
@user-bd5vt9pm5j
@user-bd5vt9pm5j 10 месяцев назад
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
@MrImGaBo
@MrImGaBo Год назад
Ty, please example with Google Drive Link
@aris_azhar
@aris_azhar Год назад
i will look into it sir!
@fiblondenacci9916
@fiblondenacci9916 Год назад
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
@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.
@bohdanstyslo
@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
@aris_azhar Год назад
Sorry to hear that. Anyways good news for you..i've made a new video for PDF (Gdrive) edition. Check this out ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-65ixaCUt_Y8.html
@compostae
@compostae 9 месяцев назад
s it possibe to use a Power point ouExcell document as Template ? Or Only Word ?
@arpa1520
@arpa1520 4 месяца назад
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
@aris_azhar 4 месяца назад
Sounds like an interesting concept! Do you have a mockup that you would like to share? email it to me arisazhar.digital@gmail.com and i will have a look what can be done for this
@arpa1520
@arpa1520 4 месяца назад
@@aris_azhar I sent you a idea
@Yagnik_Sojitra
@Yagnik_Sojitra 19 дней назад
Do we need any paid subscription for this ?
@marziahabdulwahabktn3458
@marziahabdulwahabktn3458 22 дня назад
any tutorial how to create "Share" button ?
@hayawanfarm5275
@hayawanfarm5275 29 дней назад
Please help me, when I try to create it for a data type other than text, why doesn't it appear?
@user-cs1ek7xh6y
@user-cs1ek7xh6y 7 месяцев назад
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
@aris_azhar 7 месяцев назад
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
@user-cs1ek7xh6y
@user-cs1ek7xh6y 7 месяцев назад
@@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
@aris_azhar 7 месяцев назад
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
@user-cs1ek7xh6y
@user-cs1ek7xh6y 7 месяцев назад
@@aris_azhar That would be amazing!
@DieterClaessens-ex1rm
@DieterClaessens-ex1rm Год назад
great tutorial, could i cnatact you for a specific problem i got?
@aris_azhar
@aris_azhar Год назад
Sure thing! What's the problem youre facing at the moment?
@2519Tim
@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.
@sengthongvernavong9778
@sengthongvernavong9778 6 месяцев назад
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
@aris_azhar 6 месяцев назад
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
@vernavong 6 месяцев назад
I don't understand what's you mean? Do you have a simple video for suggestions? Please
@infoguiahn
@infoguiahn Год назад
Hello, How can I generate the PDF from an action button?
@valdirdespesassantos
@valdirdespesassantos Год назад
How do I read only the first line, how do I make this condition
@ismaelsilva5948
@ismaelsilva5948 Год назад
Oi bom dia fui tentar colocar URL pasta file não está abrindo links
@AdityaMittalMIS
@AdityaMittalMIS 16 дней назад
How to add pdf link if using Google Drive
@mdjewelmolla7007
@mdjewelmolla7007 10 месяцев назад
How to create post system in Google appsheet
@AlMuradTech
@AlMuradTech 8 месяцев назад
Can we Open xlsx file in another tab like pdf file ?
@AlMuradTech
@AlMuradTech 8 месяцев назад
it ask to save the xlsx file and download it but can we just open the file in another tab
@stefaaneeman
@stefaaneeman Год назад
While opening file I always get the message “bad request” what am I doing wrong?
@aris_azhar
@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
@stefaaneeman Год назад
@@aris_azhar I’ll check it out, thx.
@stefaaneeman
@stefaaneeman 3 месяца назад
How can I find the path if I use Dropbox?
@yavuzusullu
@yavuzusullu Год назад
Hello sir, How can i save to pdf file in my phone? I don't wanna save on my drive sir.
@aris_azhar
@aris_azhar Год назад
i will look into some options for you and share back soon! sorry for my late response brother
@yavuzusullu
@yavuzusullu Год назад
@@aris_azhar ty my friend🙏
@yavuzusullu
@yavuzusullu Год назад
@@aris_azhar Still waiting :*)
@aris_azhar
@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
@yavuzusullu Год назад
@@aris_azhar thank you so much bro. I will try it
@andruskumel3144
@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
@mradelphi02 Год назад
I have the same issue. Can someone help with this
Далее
How To  Link PDF File Automation in AppSheet
21:36
Просмотров 25 тыс.
Китайка и Шрек в Домике😂😆
00:20
Best FREE PDF Editor | PDFgear
13:05
Просмотров 246 тыс.
How To Build a Grouped PDF Template in AppSheet
32:43