Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I have this daily report (see attached) that changes every day. I would like to email this automatically each evening at 4:00 PM to myself, but, want each project number to have its own separate email with the job number in the title of the email. Any suggestions on how to go about this? (Ex. using the attached document, for this particular day, I would have 3 emails total: project 12346 with 1 ticket listed, 199990 with 1 ticket listed and 12345 with 2 tickets listed.)
Hello, I'm wondering if there's any clever solutions to route to the file manage plug-in so end users can add documents to child records when they are also adding a parent record. I know natively that's not available due to lack of RID on the parent.But I was hoping to leverage some other formulas I've used in the past to circumvent this issue, but I'm getting syntax errors when I attempt to combine elements - I'm curious if this is user error or due to the plug-in it's simply not adaptable?general use case:User adds accounting record for invoicing, as a legal requirement in 2026 they have to now add several large documents for which I would like to leverage the file manager plugin. Samples of what I've concocted:The intention is to save before navigating/opening the file manager and/or use the %%rid%% to provide a new RID for the parent record so the user can bulk add documents with the parent form submission - I think I've scrambled somethings://original plug=in URL. do not tamp
Our next in-person Philly Qrew meetup is happening on Thursday, March 19, and we’d love to see you there! This meetup will be interactive, collaborative, and community-driven, designed for builders, admins, and everyday Quickbase users who want to connect, share ideas, and learn from one another. What’s on the agenda? 🔹 Workshop-Style Discussion with Laura Natal (Qrew Leader)Laura will lead a conversation on best practices for planning and executing large-scale development projects, sharing real-world examples and lessons learned along the way. 🔹 High-Level Jinja Discussion + Open Q&AOur Lead Quickbase Technical Consultant, Christine Suarez, will join us virtually for an approachable, high-level Jinja discussion - with plenty of time for your questions. Whether you're deep in development or managing your realm day to day, this is a great opportunity to collaborate with fellow Quickbase builders in the Philly area. 📍 Location: Bond Collective - Center City1 Penn Center, 1617 John
Hi all:My non-profit in Detroit is looking to develop a job description to hire an individual to manage our Quickbase work. I am looking for sample job descriptions that we could build off of. We are specifically looking to develop a job description for an individual who my not have QB experience but has low code or just good experience with technical problem solving. Specifically a more junior level person. Is anyone willing to reply and share their organizational job descriptions?
Is there any way to programmatically interact with a field type Address when lat/long (coordinates) option is selected on the form? Neither Pipelines nor Form Rules seem to be able to cope with this. I believe I can populate these Address subfields programmatically but that's not an option in this case because street addresses are not applicable (there are none on this large site).In Pipelines, Latitude / Longitude fields do not appear in the schema and you cannot directly update the Address primary field. You must choose a subfield, none of which are lat/long.Form Rules is even worse in that it doesn't recognize any other valid fields with which to change the Address field value to. Presumably the only valid option would be some other address field which is not very useful.The goal is to not have users input lat/long but instead look those values up after a user has selected a friendly name (like a building number).Screenshot: https://i.imgur.com/hA1WASz.png
Attempting to build a link that would navigate users to a google map page. What am I doing wrong? Using the logic below results in an "http://<a href=" ahead of the url. i.e. http://<a href=http://:www.google.com/maps/search/?api=1&query=> Street 1 City State Zip</a>var text Words = ([Account - Venue Address: Street 1]&" "&[Account - Venue Address: City]&" "&[Account - Venue Address: State/Region]&" "&[Account - Venue Address: Postal Code]);var text URL = ("http://:www.google.com/maps/search/?api=1&query="); "<a href=" & $URL & ">" & $Words & "</a>" ------------------------------Ryan Parr------------------------------
Hello all!We have a Wiki app that tracks all pipelines in our realm (along with other items regarding our apps). The process is for whomever created the pipeline to create a new record to enter details about the pipeline (pipelineID, name, description, etc.). The problem is that not all our builders remember this process. Someone on my team asked if we could create a pipeline that enters at least a placeholder record in the Wiki app with some details of the pipeline. I thought it was a great out of box idea but don't know if it's possible. Would love any ideas/insight any of you can provide.
Good day everyone! This is likely convoluted. I haven't been able to figure a way to actually do this and I feel like I'm missing something obvious. I have a couple of tables that will hold some information.The tables involved: Asset TableAffected AssetTicket Asset The asset table hosts the information of the Asset itself (Serial Number etc). We create a new record in the Affected Asset table based off the information in the Asset table that attaches ticket information to it. I'm trying to add information to the affected Asset Table that when we create that record, it will record what's wrong with that asset and why we are getting it back.What I want to do is. When we go to add the Asset onto an OOW Ticket, that it populates the Ticket Asset Report with the Latest "laptop Issue" field based off the Assets Serial Number (unique identifier). I am unsure how to grab the most up to date. I likely skipped a step by cutting out the Asset Table i
Is there a way to open the record in a larger pop-up or to open the record is full view?I have a report on the main from of child records but when you click view or edit it opens in a pop-up and it's just to small.Thanks
I have a checklist which is 20 or so checkbox questions across 5 different Sections, to work through a field inspection. I am looking to provide a visual representation of when Section 1s 5 check boxes are not clicked it would show red/ not started, when 1 or more but less than the 5 are checked it would show yellow/ in-progress, and when all 5 check boxes are clicked it would show green/ complete. And I would do this foreach Section. What is the best way to complete this and be able to show it in a Form and on a Report view? Thanks.
Hello,When I click the button "Submit all Sales offices" it is giving me this prompt tbat is showing in the picture this is the formula - url codevar text markCompleted = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&apptoken=MyAppToken" & "&rid=" & URLEncode([Record ID#]) & "&_fid_921=1" & "&rdr="&URLEncode(URLRoot() & "db/" & Dbid() & "?a=er&dfid=34&rid=" & ToText([Record ID#]) & "&page=16"); $markCompletedthis form is on edit mode, The button will be use to submit all the sales office that are selected(Checkbox) in the embedded report in the form 34 where this button lives. after the selection the use will click the button and submit all the sales selected office. the next step after that is product page where will do a similar process
A quick note to say thank you to all who attended the QB Leadership AMA today! Not just for attending but for engaging and being honest and transparent in your comments and questions. The more feedback we have the better we can become. The entire executive leadership team believes feedback is a gift and we thank you for sharing. Although we'll never be able to action all the feedback, we are always ready to listen and provide and honest response and action what we can. It's an exciting time at Quickbase as we continue to transform; continuing to put you, the customer, at the center of everything we do, evolving of our products to solve real business problems and setting our sights on ensuring you're deriving value from your investment.Your partnership is what has made Quickbase stronger over the last 20+ years. Without you, we don't exist. Thank you!
I have three tables, Audits>Questions>NonconformitiesAudits have multiple questionsQuestions have multiple nonconformitiesI'd like to display the # of nonconformities related to the audit on the audit table without creating a new relationship between audits and nonconformities. I've got this accomplished currently just doing a summary field from nonconformities to questions and then questions to audits but had to disable drill down since clicking it only took you to the 'parent' question table. Is there a rich text formula that could show # of nonconformities related to an audit with drill down that would go to the 'child' nonconformities table?
I have recently closed my business and opened a new one with a new domain name. I already updated my company name in the admin settings, but I have one concern - before I change my email domain... I need to know will changing the email domain in Quickbase break any of my pipelines or my imports?My application relies heavily on imports, which I know from experience will break when I make a new copy of the app. I just need to know before I start, because if it does break I have a lot of work to do before I can do anything else.Thanks!
Has anyone had success with the CopyText.html code page?I have implemented it an application per instructions from the Code Pages app and when I click on the URL button, a new page opens with only this text on it: "This page will close momentarily."This is the URL formula: URLRoot() & "db/" & AppID() & "?a=dbpage&pageID=27&copyText=" & URLEncode([Notes])This is the code page:<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> </head> <body> This page will close momentarily. <script> let urlParams = new URLSearchParams(window.location.search); let copyText = urlParams.get('copyText'); navigator.clipboard.writeText(copyText).then(function() { setTimeout(function () { window.close();} , 250) }) </script> </body> </html> <!-- These code samples are provided "AS IS" without any w
My table has a Latest Record checkbox to identify the most recent entry among records with the same email address. That's the record that I would want updated to trigger a notification when the conditions are met by one ore more of the other records. I have a pipeline setup with On New Bulk Event as the trigger but the test run lead to the multiple record version of the notification being sent. Is there a way to only have the Add A Bulk Upsert Row done only if the record id for that row doesn't exist in the "bucket" already? If so, how do I do that?I figured I would try to see if I could get the pipeline to work before re-engineering my whole approach to avoid the multiple record version of the notification being sent. FYI - it's possible and likely that multiple records in the trigger array will have different email addresses, thus, multiple records would need to get the update to trigger separate notifications. Let me know if I need to provide more
Is it possible to dynamically change the title displayed on an add record form (e.g. "Add [single record name]")?In the attached screenshot I have a table called Activities, which has the display name Communications in my sidebar. I would like my primary add form to say "Add Communication" instead of "Add Activity" to match the display name.Of course I could change the table's "A single record is called..." setting, but I'd prefer not to do this for the same reason I'm using a different display name in the first place, i.e. a client requested the change and the app already has a lot of dependencies based on the original name I'd prefer not to have to worry about.I'll change the table name if I have to, but what I really want is to be able to change the text displayed on my add forms dynamically based on the use case.The same table also stores notes which are not associated with an actual communication, but still belong on the same table for simplicity's sake (tl;dr the two types of rec
I am trying to plot a Risk History line chart over time. I want the line to connect from the last known value to the current value, bridging the gap over dates where no record exists.The Setup:Table: Risk History (Child table)Fields: [Snapshot Date], [Risk Name], [Risk Score]Data Structure: The data is "Sparse." I only have a row for a specific date if a snapshot was taken for that specific Risk.Example: Risk A has rows for Jan 1 and Jan 5. Risk B has a row for Jan 3.The Problem: When I use a standard Line Chart, the X-axis includes "Jan 3" because Risk B has data there. However, because Risk A has no record for Jan 3, the chart forces Risk A’s value to 0 (or null), causing the line to plummet to the bottom and then shoot back up on Jan 5.What I’ve Tried:Filtering: I tried filtering the report to [Risk Score] != 0 or null. This didn't work, presumably because there is no record to filter; the chart engine is generating the "0" because the data is missing.Scatter Plot: I switched the ch
I am utilizing the OpenAsPopup class to open a small form as a popup window when a user clicks a button. Is there an attribute for OpenAsPopup (or any other technique for that matter) that will enable me to control the position of the popup window?Ideally the window should appear close to where the button was clicked. Barring this the middle of the screen would be preferable to the default, top-left position.
Quickbase Solution Consultant SamTrachy offers an Office Hours to anyone in The Qrew to join! This is a great resource even if you don't have a question and want to join and listen in. All questions are welcome! Beginner, Intermediate, Advanced, it doesn't matter. Whatever Quickbase question is on your mind, bring it to Office Hours and go over it with a Quickbase Pro. Sign up for as many Office Hours sessions as you like here!
Hello,I am kind of a new Admin, so please excuse me if I miss something simple.I have a role I created that should have full permission to add, delete, and edit records in a table. I am an Admin, so I can edit the field that is giving us problems. However, the person in that role cannot edit that same field. For this particular table I checked everything to give him full access, but he still cannot make changes to this field in any given record.Any Idea what I am missing. Is there a time frame thing I don't know about?
Does anyone know of a way, via either API or Pipelines themselves, to retrieve a list of Pipelines in a realm?I've built a table of implemented automations in my app, which documents the purpose, functionality, logic, etc. for various automations both within Quickbase and externally and was hoping I could scrape a list of existing pipelines to keep the table current.
I have two tables. The main table is DSO and the related table is activity.I'm trying to get a report grouped by the DSO Name and bring me back the record ID of the activity where the field Date Roster Reconciled is the greatest.I built a report and have the information like I want it but the link does not take me to the record of the activity.I created a summary field on the DSO table relationship to the activity table that gives me the max of the date field and the max of the record id. I also added the lookup on the activities table. It's just the link takes me to the DSSO record and not the Activity record.What am I doing wrong?
Good day! Is there a way to automatically send emails to all records that are 21 days past the [File Date] field? As far as I know, emails only get sent out when a record is modified or added. If it's not yet possible, I will highly appreciate any similar workarounds. Thanks in advance!------------------------------frnmj------------------------------
When bulk records are handled in a pipeline, are all of the applicable records updated simultaneously? Will they have the same modified date and time? I have notifications setup to be triggered when a date field is updated. I have a formula checkbox field used to identify the most recent record associated with an email address field value. The most recent record may not be the one that gets updated along with other records with the same email address field value. I don't want the email notification being sent before other associated records are updated. I am looking at using Bulk Record steps to reduce the number of pipeline steps I am currently using as well as handle everythingmore efficiently. I just need to know if I would be safe having the date field updated on the most recent record with the other potential changes without worrying about the email being triggered before all applicable updates are made.Thank you, in advance for any input. Let me know if I need to provide a v
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.