Great video! I helps me a lot.. But I have a question, how can we select specific numbers of rows to be in the list? Let say we just select 1 Consturction Type, and the rows in Report Output Display is 100, but we just want to print the first 50 rows. How can we achieve that?
Thank you very much for the video. I would like to consult with you regarding how to format a PDF when the data spans more than one page. I found that the top margin on the second page is very narrow and does not follow the set page layout
thank you for your sharing very helpfull ,can you share "setting report with page header ,page footer, number page which not supported by appsheet ", do you have any solution idea ?
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?
Hello, i really appreciate your tutorial, but cannot figure out in what table the [Report_Output_Display] column is? It was originally in the template file as you opened it. Thank you in advance 🎉
Hi! when I've tried just to sum up all the values of hours I have at the result output list (as a total), it just repeated the sum value as long as the rows I am filtering are. Does anyone know how to just return the value once? Thanks!
Hi Matt, so I'm working on this now, but it occurred to me that if I want to keep my app up to date, I'll need to use appsheet to copy the types of work to the new table, which I was going to do through automation and a data action, by copying over new types. But how do I account for changes to the name of an item, or deletion of an item. In other words, how do I keep the new table up to date so that there are the exact same types of work in both tables?
I typically try to ref connect things together for this situation, this way the "copy" is connected to the "original" - and then its easy to get a Quick Update system in place to manage any changes you might have made. For deletes, it's the same kind of idea - but there's more nuance involved here. - The best example I have currently would be to check out the Join table many-to-many - This shows how to handle a situation where I've got a record connected to two things, and "delete" it from one side. That app shows how to handle the update on the other side, to remove the thing you just deleted.
I've had troubles with using [_thisrow] alone - in regards to nested things. - try to add the number of how many layers you need to go back; this seems to generally clear things up for me. [_thisrow-1] or [_thisrow-5]... that sort of thing
I needed this a month ago 🤣 it took me two weeks to figure it out by myself but I am happy to learn the hard way. Great content as usual !
Sorry it took so long! (^_^)
Great video! I helps me a lot.. But I have a question, how can we select specific numbers of rows to be in the list? Let say we just select 1 Consturction Type, and the rows in Report Output Display is 100, but we just want to print the first 50 rows. How can we achieve that?
Thank you very much for the video. I would like to consult with you regarding how to format a PDF when the data spans more than one page. I found that the top margin on the second page is very narrow and does not follow the set page layout
thank you for your sharing very helpfull ,can you share "setting report with page header ,page footer, number page which not supported by appsheet ", do you have any solution idea ?
Nice work matt
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?
Hello, i really appreciate your tutorial, but cannot figure out in what table the [Report_Output_Display] column is? It was originally in the template file as you opened it.
Thank you in advance 🎉
How could I group information about another grouping? for example, if Billable are the 3rd level, and Construction_type are the 2nd level
Hi! when I've tried just to sum up all the values of hours I have at the result output list (as a total), it just repeated the sum value as long as the rows I am filtering are. Does anyone know how to just return the value once? Thanks!
Is it possible to use conditional formatting in our template..?
Hi Matt, so I'm working on this now, but it occurred to me that if I want to keep my app up to date, I'll need to use appsheet to copy the types of work to the new table, which I was going to do through automation and a data action, by copying over new types. But how do I account for changes to the name of an item, or deletion of an item. In other words, how do I keep the new table up to date so that there are the exact same types of work in both tables?
I typically try to ref connect things together for this situation, this way the "copy" is connected to the "original" - and then its easy to get a Quick Update system in place to manage any changes you might have made.
For deletes, it's the same kind of idea - but there's more nuance involved here.
- The best example I have currently would be to check out the Join table many-to-many
- This shows how to handle a situation where I've got a record connected to two things, and "delete" it from one side. That app shows how to handle the update on the other side, to remove the thing you just deleted.
Hi Matt
Just watched this and looking forward giving it a go tomorrow. Do you have any suggestions for pagination? Is there any way to pretty that up?
I TRIED A LOT, when i do a formule with [_thisrow] in the pdf i dont see the list
I've had troubles with using [_thisrow] alone - in regards to nested things.
- try to add the number of how many layers you need to go back; this seems to generally clear things up for me.
[_thisrow-1] or [_thisrow-5]... that sort of thing