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>"3Views0likes0CommentsJuly 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, OR14Views1like0CommentsRefresh Connected Table Error
I'm getting this error when trying to refresh my connected table. I have no clue what I need to do to fix it. Help please. The error was: You do not have permission to import into the table. QuickBase API error: Insufficient permissions. Tracker ID: [4c5jvdi5z922]16Views1like1CommentPipeline Jinja For Duration in Seconds
I would like to have a pipeline condition where nothing happens if the current time is less than or equal to 30 seconds from the value in a given field, which is a date/time field. I have tried multiple variations of jinja code and mostly get the error message: Validation error: Incorrect template "whatever my jinja is". ValueError: invalid literal for int() with base 10: 'my_date_time_field_name' I have tried subtracting and converting the time.now and my field to an integer before comparing to 30 for seconds, I tried using time.delta(seconds=30) and adding it to the date field then comparing it to the current time, and some other things. I get the above error each time. I would really like to do this with Jinja, if at all possible. If anyone can help, that would be greatly appreciated. I know, worse comes to worst, I can add a helper field and just work off of that, but I am doing this for learning purposes. Thank you in advance to anyone who can help.Solved74Views1like10CommentsHide Save Button on New Forms
Do you want to remove the native Save/Cancel buttons on new forms or new mobile forms? Add &ifv=1&hs=1 to the form URL. They must be used together for it to work and this work in Edit mode. Note: It must be ifv=1 — other values like ifv=10 won’t work with hs=1.Solved407Views1like2CommentsUnduplicated 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!17Views1like2CommentsHelp 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.25Views0likes1CommentSouthern 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]26Views1like0CommentsPipeline 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??58Views1like4CommentsCounting 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!45Views0likes5Comments