Create PDF Invoice Generator for Export Effortlessly

Pdf invoice generator for Export

hello today let's learn on how to generate PDF for this to work we will be using automation to generate the PDF file for us automation is available fully for all plan except for free the one I'm using for this tutorial is Enterprise standard alright let's get to it so I have an app that stores employee data I want to generate a PDF file that consists of the data for that particular employee first let's set up the board in automation create a new bot let's give the bot a name click on create a custom bot [Music] next we'll be configuring the event give the event a name [Music] foreign custom event you can configure this ing to your case but for this tutorial I will keep it as general as I can you can add condition to the event for a specific case such as status you get so active or gender equals to female now let's add a step to it I will name this step as generate PDF in this step let's configure the following create a new file reconfirm on the table data ensure HTTP is set to PDF and create a template appsheet will automatically generate a default template for you let's have a look at the template itself for my case all files are stored in my OneDrive for business commonly the files are stored in your G Drive this is the default template basically it calls all the columns in the data table that you have selected next let's change the file name prefix this will set a standard naming convention for your PDF file for this case I'll be using name column so that the file generated will be in this format employee name.pdf I will disable the timestamp since I want the file to overwrite the previous version this is completely optional if you want to maintain a singular file for a specific data enabling timestamp will create unique timestamps for the PDFs created let's save the app now let's make an update to the data [Music] you can see there's a background process running [Music] this file has been created in this folder by default then this is how the PDF looks like if it's using the default template when I change the look and feel that's simple let's head back to the template file basically here you can add any format to the template I'll be using a template that I've created prior to this tutorial I've added table design to the template with the parameters sorted for this part you can use based on your own creativity and create any format that you like I'm removing the default template now let's make an update to the app now if you go back to the file the PDF is now using the new format but now let's add an access to this PDF directly from the app instead of going directly into the OneDrive folder I created a file column in my employee table for this purpose now let's add the formula to it format is as follows concatenate file directory URL foreign dot PDF I'll include this in the description down below by doing this which means it will look for the corresponding name.pdf let's insert the destination URL this step is subjective depending on the platform that you are using for OneDrive it can be seen in file properties off [Music] if the URL consists of the file name remove it and as the name PDF gets the job done let's have a look let's make another update to the data now you can see the PDF file is now displayed in the app URL directory working just fine and PDF is showing as expected in the upcoming video tutorial I will include other automation methods such as email and Etc That's all folks hope you enjoyed this video I'll see you in the next one don't forget to subscribe take care bye