Create custom PDF documents or fill in PDF forms with Eledo within Monday.com

Hi @jcjgomez,

Yes, the number of documents you can create is per month and also payments are charged every month. Yearly subscription to come in future.

Best Regards,
Lubos

@jcjgomez you have the luxury of multiple apps for document generation on monday.com. Have you tried DocuGen? It’s super easy to use, rated 4.8/5 on G2, and very moderately priced. Plus: we provide free live chat and email support! I am the founder of DocuGen – feel free to reach out to me at any time

I can vouch for DocGen. I have used it a lot, and if I can use it - anyone can use it!

If anyone can vouch for DocuGen, it certainly is a power user like Bill with hundreds of documents under his belt 😀

@lubos.husivarga

Do you know if you support time tracking columns? I need to be able to add 2 or 4 different time tracking columns together - I’ve tried using

SUM(item.dup__of_caitlin_time_tracking, item.subitems_drew_time_tracking3)

but it is just showing 0 at the moment, I also tried formula columns too but then I read here that you cannot support formula columns.

If I use just item.dup__of_caitlin_time_tracking then it works perfectly, but I need to be able to add them.

Thanks

Hi @Drew,

Thank you for the request, we have implemented the support for Time tracking column a moment ago and now you can do the calculations with it.

In Eledo’s data expression you can do the following:
item.dup__of_caitlin_time_tracking.duration + item.subitems_drew_time_tracking3.duration + …

Please note the .duration sub-field of the Time Tracking column. It represents a number of seconds. The result will be sum in seconds.

I am working yet on a simplier method to print the seconds in HH:mm:ss format.

Hi, I’ve managed to get it working - thank you so much - it would be amazing if there was a way to show the HH:MM:SS - If that’s a long term issue can we round them to 2 decimal places?

I’ve managed to do:

(item.dup__of_caitlin_time_tracking.duration + items.subitems.dup__of_caitlin_time_tracking.duration) / 3600

However I tried NUM(((item.dup__of_caitlin_time_tracking.duration + items.subitems.dup__of_caitlin_time_tracking.duration), 2) / 3600 and ROUND but it fails

We have a DATE() function which could be used to format the number of seconds as HH:mm:ss, but the issue with this is a timezone, which in my test printed 01:00:12 time for 12 seconds duration. It is caused by GMT+1 timezone offest set in my template’s Settings page. You can actually use this approach when setting the timezone of your Eledo template to GMT+0, but this also affects other dates in your document, so it is only viable if you don’t print any date beside the duration. Data expression could look like:

DATE((...+...) * 1000, "HH:mm:ss")

Your NUM approach is nice and you can use NUM function to build the HH:mm:ss format with data expression, and it could look like this:

CONCAT(NUM((seconds=item.dup__of_caitlin_time_tracking.duration + items.subitems.dup__of_caitlin_time_tracking.duration)/3600, 2, 0), ":", NUM(seconds/60, 2, 0), ":", NUM(seconds, 2, 0))

I have used seconds variable, so I don’t repeat the long seconds calculation 3 times and also defined 0 decimal places for NUM function which should not display decimals and therefore you don’t need to round the calculation.

Hope it will work fine as a workaround, let me know 🙂

Thank You!!
It worked on the main section of the document I’m building - I’ve added a block repetition to a cell within a table however when I add

DATE((items.subitems.dup__of_alana_time_tracking.duration + items.subitems.dup__of_drew_time_tracking.duration + items.subitems.dup__of_filipe_time_tracking.duration + items.subitems.dup__of_lauren_time_tracking.duration + items.subitems.duration7.duration + items.subitems.dup__of_elin_time_tracking.duration + items.subitems.dup__of_mica_time_tracking.duration + items.subitems.dup__of_caitlin_time_tracking.duration) * 1000, "HH:mm:ss")

I get this error:

[Error in Expression ‘DATE((items.subitems.dup__of_alana_time_tracking.duration + items.subitems.dup__of_drew_time_tracking.duration + items.subitems.dup__of_filipe_time_tracking.duration + items.subitems.dup__of_lauren_time_tracking.duration + items.subitems.duration7.duration + items.subitems.dup__of_elin_time_tracking.duration + items.subitems.dup__of_mica_time_tracking.duration + items.subitems.dup__of_caitlin_time_tracking.duration) * 1000, “HH:mm:ss”)’: Required return type is Array for Expression: DATE((items.subitems.dup__of_alana_time_tracking.duration + items.subitems.dup__of_drew_time_tracking.duration + items.subitems.dup__of_filipe_time_tracking.duration + items.subitems.dup__of_lauren_time_tracking.duration + items.subitems.duration7.duration + items.subitems.dup__of_elin_time_tracking.duration + items.subitems.dup__of_mica_time_tracking.duration + items.subitems.dup__of_caitlin_time_tracking.duration) * 1000, “HH:mm:ss”)]

So I’m trying to make a table with multiple rows, which then display the subitems on each row - then the time tracking data for each subitem.

Am I doing something wrong?

@lubos.husivarga

I’ve checked all the documentation - Is there a way to set up a repetitive block on a pdf at all? I have one pdf file which has a table - which needs to be populated with the data from the subitems - I can see a way of doing it on a normal document which I design but I can’t see a way to generate it on a designed pdf form

Thanks so much for all your help.

Hi @Drew,

I am not sure what could be the issue with your data expresion, the error message is strange. But I have noticed you are using items. prefix, you probably need to use just item. one.

If you would like to sum the time tracking over multiple subitems, you can do it like:
SUM(item.subitems, dup__of_alana_time_tracking.duration)

Then you can repeat the SUM over every subitem column and add them together with +

I also recommend you to store the partial results into local variables like:
alana_time=SUM(item.subitems, dup__of_alana_time_tracking.duration)

alana_time variable will be populated with the sum for every following data expression in the document and it will make your calculations simpler.

Block Repetition is not available for PDF Form filling, because the layout of existing PDF cannot be changed easily, if at all. In our youtube video I am explaining how you can populate tables in PDF Form using PROPERTY(GET(…), …) data expressions. (Eledo: Fill in PDF Forms automatically with data from monday.com board - YouTube)

Please try it out and let me know any questions. I recommend you to use our Helpdesk chat in case you have more questions specific for your use case/template. But feel free to post any general questions here, so we keep the thread interesting to read for others as well 🙂

@lubos.husivarga What is the maximum file size for photos on your documents?

Hi @JacksonBarry

We have a 10MB limit per image at the moment.

We are currently working on automatic image resize feature to reduce the file size of created PDF.

Hope it helps, let me know any questions or get in touch via our Helpdesk.

Lubos

That’s great, could work for me, I look forward to that resizing feature too.

Hi @lubos.husivarga - We’re using Eledo with several clients and have a need to generate documents independently on each subitem, at various times. What’s the tip on how to create a document using only an individual subitem’s values?

Use case example is that each subitem represents a different speaker for an event and they need to generate separate documents for each speaker, at different times. They want to create the speaker documentation when each speaker confirms their participation in the event over the course of several weeks.

Hi @PolishedGeek,

This is a limitation of monday platform and I wasn’t able to find any workaround how to do this, not even using Zapier or Make.

For the moment this is not something we could do. We have a request to create a PDF from multiple selected items in the board. It will require some development, but there’s a hope that we could select also a subitem this way and send the document creation request directly from Eledo App bypassing the limited integration recipes.

If you are open for data model change, then maybe you could store speakers as items in a separate board. Then use connected board column at subitem level to link the speakers and use mirror columns to display necessary data including PDF files. Integration recipes would be setup in speaker’s board at item level and could be triggered by status change, which can be mirrored to subitem. I didn’t test this, just an idea how it could work.

Let me know any questions!

Best Regards,
Lubos

Hi @JacksonBarry,

The image auto-resizing feature is already implemented! Now the PDFs are much smaller in size even if you provide >5MB~ images from a cellphone.

Eledo now automatically downscales the images to 200-300 dpi based on plan you are subscribed to. We can provide higher image quality via Custom plan if needed.

Hope you will find this feature useful!

Best Regards,
Lubos

Hi @lubos.husivarga

I have a questions, I hope you can help me. I know you can not use formulas in Eledo because of the API, I use some of the Eledo expressions and it works. Just I want to make a summary for a column fill with numbers, transfer to Eledo.

Do you know the expression for this?

Example, I want to summary this numbers and put the result in Eledo. I think I need to use a Block Repetition for the summary of all de subitems, but I can not find this.

Thank you in advance.

Hi @grupol2f2

Yes that’s right, formula columns are not supported. But you still can do a sum in Eledo template.

With Block Repetition you can print multiple items, subitems or connected board items. Here’s a quick guide how you can setup a table with the Block Repetition:
https://eledo.online/documentation/guides/monday_com/printing_all_subitems_and_related_board_items

Then, you can add a new row into the table, usually after the repeated rows. Data expression to calculate the sum is:
SUM(item.subitems, numbers38)

This way you can calculate the SUM with Eledo easily. You can also use another calculation isnide the SUM, to calculate the sum of another calculated value. For example:
SUM(item.subitems, ((numbers3 + numbers5) * numbers7))

Hope it helps, let me know any questions.

Best Regards,
Lubos

Perfect, thank you so much @lubos.husivarga !!

One more quick question, for the result on this formula, and others formulas, how can I put a format for numbers in Eledo to create a PDF?

I want to use commas to divide the number, example: 000,000.00

@grupol2f2 you can format the numbers using currency function CURR() like:
CURR(item.numbers7, 0, 2)
CURR(SUM(item.subitems, ((numbers3 + numbers5) * numbers7)), 0, 2)

Parameters for CURR functions are a number to format, number of leading zeroes and number of decimal places. In both examples 0 leading zeroes will be added and currency will have 2 decimal places.

Thousands and decimal separators used are based on your template’s Locale setting in Settings menu.

Let us know if it works as expected! 🙂

Thank you so much. That worked perfect.

By any chance, do you know if there’s any way that the information in the PDF remains on a single page?

Hi @grupol2f2

If the content is longer then it is automatically moved to a new page. Since the page dimensions are constant, you can fit more content into it by decreasing page margins, by lowering the font size, line-height or removing a spacing in the content itself.

If you have a long text coming from monday board, you can also control its size in the document by shortening it to a maximum lenght with SHORTEN(item.text, 50) function.

Hope it helps, let me know if you have any more questions or get in touch with our helpdesk to get more help with your template.

Lubos

Hi. Have started Eledo editor and it works well for data all coming from a singular item. Wondering whether Eledo Editor has capability to generate documents using data from more than one item/row in a Monday.com board?

Hi @melissacresson1,

Yes of course! You can print multiple items into single PDF as well. You will need to update your template and use Block Repetition to iterate over items array. Then just use a different Integration Recipe which works with multiple items.

Check out our quick guide on this topic here:
https://eledo.online/documentation/guides/monday_com/multiple_items_in_a_single_PDF

Hope it helps! And don’t forget to rate our Eledo App in marketplace 🙂

Lubos