ContributionsMost RecentMost LikesSolutionsMaking Sure Your App Isn't a Black BoxHave you ever taken over an app from someone else? It all starts out fine, but then you make a change and everything breaks. Well, don't worry, it's not just you. More to the point, it's not your fault. (It may be a little your fault, but I'm not here to assign blame.) Chances are good that the app you're working on doesn't have the documentation that will make it future-admin-proof. However, that can be fixed, and I'm here to show you how. Un-building a Mystery Virtually every part of a Quick Base app has places for documentation. If you go to your home dashboard and click the settings icon, right there on the app settings page you'll see a big "Description" box at the top. That box is there for each of the tables as well. This is a great spot to put general information regarding the structure of the app, and the purpose of each table. You don't need to put a whole manual there, you're just looking to send future admins down the right path. Fields, when you're looking at their settings, each have "Comments" tabs, and on that tab, you can spell out what this field is used for, and relationships it has with other fields (for instance, formula fields where it's used). Other spots with a Description field include reports, automations, Quick Base actions, and user roles. You want to keep these as concise as they can be without leaving out necessary details. Uniformity One thing to keep in mind is that sometimes people aren't going to get down to the comments and descriptions before trying to make a change. This is where having consistent naming (and for larger apps, naming conventions) will be a huge help. If you have Purchase Orders in one table, referring to the same items as Invoices in another will be confusing for someone at some point. On the other hand, if they are truly different things in your work flow, make sure that they have comments and descriptions to explain the difference. Make sure that assumptions can't override your intentions. Comment Chameleon One of the most effective and least used features is the ability to put comments in formulas. This is especially useful for long formulas with many parts. Adding comments is as simple as starting a new line with "//" (without the quotes). You can add the comments at the end of lines, too. The only rule with comments is that after the // the only text is comment, and to continue the formula, you need to hit enter to get the next line. Bottom Line All of these tools will help your business down the line. This way, once you get that big promotion, the person taking your place won't have to stare at your app and hear "Sound of Silence" playing. It's a win for everyone.Re: How to add two summary column in reportHi Pushpakumar, I think we'd need to know a bit more about what you're trying to do. If you're adding columns to a summary report, and want to total those to columns, you can use a report formula to do the calculation. https://help.quickbase.com/user-assistance/custom_column_in_view.html If you have issues or questions, please feel free to create a case with Customer Care, since we would be able to get more granular with our responses there. ------------------------------ Jeff Gilson Customer Care Quick Base ------------------------------ Re: Dynamic Filters in DashboardHi Vivek, That's a great question, and it actually comes up a lot. It can be done, and it's fairly simple, but it is a bit outside of the box. Instead of adding a report widget to your dashboard page, you'll want to add a website widget. First, go to the table and open your chart. Copy the URL for the chart from the address bar. Then, on the dashboard, drag a Web Page widget down from the options along the top. Paste the address into the URL, and at the end, with no spaces, add: &ifv=10 Now, one thing to note with this: if the page that comes up is blank, then there is a realm setting that will need to be changed. A realm admin would need to engage with Customer Care to allow pages to be shown in iframes. Here's more on customizing the home page: https://help.quickbase.com/user-assistance/customizing_dashboard_page.html ------------------------------ Jeff Gilson Customer Care Quick Base ------------------------------