Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I want to create a line chart that contains "closed cases", "new cases", "cases in process", which x and y axis should I choose? In x axis, I don't have choice that only means date, they are all "create date", "closed date"?Should I create some new fields? OR use some formula to solve my problem?------------------------------Charles Su------------------------------
Hello,I have two separate apps, the projects app and the cost app. They exist in two different apps because it best fit the needs of our cost packages.I have a form in our project app that creates complex automations on our project side, however I would like our team to be able to access the form through the Cost App.I would like to make a button in our cost app that opens the form with the related record id from our project app (the record ids for our projects are the same between the cost app and the project app because we used a connected table). Is this possible?#crossapprelationships #URLformulabuttons #ButtonsThanks------------------------------Mackenzie Phillips------------------------------
I have a "pay now" button that is for EOTI but it doesn't work unless I'm signed in. Is this standard behavior? The link is "https://app.fluidpay.com/somecode" but when you are EOTI and click it - it takes you to a link that is our companies domain and table ID with the "somecode" at the end. What is happening?------------------------------Heather Donaldson------------------------------
I believe Today() is used for the current date.Now() is used for the current date and timeWhat do you use for ONLY the time? To set the time of day field to the current time?------------------------------Mike Tamoush------------------------------
Can you sort records on the calendar report within the monthly view that shows each day? If not, Can you change the default order on a drilldown report when you click a date?
We want to have our customers click on a payment link that takes them to the payment system we use to process the payment. I want to send them the Record ID and the Total Due.... How in the world do I do that? thank you!------------------------------Heather Donaldson------------------------------
I have a project where team members will have to present at multiple dates. Team meeting 1, Team meeting 2 and Team meeting 3. I would like to display all three team meeting dates on the same calendar. Is this possible? I have searched around but not finding what I need.Any help is greatly appreciated.Thank you in advance.------------------------------John Sanchez------------------------------
I have a recursive relationship, Permits < Permits. When adding a child permit it loads the add form on the Child Permits tab, and I want it to load back to the Permit Data tab. I've seen this with Javascript, but since we can't do it that way anymore is there any other way? I've tried adding "#tab_t48" in various places in the URL.------------------------------Dwight Munson------------------------------
Any come up against this yet? I am using the Webhook Request (due to auth reasons) but I need to parse the JSON response. Everything I read/tried says you can't use the JSON handler channel to parse the response. Does anyone have any jinja and especially a general methodology for doing so if even possible at this time. TIA Greg ------------------------------Greg------------------------------
I'm new to QB, but have attended some live virtual trainings and explored my new employer's current setup of QB.What we're trying to accomplish is:We have many training courses in one table. We have many instructors in another table. We'd like to identify instructors as being qualified to teach select courses. One instructor could be linked to dozens of courses. One course could have dozens of instructors. When I try to make a relationship between the two tables as it is, I seem to only be able to assign 1 instructor per course or vice-versa (depending what I choose as the parent). What am I missing?------------------------------Graesen Arnoff------------------------------
Hello,I am creating a new app for everytime there is a new station that opens, there are part orders that get ordered. So basically when you click a button "New Station" a report will populate with all the part orders, suppliers and a lot more fields. Its about 300 line items. So when a new station opens, the customer can click the button, the report will populate and they can edit the report if the part number has changed or price has increased. I have someone who created a similar app and used the below formula on the field (URL Forumla)If([# of Reviewers] < 3,"javascript:void(copyMasterDetailButtonHandler('&sourcerid=169&destrid=" & [Record ID#] & "', 'bpii57gip'))") because it says (# of Reviewers] How do I use this formula in creating what I am looking for. Thanks in advance------------------------------Sunakshi Sethi------------------------------
I have a formual rich text button group that has 3-4 buttons. It all works great. I am trying to display or hide certain buttons based on the users role. For example, if current user role = "Not Smart" don't display button #2. Here is what I'm currently using to hide/display buttons based on other critera: var text rowOnebuttonOne = If([Job Milestone]<>"Opportunity",$onebuttonhtml,"");var text rowOnebuttonTwo = If([Job Milestone]<>"Sold",$twobuttonhtml,""); Is it possible to also evaluate and display based on user role? Much thanks. ------------------------------Tanner Nordstrom------------------------------
I am having an issue where metrics in a summary report that is in a dashboard links to a blank drilldown report. The drilldown report itself has no errors or filters and works fine on its own. In fact, when I view the summary report natively (outside of the dashboard) and click on the metrics, the drilldown report displays the drilldown data properly. Why would this not be working in my dashboard? See attached screen video demonstrating the issue. Thanks in advance for any advice.Quickbase issue: blank drilldown from Summary report Vidyard remove preview Quickbase issue: blank drilldown from Summary report Vidyard video View this on Vidyard > ------------------------------Matt Makris------------------------------
Dear Team,May I please ask you where I can locate the account slug, so I can use it for the Pipelines?Thank you.------------------------------Iryna Pylypenko------------------------------
I've read in multiple areas that QuickBase offers a rating field, but I don't see this anywhere offered by Quickbase.Suggestions?------------------------------Newman, Savi------------------------------
Hello everyone,I have a table that stores equipment items, and there's a field that stores a QR code for each item. These QR codes are also printed on labels and affixed to their corresponding equipment item.Users perform inspections on these equipment items daily. The goal is to have users walk up to a piece of equipment and scan it, and this would launch the inspection form in QB in add mode, with the equipment item already filled out or selected.I know that we can already accomplish this with the QB app. However, many users will not be registered QB users simply because it's pointless to add them and pay for a license when all they'll ever do in QB is fill out these forms. Since they won't be registered users, they won't be able to use the app. Note that we already have the relevant table available to "Everyone on the internet". We just need to be able to incorporate the scanning functionality.Any suggestions are welcome and appreciated!------------------------------Juan Solori
Hello!I am on an Agile team. We have several fields that were built to contain email addresses:Product OwnerScrum MasterStakeholdersWhen a record is added, modified, or deleted...how to I send email to those email addresses? The Stakeholders field holds more than one email address.TIA------------------------------Angela Rackley------------------------------
Hello all!I'm looking to crowdsource best practices for query writing! I've done extensive research in the community blog posts and discussion threads and can't find more than a few basic and obvious tips and tricks...This question is coming up because I inherited a relatively old app, that has slowly grown into a Frankenstein mess. It now has tables with hundreds of thousands, sometimes millions, of records with weird relationships. So, I have to turn to queries -- But my queries regularly get overridden by QB and stopped, or they try to run and slow down the whole realm. FTR, I don't have access to the performance optimizer.Thanks!------------------------------Harrison Ray------------------------------
Hey Can anyone help me understand how to set this up properly? For step B, I want it to search for all Rows that match the conditional querie on Step A, and then for the records it finds, I want it to update those rows, for records it doesn't find, I want it to create a new row. I tried doing a "insert a condition" after step B where I was going to say if RID for A = RID column in B, Update, but it doesn't let me do that. There is no ability to select a Field (Cell) from step B, But I found this: Does that mean that if the List of Rows is ENTIRELY empty as in it didn't find any rows, or just that there are some records from STEP A that don't match Step B? Thanks! Ender------------------------------Ender Taylor------------------------------
Hello, I have created a Tracker/App for maintaining the Recruitment process details in my organisation. The app also contains a report updating all the Current Open Positions avail for hiring. I now simply wish to display this report on my Company's actual website as a Careers page. Kindly guide further if this is even possible.The report view. The website link. https://krishnabeads.com------------------------------Rasika Bhosle------------------------------
Hi QB Community,I'm excited about the new Formula Query and am trying to use it to find the minimum and max fields in a seperate table. I start with this:GetFieldValues(GetRecords("{249.EX.'"& [StateID] &"'}", "DBID"), 212)In the query, I'm returning a text list that shows all the 'prices' (fid212), where the 'stateID' (fid249) matches the 'StateID' on the record. This part works.Now I'm trying to figure out for to derive the min and/or max from the resulting text list. I've used SearchAndReplace to modify the text list in a few different ways to that I can pass it into the Max function, but no luck yet. Do you konw how to do this?? Thanks!------------------------------Jake ------------------------------
Hello,I have a table with about 20 columns. I want to have summary row on top which would summarize the data of each column. Also, Is it possible to get different summary for different columns? Thank you very much.------------------------------Tapish Bij------------------------------
Hi there. I am trying to use formula URLs to create a button that can make two child orders based on the parent order (where the button would be pushed) using API_AddRecord.The child orders are supposed to duplicate some information from the parent order. The problem here is that reference fields are not being duplicated (unless you use the API_GenAddRecordForm which doesn't allow for creating multiple recordssimultaneously).Here's the code I've been using: var text addOrderNumber = Left([Order #],".") & "." & ToText([Number of Change Orders] + 1) & ".ADD"; var text returnOrderNumber = Left([Order #],".") & "." & ToText([Number of Change Orders] + 1) & ".RETURN"; var text parentOrderNumber = Left([Order #],"."); //The URL to create a copy of the order. By default this is of type return order var text CreateAddRecord =URLRoot() & "db/" & Dbid() & "?a=API_AddRecord"&"&apptoken=XXXX" & "&_fid_6=" & URLEncode($addOrderNumber) &
Hi everyone - I'm hoping someone out there can help me out. I have a table that contains a field, Estimate Number. This Estimate Number repeats but is differentiated by another field, Version Number. Here's a screenshot of a report that I think explains this better:I need to create a field within this table that counts the number of estimates. In the example above it would be 14. I've tried creating a summary field but there aren't any tables that have the right level of aggregation and where this table is Child.Thanks!------------------------------Scott Cote------------------------------
Hi,The "Auto save when redirected away from the page" setting does not seem to work when I'm entering data into a Grid Editable report on a form on an existing record. It does work when the record is being added, but as soon as the record is created and has a record ID#, it no longer works and asks me if I'm ok leaving the page without saving:Any ideas why this is and how I can get around it? At first I thought it was my JS button, but I tried to create a solution where it would use a standard URL button after record has been saved, but that doesn't work either.------------------------------Curtis Middleton------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.