Report Table [BUILD] | Foundation

[@StephenMattison66]

YES! Matt gets a lapel/Lavalier mic! TYVM! Great decision, SO much better than the giant expensive phallic mic that requires you to speak directly at it to have good audio, also requires you to grab it & move it around when presenter moves around, which is distracting. Lapel mic will also enrich your audio by picking up more of the deep resonations from your chest. Lapel mic is far superior to giant stand mic, people with hearing loss thank you for this great decision/upgrade!

[@MultitechVisions]

Thanks mate! Making slow upgrades to the infrastructure as time goes. (^_^) - Only problem with this mic is it likes to apply a noise cancellation automatically, and it kinda sucks! I've got to get around to finding the best option out there

[@djflexkid]

This is good stuff. So far i have been building automation to trigger reports for my apps and always have been wanting to have a way to pull reports on adhoc basis. Gonna implement this on alot of the apps now. Thanks Matt for this and all the great tips you come up with.

[@sakumzingqobe1823]

thanks, this gave clarity on a lot of things.. stay blessed.

[@MultitechVisions]

Glad it was helpful!

[@summerwassonncar5467]

at the 29:00 mark, how would one modify your report to handle the following? Let's say I have THREE categories: Billed, In Progress, Quoted. If I want the user to choose one or many from Checkboxes (not a radio button) to generate a report for all, grouped together by Billed, In Progress, Quoted - - how might that syntax look? BTW, this video was SOOOO helpful, I've saved it and reference it OFTEN! So thank you!! 🎉

[@nicodema1978]

thanks matt, like your videos very much. Learned a lot... i follow you from argentina!!!

[@jaredmazzis9930]

Thanks for this Matt. Enjoyed adding this functionality to my app

[@edrol2008]

Really thank you for this video. It's improved my thinking a lot.

[@FaustoMolinet]

This is awesome stuff - but when I followed along, if I only have one entry in the report, it works fine, but multiple entries by selection of the report generation form, it all looks right in the app but the PDF does not enumerate each one, and just gives blank..> does that have anything to do with the separator that the virtual column is adding?

[@pptpopat]

thanks mr. appsheet developer

[@עמירצין]

Hey, do you think we can use this type of form to generate reports from multiple tables instead of creating a different process for each table?

[@MultitechVisions]

As in: "Generate a report for all the {Invoices, Sales, Timelogs, etc.} for X date range?" - Sure can! The key here is in creating a separate field to hold the "list of results" for each separate table. You'll need one column per table, since a column can only be set to a ref for a single table - so.... if I wanted {Invoices, Sales, Timelogs} that's 3 tables, I'd need a corresponding column for results in my Reports table: 1) Report_Invoice_Results 2) Report_Sales_Results 3) Report_Timelogs_Results Then inside your template, you just create a separate

[@hamvasq]

Matt, this is awesome. Thanks a lot! 👍👍

[@rm00l60]

Hello Matt, thanks for the video. I would like to know the limitations of these reports, like what are the maximum number of records that can be included in a PDF or an Exel report? Thank you so much for the amazing videos!!

[@MultitechVisions]

kzbin.info/www/bejne/o4PFeqWwo9qlf6c I've yet to encounter any, and others report similar results

[@thomasscheibel2147]

Great informative video with greetings from Germany. To go one step further, I would be very interested to know whether it is also possible to create a so-called "grouped PDF template" with this template? If yes, with which expressions???

[@MultitechVisions]

I begin the process of explaining things in the following livestream: kzbin.info/www/bejne/p2fWpKCgm86efbs - But I faced challenges towards the end of the stream, and had to end things before I could figure them out. :( - Turns out it was a technical problem due to the template being built by AppSheet automatically

[@thomasscheibel2147]

I've been trying to create a grouped template by type from the existing template since the video came out, and I keep ending up with a valid "Select Expression" to get the selected "Construction_Types" as the group header. Do you have a tip?@@MultitechVisions

[@MultitechVisions]

@@thomasscheibel2147 This Friday I'll do another section on how to make a grouped report. - Should work this time - fingers crossed! 🤞

[@quantum9000]

Awesome 👏🏼, just one question, would it be possible to change colors of text in created pdf based on values? I want show percentages in different colors, like red if it exceeds a threshold. Cheers and keep the good work 👍👍👍

[@kimatpatel9660]

Amazing

[@MultitechVisions]

Thank you! Cheers!