Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
On my Ticket table, once a Team Member has been assigned, the Status field changes to "Assigned" should not be allowed to go back to "Pending". How do I make it so users cannot change the Status back to "Pending" while still allowing the status to progress through its other stages beyond "Assigned"?------------------------------Chris Swirtz------------------------------
I currently have a button that I will successfully open a new tab of that record and have a single desired field checked.But, I am wanting for this button to perform this same new tab action of the selected record except check 2 different checkbox fields (Field ID 15 and Field ID 140).I am able to get this formula to work with checking both boxes, but it does not successfully load the new tab.It will give me a page showing XML file not having any style information.The document tree is shows for the error: <qdbapi> <action>API_EditRecord</action> <errcode>0</errcode> <errtext>No error</errtext> <rid>3436</rid> <num_fields_changed>2</num_fields_changed> <update_id>1645813465811</update_id> </qdbapi>The formula I am attempting to use:"<a class='Vibrant Success' style=\"width:200px; text-align: center;\" href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoke
Hello Community,Wondering if anyone else is seeing "520 errors" coming from Cloudflare when sending API requests from Qunect or Workato? We have been asking Quickbase for information and so far there hasn't been a tangible response. We have been investigating the problem since the February update. Wondering if any Builders who are using external API tools to make data changes are dealing with a similar problem?A 520 error is a generic error from Cloudflare. The error tells us the service is not responding. The not responding service is Quickbase. Happy Monday,Jim HarrisonPortland, OR------------------------------Jim Harrisontransparency = knowledge + understanding : The Scrum Dudes------------------------------
I have created a Pipeline between QB and Slack, so that when a Record is Created in QB a message is sent to a Channel in Slack. How do I include a link to the QB Record in the Slack message?------------------------------Ashley Harris------------------------------
I've got a URL button "Submit" that creates a child record then redirects to the parent table. It works great, but I can't do it while in edit mode, which is really the place I need it. I want staff to be able to click "Submit" as they are entering data and not have to save it the record then click the button.------------------------------Bethany Hudson------------------------------
Hi All,I am preparing for the App Builder Certification exam. Yesterday afternoon after studying for a bit, I went to take the Practice Exam and I saw this message: The message is still showing today. I have not done well on the Practice Exams so far so I do not feel comfortable proceeding with the exam yet. Does anyone know why I am getting this message and/or how to resolve it? Thanks in advance for help!------------------------------Peyton Brooks------------------------------
When a new Ticket is added in the Tickets Table, how would I auto assign a Team Member based on the who has the fewest open assignments in the Assignments Table?------------------------------Chris Swirtz------------------------------
I have a button on a tabbed form that edits the form and reloads the page. When the page reloads, I'd like to be taken back to the same tab, rather than tab 1. Is that possible?
OK so we use a lot of automations, as Quick Base is a CRM / ERP for us. So we have automations that fire when certain conditions are met, and now that they are going away, I'm having trouble getting a pipeline to do exactly the same task. Specifically, I can't seem to filter the pipeline down the way I can an automation. is there something I'm missing here? Surely there is a way to filter...Example: When an opportunity's status is changed to WON, and it also has a $ value in a certain field, and it's territory is X, then perform Z action. I can't seem to get a pipeline to replicate this and I'm not really finding what I need in any of the documentation. Any help out there?------------------------------Thanks,Chris Newsome------------------------------
In my USERS list, it shows 2 identical users...I'm concerned about deleting one of them. Should I be?thx------------------------------BuildPro------------------------------
I've created a button to copy the content of a field to the clipboard that I thought would be useful to others.It copies the content of the field and then shows an alert that confirms what was copied.I've tested it with Chrome and Firefox which works, Edge did not. I used a Vibrant button, which allows me to put it into a Rich Text field with other buttons, instead of a Formula URL field. It will work with the URL field as well if you remove the button code. Hope this helps.Danavar text CB= URLEncode([Some Field]);var text Alert= URLEncode([Some Field] & " Was Copied to the Clipboard");"<a class='Vibrant Success' style=\"border:0px solid green; background-color:green; text-align: center;\"href=" & "javascript:{" & "navigator.clipboard.writeText('" & $CB & "').then(function(){" & "},function(){" & "});" & "alert('" & $Alert & "');" & "};" & ">Copy to the Clipboard</a>"
Hello,We have a status for each of our wells. Our GIS person has a connected table to our Wells table. He wants to see a date stamp for when a status changes. I made a field that has this formula [BM STATUS]& " " & Now() which results in this, SPUD 02-24-2022 01:21 PM, but they don't want the text in a date field. understandably. So how can I date stamp when only that field changes without a pipeline? ------------------------------Renee Hansen------------------------------
I am trying to create a pipeline that will create a new record in a different table using data from the source table. There are two file attachment fields in the source table that I want to add to the target table while creating the new record. I am able to add all of the other fields I want to use for the new record, but am not able to add the file attachment fields in the list of fields to specify values.What do I need to do to add the two file attachment fields to the new record?------------------------------Paul Peterson------------------------------
I have a Sales table where at the top of the form the sales person selects a Company, then a related Location, then a related sourcing contact from that location. At the bottom of the form is where the trucking information for that sale is located and there is a spot where the person setting up the truck has a dropdown of the same related contacts from the company above only in this case the are selecting the Shipping/Receiving contact for that Company. I have this bottom contact set up as a 2nd relationship to the contacts table but using the upper company and location selection for my conditional dropdown setting, and I thought it was working fine, but now it doesn't seem to be working. Is there a better way to set this up?------------------------------Chris Swirtz------------------------------
I have a form that is tabbed and a field is required on the first tab. If someone saves and closes while in another tab, the pop up message does say what tab and what field is missing and then highlights the tab in red (see below). But, when the user clicks OK, they are still on the tab they were in when they clicked save and close. Is there a way to redirect the user to the tab with the missing field information instead of just highlighting it?------------------------------Jamie Owens Knight------------------------------
Hi,I need to upload a submission (service report) pdf file from FastField to an attachment field in QB.FastField doesn't enable using URL in this case, so I cannot use Upload File from the QB Channel.Instead of that, FF provides a Create PDF Report API (POST). I used Webhook (Make Request) to call that API. In the response I really got the pdf file ... Access-Control-Allow-Headers:"Content-Type" Content-Type:"application/pdf" ...but I don't know how to "pick it up" to QB. Do you have any hint?Thanks in advanceAlex------------------------------Aleksandar Lazic------------------------------
Hi, QuickBase is supporting date format as mm-dd-yyyy, is it possible to get date field as mm/dd/yyyy?suppose the user enters random text say "jvbsdv" in the date field in the form, the application should prompt user to enter valid data (or) the date field should be cleared. is their any way to achieve this in the Quickbase?
How can add a "new record" button to another table with a form and have it populate a certain field from the from?So passing along the right value through the button url into the form?------------------------------Lashell Thomas------------------------------
How can create multiple records based on a multi-select text field using pipeline?So I can get the easy of a drop-down with the power of a join table....If you can share the detailed solution that would be great.. Really need some helpLashell------------------------------Lashell Thomas------------------------------
QuickBase A: Import "Project" from QuickBase BThere is a join table in QuickBase A - that pulls "projects" and organizations together. "Organization" and "Projects" table is QuickBase A.I want the users in QuickBase B to be able to use the QuickBase A join table - to add an organization to the correct project (their project that was import into QuickBase A. Here is the catch - they would like to do this within their QuickBase B and not have to come over to QuickBase A to do this.I have a number of set-ups like this - so I want to learn the right approach - so I can replicate it.------------------------------Lashell Thomas------------------------------
Hello,I was working on a pipeline over the past couple of days and when I came back to it today all of my conditions had been cleared. This is a large bummer because my pipeline was essentially a large tree of if statements. So It just about cleared all of my work. The only thing remaining was the actions like update record and search table. This is not the first time this has happened so maybe I am doing something wrong and I'd like to prevent this from happening in the future because losing a couple of days' work is ... frustrating. I have attached a screenshot of what it looks like without any conditional properties. Please let me know if you know what's going on with this. Thanks in advance!------------------------------Hank Halverson------------------------------
Perhaps this is by design, but I think I might be confused.I have a notification that is triggered when added or modified 'when the following fields change'. The only field selected is a checkbox.Every time a record is added, it fires. Is a checkbox assumed to be changed as soon as a record is created?------------------------------Mike Tamoush------------------------------
Hello all,I see others sending work orders, purchase orders, invoices, and/or etc. as a PDF from QuickBase. I have seen others do this at my company with our QuickBase system. Can someone please advise the process for saving an invoice, purchase order, or work order as a PDF? This would be extremely helpful as I have to send these purchase orders out to company's that do not have direct access to our system so "Send PO as email" or "Send WO as email" does not work in these cases. Even if I send the PO to myself it does not send it to me as an attachment, it copy/pastes the WO into an email. Any help would be great!------------------------------Bryce T. ------------------------------
Hi,Below is a Report formula I built to ideally solve the following problem:We have an application where users can submit records to be processed. We want to limit the number of records that can be viewed based on an organizational/managerial level. We have an Employees table with all the necessary data, but I run into the issue where QB can recognize me as the current user, but cannot associate it with my Employee record to the Financials table which records I should be able to see. I want it to be based on everyone below my tier 2 manager. So everyone who has that manager, I should be able to see their records. I attempted to build out the following formula, but QB told me it was too time intensive to run. Hoping someone has a tip on how I can refine my formula or a better solution to my problem.Thank you!Formula - Checkbox//This will get the username for the current user's tier 2 manager in the employees table via a formula query//This box will check if the current user's Manager 02
Hello QB Folks!I've done a bunch of looking around, and can't see an out-of-the-box solution.I get a couple of excel files (in .xlsx) a day that I load into specially-set up staging tables in my quickbase. From there, I have pipelines moving the data into other parts of my app.I'd love to figure out how to drop the file into a watch folder in OneDrive, and have the rows loaded as-is into my staging tables. I can see the OneDrive pipeline, but it doesn't seem to have a function to process the contents of a file.------------------------------Malcolm McDonald------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.