Create a button that displays an embedded report from a different table
Hello, I want to create a button that displays an embedded report from a different table that is related to what's on the current record. I want a button to go in the green circle and open that report that's embedded and related to that unit. Thank you! And I'm such a novice, so please be elementary with me :) ------------------------------ Renee Hansen ------------------------------100Views0likes5CommentsHiding Rows/Records
Hello - I hope this is an easy task. I know how to hide an entire field in a table (the three dots at the top of the field), however, my team also needs to be able to easily hide rows/records as well. Some records need to be kept in the table but are no longer active and in excel we could just easily hide a row, is that possible with QB? Thanks! Meagan ------------------------------ Meagan McOlin ------------------------------99Views0likes1CommentRename columns in a summary report
I've got a quick one! Is it possible to rename the columns in a summary report? In table reports I can update the Column properties. I don't see an option to do this in summary reports. Is there some option I've missed? (I tried making formula fields within the summary report, but they're limited to 3 - I'd like to show alternate names for 21 columns in one report.) ------------------------------ Chyanne ------------------------------99Views0likes4CommentsDisplay number of rows in a report
Hi, I created a report for table, while other reports are showing more than 50 rows, this report always only show up to 50 rows. I have tried to look at the customization setting or the report default settings but not able to find where I can show 200 rows in every report, because I know by default QuickBase shows 200 rows. Any thoughts? ------------------------------ Thank you for your help! Davy Ou, Quantitative Financial analyst Certified QuickBase Developer, Lifetime learner https://www.linkedin.com/in/davyou/ ------------------------------99Views0likes2Commentsusing a list-user field to filter a report
Howdy, I posted recently about a budget app I am working on. I have Areas. Areas have many accounts. Each account can have many categories. Each Area/Account/Category combination can have many expenses. I also have budget administrators. These budget administrators can have more than one area that they are responsible for. I've got the conditional drop downs working so that when a specific area is chosen, based on that area there is a specific list of accounts and based on the area/account combo chosen, there is a specific list of categories to which expenses can be added. Where I am stuck is that I want my budget administrators to only be able to see and/or edit/add expenses to those areas that they have been "assigned" to. It was suggested that I use a list - user field, which I have done on the area table. The area and the admin flow as a lookup to the Account table and then on down to the Category table as a look up. When I created the report for the home page and then tested as a user, the report didn't bring in any of the areas and I could see all of the accounts regardless of area. I'm not sure if it's an issue with how I'm creating the filter on the report maybe? I've tried many variations and just can't seem to get it to work. I've attached a picture of the filter, how I'm grouping the report, as well as the result I'm getting when I go to the home page and test as a specific user. (When I just run the report as a specific user, I get no results). I thought about basing the report off of the expense table -- but that report will only show me areas/accounts/categories where there is already an expense. I need the report to show all accounts, even if there is no expense yet, so I can add an add expense button. This will make it so that the admin will only see their accounts and when they click "add expense", the correct area will already be populated and kick off the cascading dropdowns for account and category. Thanks for your help and guidance! ------------------------------ Andrea Johannes Associate Director Texas A&M University ------------------------------98Views0likes3CommentsView 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#] & "'}"93Views0likes3CommentsWidth of report tables on form
When I edit the report table, the width is PERFECT. but when I link it to the form, on the form it is just extremely wide. Even if I try to take out a column to make it less wide, it just stretches the columns to keep it super wide. Is there a simple solution I'm missing?? I just have 3 columns and I need them to be nice and narrow. Thanks! ------------------------------ Michael Brumfield ------------------------------72Views0likes14CommentsColor Coding Not Available in Custom Reports?
Hi, I'm working to create a few custom reports and charts for one of our tables. In one of these tables, we basically have a delta field, which we want to highlight red if the change is negative and green if the change is positive. Based on the info from Quickbase in "color-coding in reports", this should be possible. The issue is that I'm not seeing a "color coding" section anywhere in any of the custom reports (besides the main "List All" table). I've also just tried to add a simple color-coding script in any of the "Add a formula" sections (such as for "Report formulas" and "Summary formulas" sections), but I've had no luck. Any advice is appreciated. Thanks! Shelby ------------------------------ Shelby Pons ------------------------------59Views0likes6CommentsCan I have more than three fields displayed in a default record picker?
I have an app which holds two tables with a relationship. One of the fields which is pulled through in my child table is a reference proxy from the parent table. So the user completes a form then picks the associated record from a drop-down and that data forms part of the record. I can pick three fields to display for the user to select the right record. Three fields isn't really enough for them to identify the right record though. I can see under Advanced Table Settings there is an option to build custom data rule... not sure if this might be my solution... ------------------------------ Jemma Data Analyst & Visualisation United Kingdom ------------------------------57Views0likes2CommentsCustom Embedded Reports in Different Tables
Hello, I want to embed a custom report from one table (table 1) into another table (table 2), the two tables have a relationship and table 1 is the child of table 2. I've looked at all the available guidance and I'm confused. Also, more generally but related, is there a way that all the customs reports in a table can appear as an option to become an embedded report in another table i.e. when you go to form settings/elements... I don't understand what one is supposed to do with the 'report link field' and which field ( in the custom report?) is supposed to made into a report link field. Thank you. ------------------------------ Keji Dalemo ------------------------------56Views0likes2Comments