Creating a pie chart in a grandparent table
I’m in PR and we use QB for managing our media requests. If a reporter reaches out with an inquiry we log it in a media requests table. Media requests has a parent table of reporters (reporters can have multiple requests). Each reporter has a media outlet (think CNN or ABC News) parent (a media outlet can have many reporters. One of the things we track is the coverage of the media requests generates and score it with a multiple choice field on the media request entry (positive, negative, or neutral). So I have a pie chart that show the breakdown of the coverage with those options. I can pull that report into the reporter table on place it on the reporter form and it filters it down showing the score for that reporter across all their requests. What I want to do is pull that data into media outlets so I can see the score for that media outlet across all their reporters and the reporters requests. I want a similar pie chart on the media outlet form. What’s the best way to go about this?
Up-vote Full-width Formula URL Buttons for Reports
In reports, Formula URL buttons are truncated. You can use a Rich Text button and see the full button by default. I use Rich Text buttons now for reports where it is critical to see the whole button. Please up-vote my feedback on this: https://feedback.quickbase.com/app/#/case/474496?cpid=b2f09471-062b-455b-afda-96efb605ab38§ion=requestsHow to Save and Refresh a Report Link Table in a Form?
Hi All, I have multiple report link tables in a form (using the older form layout). The way my form works, is the user will fill in each cell in the report link table to update the records for child tables to the current form. I have some formula fields in the same page that is meant to update when filling in the report tables. However, this becomes very tedious because currently the user will have to fill in the report tables then click "save & close", then return back to the previous page to save the inputed data, and update the formula calculations. Is there a way to include a save & refresh button that will save the data inputted in the reports, and keep the user in the same page? The way it is now, if I use a custom save & refresh button it saves data inputted in the form fields, but not the data inputted in the reports. Any help is much appreciated!
Report Based on User's Role
Hello, What is the best method to create a report based on a user's role? I created a table which contains a list of users, their ID, and their role. I tried to establish a table to table relationship with the Projects table and User List table. But, the User List table fields are blank on the Projects table default report. I tried to import the User List data into the Projects table, but this option failed to work for me.Stacked Column Chart Output
Hello Everyone, I created a SCC where the X Axis shows Supervisor Name and the Y Axis shows a stack of 5 different Formula Fields we'll call CB1, CB2, etc. My Filters are set to Status = Approved AND Eval Date Is During the Current Month. The chart can shows up to 5 columns 1 per Sup. What I want to do is create the chart to show 2 columns for each Sup. where 1 is data from the Prev. Month and the other for Current Month. Any help would be greatly appreciated.Gauge Report Reverse Goal Feature?
We are using Gauge Reports on Dashboards to act as Actionable Items for a given workflow. For example I log on to Quickbase and my Dashboard loads with a bunch of Gauge reports. If the reports show 0, I know I am done. If the reports are greater than 0, I click the report to view the records where I need to perform some process to make the report 0. The Goal is 0. I can reverse the Low and High to apply the proper color coding. I cannot set the Goal to be 0. The Goal must always be greater than the Start At value. Has anyone come up with a solution for this without building a bunch of formulas? Am I missing something in the report settings?Select a specific number of records within a report or table.
I have a report with thousands of records, I can use a filter to reduce the number of records; however, I want to select an exact number of records within a report. For example, the filter reduces the number of records 200, but I want to select the first 50 records. Is there a way to select a specific number of records within a report or a table?
