Dates from monday are transfered as a plain text at the moment, so they should print the same as they are in your board. I assume you’ve used a to_date function to convert it to a date and then tried to print in different format? It would be great to see your data expression to help, or you can contact Eledo Helpdesk for a quicker response (sorry for late reply )
Formula columns are not transfered at all because we can’t retrieve them from monday API. Workaroud exists and you can calculate the same value with data expressions in Eledo template, if not please contact Eledo Helpdesk again
I would like to share with you 2 new quick video guides to show how you can print images into PDF document or fill in PDF Forms directly from your monday board!
Do you think it’s powerful as we do? Feel free to get in touch if you need more information!
Eledo looks like a great addition to Monday.com. I was just looking at the pricing plans for Eledo, and has the following question. Regarding the document amount per plan, is this the amount of document you can create a month?
@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
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?
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:
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
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
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