Qrew Groups
Connect with others from your area, or who share the same role, professional interest. Find your Qrew here!
Links Banner
Main Content
Recent Content
Including two classes in one button
I'm working with a rich text button. The button is on a parent record. The user clicks the button, the parent is saved, and then a popup opens to add a child record. When I add the savebeforenavigating class, the button stops opening the window in a popup and instead opens in a new tab. Is it possible to include both classes in the same formula? var number rid = [Record ID#];var text url = URLRoot() & "db/" & [_DBID_CHILDREN] & "?a=nwr" & "&_fid_10=" & URLEncode($rid) & "&ifv=1" & "&hs=1"; var text color = "#228B22"; var text txtcolor = "White"; "<a class='SaveBeforeNavigating' & \"OpenAsPopup\" data-height=\"800\" data-width=\"1000\" data-refresh=\"true\" " & "style=\"text-decoration: none; text-align: center; background:" & $color & "; color: " & $txtcolor & "; border-radius: 5px; margin: 2px; padding: 5px 5px; width: 100px; display: inline-block; font: 14px/ 'Calibri', 'Segoe UI', sans-serif; text-shadow: none;\"href='" & $url & "'>Add Child</a>"July 2025 Qrew Meetup Event
Portland Qrew is meeting Wednesday, July 23rd, at 3PM PST at Harder Mechanical Contractors and also on Teams. This month we'll look at DocGen lessons learned and alternative solutions. We will also check in on moving Pipelines and setting up a separate Notification. We will talk about current projects, new changes and challenges. Anyone can show off work and cheer each other on to higher heights. We ask attendees to bring problems to solve and then work together to provide a solution. Anyone willing to share is welcome to have a problem solved by a team of very nice people who all love helping. Afterwards I suspect we will go out somewhere and welcome recommendations. If you would like to join remotely email jharrison@harder.com directly and he will send you a Teams invitation. Near Laurel Hill, OR
Unduplicated people summary report
I built this summary report and need help filtering out duplicated clients. This report is built on the "Case Clients" table that is the many-to-many table connecting "People" to "Cases". I need this report to only show unduplicated people within each column. I have not used Help!
Help with searches...
i set up a report that lists each vendor and what states they checked off for service area, they are checkboxes, i don't know how to make it group all vendors that service alabama, all vendors that service alaska, all vendors that service arizona, etc... my ultimate goal is to create a search widget that will filter by service area i inherited this app and it was seriously lacking. i'm new to creating and working on app setups. i have taken the intro to app building and intro to pipelines courses so that i could make some changes and i just can't figure this out.Southern Companies is Seeking a Quickbase Developer / Engineer - Kilgore, TX
Southern Lifting and Hoisting, LLC and Southern Transport, LLC Job Title: Quickbase Developer / Engineer Location: Kilgore, TX Employment Type: Full-Time Department: Operations About the Role We’re seeking a driven and solution-oriented Quickbase Developer / Engineer to lead the development and optimization of our custom-built applications across key operational workflows. This is a high-impact role for someone who thrives in fast-paced environment and wants to transform how field teams, equipment, operations, maintenance, and financial data are connected. You’ll be at the center of designing scalable solutions while engineering back-end logic, and seamless integrations with other platforms (e.g., Power BI, SharePoint, Office 365, Samsara, Paychex, and more). This is more than just building apps - it’s about building infrastructure that drives and enhances performance across an enterprise of business operations. *This Role will require frequent travel to throughout TX, LA, OK, and WY. For more information about who we are, check us out @ www.southernliftingandhoisting.com or www.southerntransport.com Ready to engineer impact? Submit your resume and a portfolio of Quickbase applications or examples of relevant work to: chad.pinkston@southernliftingandhoisting.com] Subject Line: Quickbase Developer Application – [Your Name]
Pipeline Error trying to Create a Record
I am not a fan of Pipelines. I miss Automations. I used to be able to build an Automation in like 30 min and it did what I wanted. I've been working two days to build this Pipeline, even using the AI to do the framework, and I get nothing but errors or issues like this one. The intent of this pipeline is, if a record is created/updated in one app, it will look to see if there is a matching record in another app. If there is a matching record in the other app based on a site # & uniquely created identifier, it will update any modified changes in the second app. If there is not a matching record, it will create one in the second app. After tweaking several different things, I finally got it to create the record. At first, it was saying it was finding a record that matched the criteria despite no record being present. But now, whenever it does the search for a "Matching Record" based on the criteria I asked it to look at (site & unique identifier), it continues to have a FALSE finding and just creates a duplicate instead of updating. And the Activity log seems to say that it couldn't find the record based on the search criteria but created duplicate records with the exact criteria it was asked to look for. (I now have 5 records with identical site #s and unique #'s. What am I missing to get it to have a TRUE finding of the record. Also, is there any way to change the "Query" to look at anything besides the Record ID??Counting Instances of String across records for use in a Gauge Chart
Hi all, I want to use a gauge chart the displays the number of records that contain the letter 'R' as part of a string of in a 'Job Number' field, out of the total number of records in the table. Typically a job number field value would be in the format of 00000_00, or 00000_A0, or 00000_R00. With R denoting revised. I've tried using a query report formula, but whilst it's a valid formula attempt, it displays 0. The total number of records for the gauge var text QUERY = "{6.EX." & Contains([Job Number], "R") & "}"; Size( GetRecords($QUERY)) My logic to the above is that its querying the data table, for job number field (ID 6) to see if it contains a string with an 'R' in it, and if so count the total number of true records. Any ideas? It would be awesome if the gauge can be coloured to show the revised element in red, but the remainder of the gauge in green. But I really think that's beyond the limits of what is possible. However, if anyone has an idea how this could be accomplished, that would be absolutely appreciated!
