Expanded URL from Reports
Hello, I was hoping to get some guidance on how to access the expanded url for reports. I have two identical apps and would love to cut some time but copying reports from one app to the other. Discussion about this topic - https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=8c484de1-b122-4c73-b918-72d25064962a&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer the upside down ellipses has this option greyed out but is there another way? ------------------------------ Tim D ------------------------------15Views0likes2CommentsLine and Bar Graph - Can we put the Line and Bar on the same axis?
Hi - I'm looking to create a Line and Bar graph where the line and bar use the same axis. Is this possible? Seems to me there is no option to use the same axis only the option to use a line and bar on separate axis. Thanks16Views0likes7CommentsCan I create a filed/report to show the size of attachments?
Hi there, As my quickbase attachments space is reaching the storage limit, I hope to check all my documents by size and start to remove the largest files. I can sort all documents by the date, by name, or by other fields. However, I was wondering can I create a field to show the size of the files? Like, we can sort emails by attachment size and delete those largest. Thank you. ------------------------------ Ning W ------------------------------36Views0likes6CommentsTotal Field or Column Header Colorization in a Summary Report
Hello, I have a summary report shown below, 1 of 9 that I'm building. Each of these summary reports takes a particular set of Statuses and totals them. Each total OR column headers will need to be colorized (red, yellow or green) and placed on our Homepage Dash. These status totals are not related to any dates or timelines. They are used for showing the total $ amount of insurance policies that were entered for the previous month, current month and next month by status. For example, the report above shows policies from the previous month. It would be amazing if I could make the Status and Annual TP column header red, given these totals represent policies that were Declined, Surrendered, Withdrawn etc. My next report would then be colorized yellow for policies that have a different set of statuses, then green column headers for policies for example that have been paid. Hope this makes sense! I'm open to any suggestions. Thanks for any help!144Views1like18CommentsHow do I Default back to old style of Table Report -
In one app I checked to view a table report in the New Style (beta). Now every report I view in any of the many apps I manage defaults to the New Style. I do not like this new style as all of the dynamic filters disappear from all of the existing reports. How do I change the default back to the "old" style. I have been fielding questions from customers today for they too are asking how to switch their default back. Not very friendly. ------------------------------ Suzy Kania ------------------------------72Views1like9CommentsHow can we email a custom dashboard page as a subscription?
I've found that sometimes users prefer dashboards to multiple emailed reports. How can I email the users a dashboard pageI have created that includes a couple of summary reports, a chart as well asone full reportin an email subscription? Is this possible with native QB? If yes, where is the setting option? I'm only seeing a report drop down in subscriptions. I'm not seeing a similar option to select a page . Thanks in advance for any direction/suggestions.60Views0likes8CommentsView query record if single record otherwise view query list
I am creating some buttons in a Formula - Rich Text field. They will allow users to quickly jump from one table to the next using the table to table relationships we have set up. Mainly what they will be seeing is a list of related records based on a query. For example, if I am in the Customers Table and I click on the Invoices button it will take me to the invoices table and I can see all the invoices related to that customer. If there is only one invoice I would like the button to take me directly to that invoice record and not view it in list mode. Is there a way to use the query and set up an if statement that would check the length of the query response and if there is only one then view that record. Below is an example of the query code I am using for one of the buttons. URLRoot() & "db/" & [_DBID_INVOICES] & "?a=q&query=" & "{'6'.TV.'" & [Record ID#] & "'}"72Views0likes3CommentsReport Using Multiple Tables
Hi Everyone, Is there a way to create a chart, that pulls in data from multiple table? I'm trying to create a Pie chart showing a count of On Time / Late proposals. This information is stored on four different tables. Any help would be appreciated. ------------------------------ Terri Wells ------------------------------70Views0likes5CommentsEmpty left column in embedded report in exact form
How to remove first column (edit / view) for embedded report in exact form. I am using this ~=qdb.GetURL("bhjz7apud", "API_GenResultsTable^query={'13'.EX.'"+field["Record ID#"]+"'}^clist=6.10.14.26^opts=nos.ned.nvw.");~ for embedding the report. But my problem is one empty column is appearing on left side. Please help38Views0likes7Comments