Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I know how to call a Quick Base API with a Pipeline Webhook :"Make Request".Does anyone know if it's possible (or not possible, so I don't bother to keep trying) to call a Quick Base Code Page with a pipeline?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------
I have a parent table called Housing and child table called Enrollment. As part of the enrollment process, user will assign a housing unit via a record picker in Housing table. When this happens, I'd like to mark that housing unit as "booked" so I can then filter it out of record picker results. Is it possible to mark a record in a record picker or is there a better way to accomplish end result--i.e., prevent double-booking?
I have master table in which I have Date, Description and Icon (All are sorted in descending order). But when I looking them in child table they are not sorted in descending. I want them in ascending order of date. Thank You!https://drive.google.com/file/d/1M7tlnl1ela8LZu92Z11x0r0yuMWPzhLU/view?usp=sharing------------------------------Amedha Surve------------------------------
Has anyone connected to the Microsoft Graph API from a pipeline? I need access to some outlook data that doesn't come through with the methods provided by the Outlook channel. Specifically the "New Time Proposed" values for calendar item updates. The graph API provides the information I need in a straightforward way. I'm having trouble getting authenticated. I've provisioned everything correctly, and can use the client_id client_secret values in Postman. However when used in the pipeline, no token is being provided. The error coming back from the pipeline is... not illuminating.------------------------------Dan Locks------------------------------
I have the following tables set up: Customers, Contacts, Locations & Projects. In "Projects", I have cascading drop downs set up to choose related Customer, related Contact & related Location. I have designated "Proxy Field" values for all 3, but they are still displaying as the Record ID numbers, instead of the Proxy Fields. When I edit the project, it shows the proxy fields correctly, but in the grid view, I only get the numbers. What am I doing wrong and how can I make it show the proxy values on the grid view? ------------------------------Allison Watson------------------------------
I want to remove records where FID's 9, 10, & 11 are blank. I am using query {9.LT.1}AND{10.LT.1}AND{11.LT.1}, but it isn't working. Any ideas? Here is an example from the activity log: I have the pipeline set-up right because I tested it by deleting all records in a table using query {3.GT.0}. ------------------------------Adam Keever------------------------------
Does anyone know how to alert users who have been newly added to a user list? I need to be able to alert only the newly added user(s). Sometimes multiple users will be added at the same time and would all need to be notified. Thanks!
I have a form that is used by 5 different roles for approval. After each role does their approval, it moves to the next role. At that point, the role that approved it should not be able to edit certain fields. If I do a role permission based on the approval field, then all fields become read only. If I do a form rule, I can't do one for each role as the rules conflict for making fields read only since the fields would be in each form rule. I don't want to make multiple copies of the form as that could become a maintenance nightmare. Is it possible to do a combination of role permissions and a Custom Data Rule? The role permission would make the whole form read only, but could the Custom Data Rule override that to allow certain fields to stay editable? I'm thinking the rule would state "if ANY of the following are checked , make editable . Would this work? If so, how would that be written? Or is there a better way to do this?------------------------------Amy Gosz------------------
I have a table (x) with fields (serial number, serial number assign date) and a second table (y) which is a child table wherein I need to automatically select the next available (where serial number assign date = null) serial number from (x).------------------------------Altaf Rawoot------------------------------
I want to only create a new record if the field 'status code' = '404' and if it was previously '200'. Is this possible in a pipeline? ------------------------------Matt Makris------------------------------
Hi everyone,I am having trouble connecting pipeline channels. I have done it in the past and set up the outlook channel but now it says, "This channel is disconnected, please contact your admin to connect this channel". I am the admin, and I have looked it up on the help page with little success. Has anyone else encountered this or know how to go about adding the channel? Thank you in advance!-Hank------------------------------Hank Halverson------------------------------
I have a Date of Report field, a Date of Birth field and next to it we compute Age; how can I fill the Age field automatically based on DOB and the original date of the report?
checkbox [WARRANTY BILLING] = If([TO BE BILLED BY:]>(Today()+Days(11)),true,false)is not working... thank you------------------------------BuildPro------------------------------
Hello is there any possible way in QuickBase to have a stacked bar chart with more than one series. Right I have, x - axis for month, y - axis for # of total Accounts, and series employee. So each bar is split showing the number of accounts assigned to each employee for a particular month. Would it be possible to display the total dollar amount of accounts with each employee in a bar?------------------------------James Dalton------------------------------
I'd like to create one formula text field, not sure how to set up the conditions, believe it's a case condition. Below are the actual field names including dashes "-" all other fields not listed date are text fields unless noted. Will appreciate the help Display the text "Phase 1" All fields are NULL Program – HTH (Text field) RRH Match (Numeric Lookup) nonDHS Program – Manual Display the text "Phase 2" At least one of the following fields is NOT NULL Date of Match to Program - HTH nonDHS Date of Match to Program - MANUAL AND All of the following fields are NULL Date Provider Changed - HTH nonDHS Date Provider Assigned – MANUAL Display the text "Phase 3" At least one of the following fields is NOT NULL Date Provider Changed – HTH Most Recent Program Entry Date - RRH nonDHS Date Provider Assigned - MANUAL is NOT NULL All of the following fields are NULL Intake Date - RRH None of the follo
Does anyone have experience with assigning a variable in Pipelines and changing it throughout the pipeline.Basically, I want to assign a variable at the start of the 'for' loop and then increment it by 1 for each part of the loop. Has anyone done this?------------------------------Jessica Feauto------------------------------
This post describes how to build a set of three buttons that aid navigation of long forms. When a form has many sections and fields, one solution is to use Tabs. However, if there are several sections within a Tab, users may still have to do a lot of scrolling and clicking. The idea proposed here is to create a set of three buttons that float, always visible, at the bottom of the form:[Back to Top] [Collapse] [Expand][Back to Top] simply scrolls to a standard location near the top of any page (#navTop). While Quick Base has a handy icon to scroll to the top, it's placed near the top. Normally you want to do this when you are near the bottom, so it's handy to have a button located there. [Collapse] and [Expand] use fairly simple JavaScript to collapse or expand all sections. The versions described here are compatible with Tabs in the following sense. They only collapse or expand within the current Tab.With these buttons, a user who knows the structure and contents of a long
Hello! I was wondering if its feasible to leverage quickbase solely as a backend (to design workflows and data models etc) and connect that to a completely custom user facing application that we're building in React/Next.JS. My use case is so build a tailored project management application for industry specific vertical (home renovation). There are two user types each with their own dashboard. Consumers/Homeowners - they have will have basic dashboard that shows progress of their project, let them upload files or send messages etc (which would need to post to quickbase). Staff/Designers/Contractors - they would have a dashboard that lets them manage the projects, upload tasks for internal folks to do, send updates to the clients etc. The nature of the project requires that we build completely custom ux for both user types above - the only ones that would be using quickbase would be our software team and workflow designers. Not the core end users. Let me
Hello - When an invalid multiple-choice option is bulk uploaded into a field it shows as red. Is there any easy way to identify records with invalid options for data cleanup? I can export all my multiple-choice fields and manually compare records to the valid choices of dropdowns but would love a faster/simpler way to manage this. I have not seen a way to sort/filter by invalid options quickly within QB which would be my first thought. Any advice on the best way to does this type of cleanup efficiently? ------------------------------Thanks in advance,Jennifer Paschal------------------------------
Good Morning, Is there a way to restrict a date field? So there is a table for Task Z. Dept. A creates new tasks, however, once created the second step in the process is done by Dept. B and there is a Due Date field to let Dept. B know when their step needs done. Dept. A has a habit of just putting today's day as Due Date. Dept. A has been told multiple times not to do this but still does it anyway. Is there a way to restrict that field so that Due Date cannot equal Today? (I don't need or want it to auto calculate based on a set time frame, like today is 3/15 so the due date is automatically 3/16. The due date could be 3/16 or it could be 3/21 or it could be 4/28, as long as it is a least 1 day in the future so that Dept. B actually has time to work on it.)------------------------------Brianne Jacobsen------------------------------
Could be simple or major here.... The owner of a few of our connected tables has left the company. (I have his login if it helps) of the 5 he owns, 3 of them- I was able to simply "Use a different connection" which made me the new owner. However, 2 of them; when I change to myself, they error out trying to refresh. Error being "The resource '[[connection_176165]].[[bpqrpkjmt]]:ServiceDefinitionTable' does not exist." I believe it is because there are table to table relationships built off of the connected table. Could also be required or key fields are oddly causing it to error. Not sure what I am doing wrong... How can I transfer this to my name and have it refresh successfully? Thank You In Advance ------------------------------Eddy Elasmar------------------------------
Hello all, I have been trying to find any way to set up a pipeline that extracts the last 5 characters of a text string of varying length to copy to another field. There are some consistencies that could be used to identify the start of the string, but a formula that simply states "X characters" would be most straightforward. Is that an option in QB?Thanks in advance!------------------------------Amy Christensen------------------------------
Build your Data Governance framework using Quickbase Gartner reports that more than 80% of the companies and 59 % of government entities have set up "fusion teams" - multidisciplinary (digital) business teams that blend technology and other types of domain expertise. The rise of fusion teams is evidence that the boundaries between IT and the rest of the business are blurring at an accelerated rate. What does this mean? Practically it means that IT governance has never been more important for builders, administrators, and business personnel. A good governance framework ensures apps and processes become more scalable and approachable, while also satisfying the needs of the organizations and protecting all the shared data. What is a Data Governance framework A Data Governance framework creates a set of rules and processes for securely gathering, storing and using data within an organization. With the expanding volume of data, a data governance framework makes it easier to: Maintain pol
I currently have this code Case([Follow-Up],"Check on Inspection","#7FE2EA", "Waiting on email response","#f69100") and I wanted to add a code to highlight a record based on a date field. I tried both of these and they are not correct. Can anyone assist me with how this field should be formatted? If(Today() > [Adj. By], "<span style='background-color: #FF0000;'>" & [Record ID#] & "</span>", [Record ID#]) Case( Today() > [Adj. By], "<span style='background-color: #FF0000;'>" & [Record ID#] & "</span>", [Record ID#]) Thank you! ------------------------------Rhonda Jones------------------------------
Hello Quickbase Community! I'm having issues with a pipeline. Step A: Quickbase Channel - Quickbase API - Make a Request Essentially, I query data in a table and get back some JSON data. This step works completely fine. Step B (the problem step): Quickbase Channel - Quickbase API - Make a Request This request is to post data to a test table for now. I'm trying to run a for loop on the data. I'm eventually going to incorporate the myTimeStop variable, but it can be ignored for now. I'm trying to iterate through the data, adding a line for each one, and keeping a running total for row '33'. This works, but it's still resetting the runningTotal to 0.0 in each loop for some reason. Table ID redacted. {% set myDataSet = "myTableID" %}{% set myTimeStop = 5.0 | float %}{% set runningTotal = 0.0 | float %}{ "to": "{{myDataSet}}", "data": [ {% for row in a.json.data %} {% set runningTotal = runningTotal
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.