Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I don't know if its my end but been experiencing weird report behaviors. The report formula duplicates themselves even up to 10 times. Its' really annoying. The filtering criteria too also get wrapped in a weird.
Trying to get a qr code to print on a 4x6 label and I am using Exact Forms Plus and I have the following formula in my purchase order table under QR Code: "<img src=\"https://quickchart.io/qr?&size=150x150&text=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]) & "\" />"No matter how I have that formatted it does NOT change the size of the qr code as shown in the attached picture. Using that formula, the qr code does scan to the correct information. I had found a format on one of the help tutorials telling me that I needed to use this code in my template: ~=barcode(f[227],qrcode,150x150)~ When I use that field in my template, it works perfectly and I can get the qr code to resize just the way I need it to at whatever size, BUT The code no longer scans. It comes up to a google page searching for F(227).
Assuming I have a way to do survey by pushing a button which does a count with a timestamp. I want to get the records list by their attempt time which might be in their chronological order of attempt. The max I do attempt is 3. I understand I can use summary field to get the first and last attempt using the Minimum and Maximum but now the value in the middle is what am struggling to get. Anyone with an idea how to go about it? I will appreciate.
Hello!I've got an API button that when triggered, creates a new record with some preset information pulled in.That all works except in the instances where I need some fields to be blank.I thought I could use an If/Then statement to complete data or stay blank when necessary. for exp,If( [Renewed Parking rent] >0, [Renewed Parking rent] ), [...] I assumed if I left that as the statement, nothing would happen in the even of a $0 amount. The new record's field would be intentionally blank. Instead strangely, when data should be blank (whether the if/then sample above is blank or null), it populates a crazy amount like $25,000... It's always roughly $2#,###.I've attached some of the screenshots of the data output (currency fields) and formula. The text fields populate correctly if for example, [Renewal OutcomeStorage] (currency) =0 so the output for [Storage] = No (row 32) but [Storage Rent] (currency) should be blank but instead reflects $24,302.00.Any ideas about
Since QuickBase is making new RecordID how do i go about migrating into the RecordID used by QuickBase instead of relying on PersonID and OrderID/PersonID of the old database where the exports are coming from? I have some ideas that i can export the main customer table after inporting into QB and get the RecordID there and then future exports can have the RecordID added to them before importing.Can I override the default RecordID or something like that?What is the best way to go about importing from another database?Export From:Table (client) - PersonIDTable (orders) - PersonID one to manyImport to QuickBase:Table (Client) - receives a new Record ID made by QuickBase.Table (Orders) - receives a new RecordID made by QuickBase relationship joined to RecordID in client as one to many
What would be the recommendation of migrating 300-500 users from another application we're going to stop using and start using Quickbase? There will be multiple groups and roles, so is there an import for all group and roles and will it send out email notifications?
Hello, I feel like what I'm needing could have been done with the previous automations feature, but I'm trying to do this in a pipeline and it's very cumbersome and honestly too much coding... Is there a better and more simple way to create and track record changes in a table? I feel like the Pipelines feature doesn't fall in line with low-code, no code branding, and I've spent so much time researching on how to set this up in a pipeline :(------------------------------LB------------------------------
Hi, I'm trying to include a column for a property image preview similar to what is shown under 'Projects' in the Project Hub app. The formula appears to be correct but nothing is coming up. What am I doing wrong? Here it is...If([Building Photo] <> "", "<div style='display:inline-block; width:200px; height:150px; text-align:center; overflow:hidden; border:2px solid #ccc; border-radius:8px;'> \n <img style='width:100%; height:100%; object-fit:cover;' \n src='" & URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e120/v0' />\n </div>")
I'm trying to take a date of an event, and return the name of the Fiscal Period that date falls within, from another table!!Here's the scenario.A transaction happens in Table A. The date of the event is 5/24/2026.Normally, on a summary table, that transaction would all in the the May 2026 summaries of total sales. Too simple!!Our finance team has fiscal months, closing on the last weekend of the month! Meaning this would actually roll into next Fiscal Month! To make matters worse, they do not refer to months, but Periods.Below is a table of the FY and Period Labels.What I'd like to do - is from my transactions list, is query the FY and Period Labels Table, and pull the FY and Period which this transaction falls within (Start and End Date) so that I can then build summaries of my transactions using FY and Period.For example:GetFieldValues(GetRecords( Date of Transaction is On or After the Start Date AND Date of Transaction is On or Before the End Date) Return the FY an
I am working on a app that serves as an intake staging area for a public facing form. The forms only identifiers to the customer is an account number. I am tying to use this account number to copy the record to a different application using that number as reference to attach to a table with existing records. My pipeline is currently setup in the following way:Step 1:Intake record which triggers on a status change from "pending" to "approved" We will call the app this step looks at "Intake"No issues with this stepStep 2: Search records from what we will call the "Live" app which has an "Organizations" table with entries including the org name, details and the EIN#. Fields for subsequent steps here include that account #. Step is finding the EIN# and shows the org name in the output.Step 3:Basic condition to only proceed if records are found matching account #.Step 4:Creates a new record in the Live app primary table. Organization is a require field and I have {{b[0].id}}
I am trying to convert a number field to a text field, but keep the number formatted with commas. When formatted as a number, it reads: xx,xxx,xxx.xx but the commas don't stick when I use the 'totext' function. Any ideas?
I have a table and report where we calculate each employee's individual capacity percentage by adding up the hours they have placed into a table and dividing it by 40. I now need to take those employees and show the same type of percentage but based off each manager. So if Team A has 4 people, Team B has 5 and Team C has 3, how can I show the team's percentage in a report?
Has anyone had a fix to have a report name on the dashboard assuming the chart report is empty and there's no records to show. I would like to know the report without having to view the full report. This is how it is displayed. I know I can create a richtext above the report to show the report title but that's not an efficient way to use the field and also it will look weird when the report has data since there will be two titles and there are not rules to defy this.
Hey Qrew!👋I'll be heading down to Houston for Empower this May 18th - 21st and would love to connect with any Colorado people!Are you making the trip? Drop a comment below if you're going! Let's find a time to meet up! Perhaps we can visit Jessica at the Quandry booth?!Can't wait to see y'all in Texas! 🤠
Good afternoon, Quickbase world,Asking this question before opening a full-on case review to see if anyone has ever seen this and may know how to correct it.I have a person who needs to receive notification emails from multiple apps, and at this point, is receiving them from at least 2 apps. But a 3rd app she needs to get a notification email from, she never receives. We have checked her junk, deleted emails, etc, and she gets the other 2 just fine.I have checked her email spelling, copied it directly from Outlook into the notification. I've checked all the settings of what causes the Notification to trigger, and have even put myself on the notification to receive it as a test and confirm that it sends.I received the notification email, but she did not. Is there any other potential setting that could be blocking it from being received from this one app?
Good evening Quickbase Community!I have several numeric formula fields that include queries. Due to the volume of data in the table, the queries are no longer working properly.The permanent solution is to move all the queries to a pipeline so that calculations are performed when a new record is entered, but right now I need to recover the data we already have.Until two weeks ago, you could change the field type from numeric formula to plain number, and it would simply display all the data.Now it won't let me do that. It says the data is too large and to ask for help.Any ideas?
As an app developer or designer building multi-table workflows, I want to know the safe limit for relationship depth so that I can avoid overly nested structures that make reports slow, formula unreliable and also hard to maintain the app
How do I design for future fields I don’t know yet without overengineering?
As a Quickbase builder managing a growing application, I want to understand how relationships impact system performance so that I can design my data model in a way that stays fast, scalable, and easy to maintain as complexity increases.
As a system architect building interconnected tables, I want to prevent circular dependencies so that my data model remains stable, avoids infinite loops, and does not break reporting, syncing, or automation logic.
As a user relying on lookup fields for real-time data visibility, I want to understand why lookups sometimes slow down or show inconsistent values so that I can identify performance bottlenecks and ensure my data stays accurate and responsive.
How do I redesign an app when tables start becoming tightly coupled and slow?
Assuming I have a big app which is starting to lag and the field and relationships are increasinging becoming too many. When should I split one “mega app” into multiple connected apps?
Implementing a Dark Mode feature in Quickbase would significantly improve the user experience, especially for users who spend long hours in the platform. Dark Mode can help reduce eye strain and make it easier to work across multiple tools that already support darker themes.There is clear user interest in this enhancement, with feedback noting that adjusting screen brightness isn’t an ideal solution for extended use. Adding a native Dark Mode option would align Quickbase with modern UI standards while supporting accessibility and everyday productivity. Overall, this would be a small change with a meaningful impact on comfort and usability.
How do I properly design parent-child-grandchild relationships?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.