Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello fellow builders, I'm writing this post in hopes someone can help provide insight or personal experience into a pending decision my company is wanting to make. For context, I'm a certified builder and have been for about 5 years now and I'm not against moving away from Quickbase. My company wants to move away from Quickbase and into Microsoft PowerApps. Their main reasoning is, no surprise, money. They say, "Power Apps can do everything Quickbase can do." And that the cost is already included in our license with Microsoft and is far cheaper. From my understanding though, it is regarding a version that is far from the capabilities of Quickbase and that if we wanted more funcitionality that rivals Quickbase it would end up costing us the same (if not more) in the long run. Our Quickbase license is on a transaction-based model. We use about 3 million reads a year and support about 3,000 users. Mind you, a decent amount are not consistently using the platform, but there a few enterpri
I am developing a nested container inventory management system within QuickBase and have encountered a challenge with calculating "Total Inventory" across nested containers due to recursion issues. I'm seeking ideas or solutions on how to effectively manage or circumvent this recursion to ensure the application performs as intended. Application Overview: Purpose: The app is designed to track the location, storage type, identity (by Part Number), description, count, and all transactions related to every inventoried item. Container Hierarchy: Our inventory system uses a hierarchical structure where one container can contain other containers (e.g., a pallet can contain bins, which in turn can contain boxes). Current Structure: Tables: CONTAINERS: Tracks each container, its contents, and its parent container (if any), establishing a parent-child hierarchy. ITEMS: Holds information about different types of items. TRANSACTIONS: Records additions, removals, and transfers of items in co
Hi, I have two tables, A and B that have a one-to-many relationship where A is the one and B is the many. What I wanted to accomplish was importing data from an excel spreadsheet for table B but also importing the corresponding record ID for Table A. I noticed in the import the relationship fields don't appear. And suggestions on how I could accomplish this? Thank you------------------------------Drew Harms------------------------------
So my Quickbase app records are created via an API. I've had no issues and been able to solve all XML errors thus far. This one stumped me. All tags are closed in the XML. I've checked multiple times. What could be causing this error? <qdbapi><usertoken>xxxxxxxxxxxx</usertoken><field fid="75">2024</field><field fid="76">9</field><field fid="15">103032696</field><field fid="28">03-16-2024</field><field fid="9">70050</field><field fid="12">162191.45</field><field fid="53">Trace3 LLC</field><field fid="54">588</field><field fid="55">Cisco Global Maintenance Support 3 years BL 1130</field><field fid="256">640400</field><field fid="21">654127</field><field fid="152">SA</field><field fid="188">2024-02-27</field><field fid="6"></field><field fid="158">fake.name2@fakecompany.com</field><fie
I can't for the life of me figure out what I'm doing wrong here, as I know I've made it work before, in forms/tables that no longer exist, sadly. I have a table filled out via a form. The user will select a category from a dropdown menu. I have another field that I need to auto-populate with the current contact (who will be a quickbase user) for that category. I have another table that stores the categories and current contact. I set up the relationship, but all my attempts to get the contact field in the main table to look up the category, find it in the second table, and return the relevant contact have failed. Can someone point me in the direction of a simple explanation on how to do this? It'd be much appreciated.------------------------------Michelle L------------------------------
I'm trying to publish a sandbox but I can't push the publish button. When I cursor over it, i get a round red circle with a link through it. Any ideas?------------------------------Carol Mcconnell------------------------------
Can someone help me with QB Trending Reports? My Leadership is looking for changes overtime in the data. Best Regards! Cindy Krausch Workforce Operations & Automation - Access, Roles and Config (ARC) U-Verse CRM and ARC QuickBase Administrator, Salesforce BW and MyAgentTools Backup Administrator, Tools and Data Analytics Developer CUSTOMER ADVOCACY & SERVICE 125 Corporate Office Dr, Earth City, MO 63045 CK2456@att.com (636) 667-9681 (cell) Serve Customers First + Move Faster + Act Boldly + Win As One
I have an app that will be used for tracking when our employees are due for training. I want to have a table that can randomly pull a certain percentage of records that will receive a formal check event. For example, say I have 200 employees that are due for training this month. I need to pull a random 50%, who have also not had a check event in a certain period of time. Is there any way to do this with Quickbase?------------------------------Hannah Engelson------------------------------
Not sure if that's what I need to be doing. See the table below. I want to show Total Turnover Rate (not a field in my table), in addition to FT, PT and PTR turnover rate. I was thinking that was a Summary Formula, but I can't work it out. On the table, I have the averages worked out, but I don't know how to get them in the chart. ------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
I'm trying to find a way to allow certain users of my app to grant access to other users, but only by giving the new users access to a specific role. I manage user access via roles and groups, with roles being assigned to groups vs. individual users. So really what I want to do is allow certain users to add people to one specific user group (which will then give them the role assigned to that group). I thought I could do it by adding the group(s) containing the users I want to give these permissions to to the group I want them to be able to add people to, and setting them as 'manager only'. But while I can add one group to another, I don't see the option to set that group as member/manager/both. It looks like I can probably add all the users to the group individually (and then set them as 'manager only') but if there's a way to do it by group vs. individual user, that would be preferable (mostly so that I don't have multiple places I need to add/remove individual users fr
Hello fellow Quickbasers! I'm working with a scheduled pipeline and the bulk record sets steps. The PL searches the Sites table in App A and send two fields' values to two fields in a Sites table in App B. Both of these tables are connected tables and share the Record ID#2 value (which is also both of their key fields). The Pipeline searches and finds the records in App A and then adds the bulk upsert rows in App B (this step should always be an update because of the merge key). At the Commit Upsert step, the Pipeline returns the error below with no further info. Two questions - Has anyone seen this? Does anyone have experience using a non built-in record ID field as the merge key? Thanks! Error: Remote API returned authentication error -- Processed: 0 - Added: 0 - Updated: 0 - Unchanged: 0 PL Steps: A: Prepare bulk upsert B: Search Records C: (start Loop) Add a Bulk Upsert Row (end Loop) D: Commit Upsert ------------------------------Raymond Sakar------------------------------
Hello, New to quickbase here. I'm trying to add totals of two different fields of specific service types. Ex: Service type contains Either "Reconstruction" or "Dry Out" and adding these two sums together and only showing the ones where the sum is over the specified amount. Any and all help is greatly appreciated. Thank you.------------------------------Chris Breault------------------------------
Can someone help walk me through how to do the following? I'm setting up a database that will be filled out via a form completed by users. They'll have to select a category from a dropdown in a certain field (let's call it 'category') - I want to be able to automatically assign a reference number to each record using the following format: C-AAA-XXX The "C" will appear at the start of every reference number. The "AAA" will be a three-letter abbreviation related to the category selected in the Category field. I've already made a field ("Abbreviation") that auto-populates with the abbreviation based on the selection in the Category field. The "XXX" should be a three-digit number, starting with 001 for the first record created per Category. So for each category, there will be a -001, -002, etc. I've tried everything I can think of, and am failing miserably. It's the 'unique number' part that's tripping me up, obviously. Finally occurred to me that someone here can probably tell me ho
I had the darndest time trying to find out how to use pipelines to get API data when the remote system uses OAUTH2. After lots of trial and error, I was able to make it work, and I figured I would share the info here. Attached are some instructions. These also might be helpful to users trying to get APIs working with JSON data. Comments on this are welcome.------------------------------Michael Frishman------------------------------
I need an average of the # of FT column. Because of the schema, it's counting nulls, thus essentially cutting the average in "half". I KNOW this can be fixed, I am just struggling. Might be because I am too many beers in, but I really want to conquer this tonight. :) ------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
Hello team, How can I add heading/some language/text to a quickbase report? Thanks in advance------------------------------vikas pasula------------------------------
Any suggestions on a pipeline that searchs thru a table looking for a record with a date, capturing a number value in that record and then searching the same table for a record with the next date (next date that follows the prior record date) and then inserts the captured value in a different number field in the "follow on date" record. ------------------------------George Bramhall------------------------------
I'm trying to see if there's a way that I can automate updating a Quickbase record's status to "delivered" once Fedex delivers a package based on the tracking number. Is there a way to integrate into Fedex's system?
Hi, so I have a complicated formula for a field I am using for calculating commissions based on whether it's a specific user. I know I can create a commissions structure table to make this easier, however the complication comes from a legacy employee we have. Everyone in who is a superintendent in our company has the same commission structure except one person who has a legacy to a previous structure. That is why there is no need to create the table. Every superintendent from now on and always will have this commission structure except the one guy. I want my formula to base the structure off of whether or not he is the user in a specific field. Normal Commission Structure: if GM%<=0.4299 you earn $0 if GM%>0.4299 you earn $100 Legacy User: Mike Andrus His commission structure is this: if GM%<=0.4299 you earn $0 if GM%>0.4299 & <0.4499 you earn 1% of the total invoiced dollars if GM%>0.4499 & <0.4999 you earn 2% of the total invoiced dollars if GM%>0.49
I was wondering if its possible to create a rule that will not allow the user to save a form if a date field value is less than +14 days from the current date? Also, could a message popup explaining the issue? Thanks, Brian------------------------------Brian Dunk------------------------------
Hi guys, I have a question for autogenerating number when I create a new record. So I have 2 fields which are Reference and Type. Please see below photo: "Type" is the multiple choices option which are shown below: What I want to set up is when I select Prov Sum, the record will start from 1.01, 1.02 etc. If I select Variation, the record will start from 2.01, 2.02 etc. If I select Anticipated Variation, the record will start from 3.01,3.02 etc. Every projects will be the same for the above sequence. Currently, I am inputting manually. Is this something I can do it by formula or pipleline? Thank you. ------------------------------Harris Tse------------------------------
I have a table called "Forecasts" with many different forecasts at different time periods. I want to create a field in another table that pulls a specific value from the "Forecasts" table into a field called "Original Forecast". The criteria for the "original forecast" field would be: Year = 2024, Forecast Type = Original, and the Column Name = Yearly Forecast. Can anyone point me in the correct direction?------------------------------Zachary Stein------------------------------
I'm trying to streamline some manual processes, and running into inconsistent results. I'm importing data into a child table. It has 4 snapshot fields that are set from the parent record. The child data is coming from a 3rd party, cleaned up (ex. making sure parent record id is correct). The goal is to get the clean up out of Excel, and simplify the upload to the child table. The fields on the parent record used for the snapshots are based on summary data from the child table. Specifically - based on the type of visit, if the Minimum visit date = Maximum visit date, then the child record being added must be new. It is the "new flag" that is used for the snapshot on the child record. FWIW - as weird as it sounds, yes the summary fields do appear to account for the new record as it is being added. I've moved the clean up to a worktable in Quickbase, no problem. I wanted to use pipeline to move the final data from the worktable to the Child Visit table. I created the pipeline, (simple API
I created a Sandbox for one of our Apps. In the sandbox, I gave a specific user the same role they have in the live app. I thought this would give them access to the Sandbox. My guess is they would now see the option to use the Sandbox or the Live version of the app (below).However, they do not see anything indicating they have access to the Sandbox. What step am I missing in order to allow a user to access to the Sandbox? ------------------------------Aaron Bab1692@att.com------------------------------
I am trying to highlight the email address field in reports if it is blank. I have tried If(IsNull([Email]), "#ffffba")) but it is not working, I am getting a syntax error. Do I need to convert the field to a text field 1st and then use the formula? Any suggestions??------------------------------Kelly Lyons------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.