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=requests7Views0likes0CommentsHow 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!16Views0likes1CommentReport 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.30Views0likes3CommentsStacked 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.20Views0likes3CommentsRunning Total
I want to get a running total of the number of rows in a report. I have a formula that is COUNT([field name]), which returns a value of 1. To get the running total value, do I have to first create a var text query on the field I am counting? var text QUERY //var text QUERY = "{fid#.}"; Is the Running Total formula: SumValues(GetRecords($QUERY),fid#)Solved91Views0likes2CommentsGauge 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?14Views0likes1CommentSelect 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?22Views0likes3Comments