Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I have a Combined Text summary field titled "Languages Spoken by Admin" that pulls data from a table also named "Languages Spoken by Admin" that I created. I added the combined text field onto a report on my "PSL Survey" table, but the problem is that the data is automatically sorted alphabetically (see 1st screenshot attached) and not how it's entered on the table shown in the 2nd screenshot (see attached). Does anyone know how I can sort the data by it's Record ID#?NOTE: I have read through different posts that suggest creating a formula text field, but I would like better explanation here on this post.
I am setting up Dashboards (vs Home Pages) for the first time. I have watched University Training on Dashboards, but need a bit more guidance. Problem: HOW do I set up a new KPI report with single number display of Projects that meet certain criteria (e.g. Active). From videos seems like this should be related to the 'old' circle guage charts. I cannot find single # or circle option under gauge charts. Can someone please help me with this simple task? Thanks in advance. ------------------------------Annetta Coleman------------------------------
Anyone having issues with publishing changes from a sandbox back to the live environment? It is strange but "Review and publish" is acting as though there are, or have been, no changes from the live environment.
I want to do something like the below but I am unsure of the all the syntax for or that part is yellow. Can someone help me so this I tried ""If([Salesroom]="Playa Grande",[# of people in party]+1*7.81) or([Salesroom])="GS Landsend", "Pacific Dunes",[# of people in party]+1*9.63Thank you
Hello Quick Base Community. I am wanting to get the UserID for a user with the click of a button. Using the API_GetUserInfo, I can pull the UserID, copy it and then paste it somewhere, but what I would like to do is click a button that will get the UserID and then write it to a field in the record that I am on. Really the question is, is it possible to call an api and then perform an action using data that is returned from the initial api call? I assume that this wouldn't be a problem using scripting but I would like to know if it is possible natively within Quick Base.Thanks!
I have a 7 fields I am summarizing.Then I have it grouped by Salesroom and Sale dateWhat I would like is a total between the SalesroomsI would like a subtotal line before the next salesroom - or at least a total for the last column.Is this possible?
I thought I saved the one I added so if this is duplicate I apologize, I could not find my original.I want to have a formula field that says this but the , between Pacific Dunes 2 and [#of people in party}+1*9.63 is turning yellow and I have tried ( ) and,, but I can't get this to work. It tells me its expecting a commaIf(Contains([Salesroom]="Pacific Dunes 1","Pacific Dunes 2", [# of people in party]+1*9.63)What I would ultimately like is If(Contains([Salesroom]="Pacific Dunes 1","Pacific Dunes 2", and GSlandsend [# of people in party]+1*9.63) or If[Saleroom]="Playa Grande" [#ofpeopleinparty]+1*7.81)that way I only have to have one field instead of 3 fields - I have two of the fields working like this If(([Salesroom])="GS Landsend", [# of people in party]+1*9.63)But as soon as I add more salesroom it doesn't like itThank you so much Edit I was wrong its not even multiplying correctly so there is something wrong in the *9.63 or *7.81Example - column # of people 3 and then plu
Before we implemented QuickBase , we used to have tonnes of excel sheets were salesman will give weekly update regarding the status of their orders in excel / google sheets.This require creatingCreating comments tableCreating parent child relationshipLimiting two updates in report Speedrun of above is on this , watch at 1.5x LOOM VIDEO with no sound OR You can copy paste below in browserhttps://www.loom.com/share/1139f233e1a548f4b6c19655c54ddb9e?sid=e477defa-231e-4446-ac35-b9248bdbd6e4
I have a report I created where Days Remaining is a formula:-(ToDays(Today() - ToDate([Due Date])))I want to color code the table such that Days Remaining = 5 -> RedDays Remaining = 5-10 -> YellowDays Remaining = 10+ -> GreenDays Remaining = Negative Number -> PurpleBut I can't figure out how to use the results of the field formula in a formula in the color code area. TIA
I am attempting to have a third party web service initiate a webhook. In order to do this, I need to provide that service authorization to Quickbase via Oauth 2. Here are the fields it is requesting....URLToken URLClient IDClient Secret KeyScopes (Optional)I have tried all sorts of different configurations of information to try and get this to work but have failed so far. Any help would be greatly appreciated.
Is there any way to restrict an entire role from being able to add columns to a report (or is that a report option?)?Or is the only way to go into each field and uncheck the box to allow it to be added to reports, or set permissions on every single field so that a certain user role cant see it?
We have customers who have “an order” of up to 300 items. The order is initiated via connected channel to Box. A CSV file listing the items is dropped in the Box folder and are tracked in Quickbase. The Kanban report is desired but is limited to 100 records (items) per customer.Is there any known work around for the 100 maximum number of cards (records) per column in a Kanban report? I need 300 in a column.Thanks,Bruce B.
I have a parent table with a custom key, and I have several formula fields with formula queries that pull data into the parent. The ones that are summing into numeric fields work, but I also have one that is a checkbox formula. I want the parent to have a checkbox if any of the children do.var Textlist vals = GetFieldValues(GetRecords("{48.EX.'"&[Custom Key]&"'}", [_DBID_TABLE_NAME]),43);If(Contains($vals, "High"),true,false)There are no syntax errors but it's not working - there are child records with a checkmark in field 43 but on the parent records there isn't a checkmark. I know the GetRecords function is returning the correct records because it works for my other functions that sum correctly.I tried to run the formula checker, to check each step, but it doesn't work with my custom alphanumeric key.How can I figure out what's going wrong here?
First off, loving the document/pdf creation function. Has opened some new areas of opportunity in a few tables.One thing I am having trouble with, maybe a setting/enablement I am overlooking , but I want to enable a user to generate a document from any given filtered view or a customized report view.For example I have material requests for various jobs, if I create a report to filter to just by job and visibly only see that job's requests, we'd want to a user to have the ability to just click generate a document and it makes it off that view's records. If I do that now, it actually generates the document for the whole overall table, not what report I'm in and what records I visibly see from that report.
I have successfully embedded the iframe in the attached image in the volunteer site for a not-for-profit. I wondering if there is any way to remove the native "save" button and/or the entire QB title bar. I want the form to seem like the typical web form, so I would prefer to only use the custom submit button. Any advice would be greatly appreciated.
I am trying to create an email notification for a parent table. This table has a one to many child table for items to include with the parent record. I would like to include the child records associated to the parent record in table form. Not a link to the report. How would I call the child records in table format to be included on the email notification?ThanksBrian
Hi Folks,Importing data using python from XYZ Database.Some columns contains values with ,(commas).While importing using importfromcsv string is split up and data is then incorrectly mapped.Any guidance?
Hello, I'm looking to use QuickBase's File Manager Plugin, but was wondering if anyone had found a way to be able to pass additional data into the child records that were created. For example, if I could pass on what "kind" of file it was (like Signed Request, Invoice, etc.) into a child table field.
Quickbase is an immensely powerful platform. At the core, we have built a custom database that combines the traditional database and application layers. Quickbase App Builders do not need to be database administrators or have coding backgrounds and we abstract out unnecessarily-complicated elements such as indexing. This leads to quicker time-to-value and the ability to build enterprise-grade ecosystems in a fraction of the time you might expect. However, no platform is perfect, and they all have tradeoffs. In software, there are three fundamental components that can be optimized for, and a fourth that impacts scale: Size: How big the database and application will get. Think number of records, tables and fields. Complexity: How much "thinking" the application does. Things like reporting, calculations, workflows, etc. Speed: How fast can the application return an answer that requires computation? Concurrency: At any given time, how many requests hit the system at the same time? This ge
Hi Quickbase Community,I'm working on setting up a pipeline that will create a record in an archive app. I want to pull over the employee name and title into the new record, but the only available option I have is the Record ID. Unfortunately, when I use the Record ID, it only brings over the number ID rather than the actual name, and there is no title option at all. How can I pull the employee name and title instead of just the Record ID? Thanks in advance for your help!Meagan
Hi Quickbase Community,I’m working on an app with a many-to-many relationship and would like to use Pipelines to automate the process of archiving records. Specifically, I want to move records to an archive app when an "Archive" checkbox is checked in the current app.Could someone provide guidance on how to set up a pipeline for this? I’d like the pipeline to:Trigger when the "Archive" checkbox is checked.Move the relevant record(s) from the current app to an archive app.Ensure that the many-to-many relationships are properly handled during the transfer.Any advice or examples would be greatly appreciated!Thanks in advance,Meagan
This is probably a super easy question but I am rusty and nothing I am trying is working and all the discussions I am finding are asking for more complicated formulas.I simply need to calculate the number of days between 2 date fields on a record?
Hi everyone, I feel really silly asking this, but I can't figure out how to use a URL button to add a new record and then simply go to the newly added record. This is what I have currently. And, the only reason I'm using API_AddRecord instead of API_GenAddRecordForm is because I can't get it to set field 18 to what I want, but for whatever reason it does work with AddRecord. URLRoot() & "db/" & [_DBID_CREW_TIME_RECORDS] & "?a=API_AddRecord" & "&_fid_18=" & Now() & "&apptoken=cynqae3bygzqysbuufhnqczijtxn" & "&rdr="&URLEncode(URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl()) Thank you!------------------------------Elena Larrabee------------------------------
I’ve made in QB a table, where we can search on a specific code and he will give the other related masterdata (out of backtable).Problem statement:The problem here is , he can only work with 1 code (80737797) - to reflect the related masterdata, so in case we have multiple codes , we are currently not able to reflect all the codes via this way.So in this case , Code 80748492 & 80830493 aren’t able to be reflected via the “Related masterdata”-fields.Is there any potential way to have this done within the same “record ID / Line” ?Is there any other opportunity to have the same outcome , but with another workaround.I know we can go for multiple record ID’s. But this I would like to avoid as it will create confusion for our partners.Many thanks !
An embedded report I copied and altered from another embedded report displays all data correctly but when I added a report to a form I created (both live in same table) it is totally blank. Why is this and how can I fix it?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.