Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
So I saw a video on youtube that showed a startup screen with a dialog box that said" The fastest way too your app is working with our team" but I never have seen this...like to explore. here is video link https://www.youtube.com/watch?v=FtgWgii1k1c------------------------------Tom Mitz------------------------------
Hi All, I've watched all the youtube videos and looked at all the posts, but I can't seem to get my head around this. I have a table with the following fields: store number User ID Selected as Admin (checkbox) A user ID can be found in more than 1 store, but cannot be selected as Admin more than once. So basically I want to say that if the user ID is selected as Admin in another store already, it can't be selected in this store. I've embedded a user record report in the Store form to show all the users for that store. If a user in that store has already been selected as Admin in another store, I don't want them to show on this report. I'm thinking that I need to create a 4th field "Already Selected as Admin", and somehow look for duplicates. If one of the records in the set of duplicates is selected as Admin, set "Already Selected as Admin" to true for all of them. Then I would just filter out records that way. Hoping someone can help! Thank you, Kim----------------------
I've processed a csv using aws lambda, and dumped it to an S3 bucket as a gzip archive. Is there a way to unzip the archive and load the csv in a pipeline?------------------------------Dan Locks------------------------------
Is it possible to trigger a Pipeline when a formula field changes on record update?I've created a pipeline that is set to trigger when a checkbox formula goes from false to true. It's not triggering when the record is updated. These records are audits - when one is considered "complete" (the checkbox formula decides wether this is true or false), I need today's date/time to be written to a static text field. Any ideas here are appreciated, thanks!------------------------------Matt Makris------------------------------
I am trying to figure out how I can copy certain info from a parent table into a child, I have read through many threads but am still stuck. I have a parent table "Accounts" and I want to be able to copy/autofill certain field in my "Estimate" table. For example when I am creating a new estimate for an existing account, I want to autofill/copy the new estimate with the fields from the parent table. I looked into and tried the copy master and detail option, but am still confused. Could I use a webhook or action to set up a button on the child table/forms to accomplish this? The new record being created will always have the same info I need to autofill. Any help would be great!------------------------------Kelly Lyons------------------------------
Hello, I am attempting to create a report that pulls ONLY the last sentence of a note. Can I please have step by step directions on how to do that?------------------------------Laurie Anderson------------------------------
I'm super excited about the new Quickbase Gantt Plugin which has just been released.However, I'm curious if there is an automation / code out there that will automatically add all the required tables and fields to existing apps? I have plenty of apps that I'll be adding this Gantt capability into. Most of them will have a couple of existing tables that will be used in the Gantt, but most will need to be created. I could create them manually, or I might go and write my own code to automatically setup an app with all the required tables.... don't want to do this if it's out there already. The idea is that the code would create all the tables... then I'd just cull the new tables that I don't need because I already have similar tables.Cheers,Matt------------------------------Matt Stephens------------------------------
Hi, I am trying to migrate an existing automation to pipelines. The problem is the automation includes more than 26 steps. All the actions in automation is adding a record to a certain table and that step repeats 49 times. In other words, Add record 1, add record 2, add record 3.....add record 49. Is there a way to optimize the existing automation to reduce the number of steps to below 26 and migrate to pipelines?Or is it better to build a new pipeline and how do I build a new pipeline with steps less than 26 but at the same time add 60 records or more.Any help will be appreciated.------------------------------Bibhav Rimal------------------------------
I have a 4 tables; Testing Procedures, Requirements, Compliances, Applicabilities. Each Requirement has multiple Testing Procedures. Each Requirement has a Compliance. The last tabel Applicabilities has a form where a user will check boxes if they apply to them. Certain Requirements and certain Testing Procedures will only apply to the user if they have checked a certain Applicability field. On the Compliances form I want only the requirements that are able to be applicable to be able to be chosen for the related Requirement. Additionally I want the testing procedures that are not applicable to be hidden. Is this functionality possible without having to make different user roles and views? ------------------------------Lydia Mitchell------------------------------
Hello,I have a reservation system as an App. It's for reserving facilities across our parks (Houston). Sometimes, constituents want to bring alcohol to their reservations. They select, from a multi-choice select field, yes or no (for alcohol). After they have submitted their reservation request, our reservationist goes into the system and changes an admin only field on their reservation from "new request" to "confirmed" (assuming everything else on their request checks out).Houston Constables need to be notified of any alcohol reservation. I want an email to be sent to our constable correspondent's email address under these conditions: Our reservationist changes the constituent's reservation request from "new request" to "confirmed", and "yes" to alcohol must have been selected on their reservation request. Thank you.------------------------------Coleman DuCharme------------------------------
Hi, Has anyone been able to set up a notification for a form to be able to be sent to an email entered in that form? We'd like to send emails to clients regarding the status of their request form.------------------------------Gabrielle Heaton------------------------------
Our company was merged and we may consider updating our realm address. There are a number of places this becomes a bit of work, but the real issue is this:I have about 15000 QR codes stuck on equipment around the country. We wanted these QR codes to be scannable by any phone camera, and then direct to an asset record in quickbase. I pulled this off by hard coding the website "https://myrealm.quickbase.com...."This clearly will be a problem if we switch the realm. The only idea I can think of, is to spend the next year slowly updating and changing the QR stickers. However, I think the only option would be to hard code to the new realm? Is this correct?Otherwise, the only way I can think to do it is use the URLRoot() terminology, however I presume this would only work if you logged into QB and then somehow scanned that in a specific field?In my head, hard coding the realm is the only way you can use the phone camera to scan the QR. Is my thinking correct?Anyone have any ideas.....on solu
Hi, Is there a way to export YAML from an existing automation? I know we can import YAML from an existing pipeline.------------------------------Bibhav Rimal------------------------------
Is there a way to automatically assign a user to an app and a role, when their account is created in quickbase?If using SSO and auto provisioning, does that help or give any more options?------------------------------Mike Tamoush------------------------------
I'm trying to embed a report as a field in another report. Basically this: I've created the code page: [iol] & "modulecontracts.js" & [/iol] & "<span class='QBU_ToggleChildren'" & " data-rid='" & [Record ID#] & "'" & ">+</span>" I'm having trouble with the formula field: (function(){ $("img[qbu=modulecontracts]").remove(); var dbid = "bqij8g449"; var dbid GrantBudgets = "bqrnue9x7"; var rid= "85"; var apptoken = "b4bgu9_mk8a_0_dut3hpibru9pbtq884vsd7djvmt"; var querystring=document.location.search; $(".QBU_ToggleChildren").on("click", function() { if ($(this).text() == "+") { $(this).text("-"); } else { $(this).text("+"); } var rid = this.dataset.rid; $("#child_rid_" + rid).toggle(); }); }) I need help!------------------------------Bethany Hudson------------------------------
Hi, A ticket to our hospital employees last Thursday, 2Feb2023, that they lost passwords and requested to reset. But the employee said, it appears a new account was created. They said they are unable to see any data?Was wondering if anyone has had this happen? I don't see that they have gotten any resolution and I have a Zoom in a couple hours. I thought maybe I could suggest a solution or questions to ask?Thanks.------------------------------Bob T.------------------------------
I have a relationship between my `Clients` (parent) and `Products` (child) tables. In a Summary report in the `Products` table, how can I display a total number of `Clients` records? I'm not having any luck adding a Summary field (distinct count using `Client Name` field in `Clients` table). To summarize, I need to know how many clients are subscribing to products.------------------------------Matt Makris------------------------------
Hi everyone,I am trying to create a button via rich text field that will process an API call to update a record, open an email via a mailto, and redirect back to the record page I was on in one click. I understand there is no way to confirm the email was sent, but opening in the browser will be okay by me. Here is the code I have, which shows a white blank page after running. How do I continue the rdr back to the url? You can see I commented out code as it was not working:var text baseurl = URLRoot() & "db/"& Dbid();var text purchTbl = $baseurl & [_DBID_PURCHASE_ORDERS];var text editRecord = "?a=API_EditRecord&apptoken=" & [EliteApptoken] & "&rid=" & [Record ID#];var text LABEL = "Executive Approval";var text decoration = "text-decoration: none;"; var text bgColor = "background: #0044cc;"; var text txtColor = "color: white;"; var text txtAlign = "text-align: center;"; var text txtShadow = "text-shadow: none;"; var text border = "b
Hello,I am trying to use the table to table import functionality that is built into QuickBase. I am currently using this feature on a few different tables as a way to archive large tables (over 1,000 fields). I was able to set up the table to table import a week ago, and then all of the sudden, when I go to edit the table to table import and adjust some fields and where they copy over I get this error: Too Much Data Your request produced over 194MBytes of data. This is over the limit we can safely transmit to your browser. Please simplify your request. Also, the main table : Size: 207 KB (211,515 bytes) (less than 1% full) The archive table:275 KB (281,372 bytes) (less than 1% full) Any idea why this would all of the sudden start happening?------------------------------Shane Miller------------------------------
Employee has 20 days at beginning of PTO time periodEmployee has multiple time-off requests throughout the period.How do I create a running total field [REMAINING DAYS] off of [DAYS ALLOWED] field?thx------------------------------BuildPro------------------------------
Hierarchy: Roles < Templates < Classes < PointsI have 5 tables: Roles, Templates, Classes, Points, and a join table that has several match types, since it's a many to many in all cases: - Role to Template - Template to Class - Class to PointI am able to successfully create embedded records based on the match types above. However, I need to roll up grandchildren: - Points into the Templates table - Classes into the Roles tableAnd roll up great grandchildren: - Points into the Roles tableI have tried the structure (attached) without success.------------------------------Colleen Burch------------------------------
For some reason, my users are NOT fans of inputting time values on the mobile app (brings up the pop up with the dailer style window).Is there some way that I have have them input say 2 fields (number or text whichever works) as follows...Time:Am / Pm24 Hour time: (this is where I will need help with a formula to calculate the correct time from the two above fields).Any help appreciated.Cheers,Damien------------------------------damien page------------------------------
Hello,I have an accounting person leaving our company and a new one coming in. We are a smaller company so lots of notifications and formula buttons were set to send information to this individual. I used the search in schema to find the URL buttons doing this and reprogram to the new user.Is there an easy way to search all notifications and subscriptions to update as well? Seems cumbersome to go table by table.Guess I am learning the hard way to try to be better about using roles only but that didnt work 100% in this scenario.------------------------------Ivan Weiss------------------------------
Hi, I have two columns Erect Hours and Total Pieces Erect. This is what I want to get at using report formula;(Sum of Total Erect Hours * 60) / Sum of Total Pieces Erect. (64102.36*60)/352507.5 = 10.91I tried using this Sum([Build - Erect Hours])*60/Sum([Build - Total Pieces Erect]). However, it is not calculating the column total but it is calculating row total. Any help will be appreciated.------------------------------Bibhav Rimal------------------------------
Here is my setup:I have a table of Events. Each Event has a date, and a reading of total gallons used.I want to plot on a chart the number of gallons used since the previous reading. Thus, I am trying to make a field that shows the reading from the prior date, and then use formulas to just do the math and subtract. If I can also get the actual prior date, then I can use duration to find the number of days since the prior reading. More math will give me a gallons per day average, which is the ultimate goal.I tried Ranking using formula queries, and then more queries to get my info. Unfortunately, I have too many records and get the 'this query will take too long and screw everything up' warning.Any other ideas on how to get a gallons per day, when the data set I have are records with dates, and total gallons?------------------------------Michael Tamoush------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.