Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello Construction Qrew! Hope all is well. I wanted to give you a few updates and announcements regarding the construction Qrew that you’ll want to take note of for November 2024: On 10/22, the Construction Qrew Meet Up agenda focused on a post Empower Pro discussion. We shared on how to implement features, tools, and answered questions regarding updates announced at Empower Pro. Rob Salaj was there to ask how Construction Qrew members could use secure links. Some folks shared they could use secure links to share forms in the field while also sharing reports to their vendor partners and more. The added layer of security is a welcome addition to sharing information with confidence. Kaity Strong, Solutions Consultant, was on-hand to show folks how to enable secure links and helped to review and answer questions from the audience. In the end, most customers enjoyed Empower Pro and are still digesting all the information shared during this time. If you missed Empower Pro, you can ch
Just making sure I am not missing something:On new forms, when you use the embedded 'New Child' button (its an option to add to the toolbar in a report link), it opens up the cool pop up dialogue box to enter your child. I see no way of doing a 'save and new' when using this new pop up. Am I missing something, or did they remove that option?
Hi, Maybe I'm missing something, but I just ran into an error with the new forms and am baffled as to how we are about 7 months into the new forms and this error exists. I've setup a very basic parent-child relationship. When I go to add children records from the parent, it is incapable of chain-adding records (i.e. Save + New). When I try to do so, it only relates the first child to the parent record. All subsequent records are parentless. The only way around this is to Save & Close and add from the parent directly.. Then on top of this, when I'm done adding children and go to save the parent record, it redirects me to add another child record (???). I'm really hoping this is my own incomptence, but it's rather frustrating to find this out many hours into a project. Thanks for any guidance/help!------------------------------Curtis Middleton------------------------------
Wondering if anyone has done the work to convert the Quickbase Audit Log Timestamp to local time? I export the logs via CSV and then am working towards a process to convert the "2024-10-28T15:53:25.956Z" timestamp to PST. I'm seeing it as a multistep process involving text to columns and then math. If you have a simpler solution, I would appreciate hearing how its done. Thanks,
I'm trying to use the new feature that allows @ mentions in rich text fields, and have set up a custom notification to email users when they've been mentioned. I'm trying to get the contents of the rich text field containing the mention to display in the email notification. I selected the field using the 'add elements' dropdown in the 'compose email' section. How do I set up the template so that the contents of the field will be displayed in the body of the email without all the html tags?
Hi,Is there anyone facing issues with missing data or records on Quick Base lately? I am having this issue. Can anyone help me in understanding why this is happening?Thank YouNikki
I'm trying to optimize my pipeline and I'm having trouble deciding on the best way. I have 2 apps in the same realm. App "A" has approx. 30k records, and app "B" has approx. 130k records. When a new record is created in the Clients table of App A, I'm searching the Clients table in App B to make sure it doesn't already exist using the unique identifier of Login ID. My problem is, the pipeline takes SO long searching through 130,000 records to see if the Login ID already exists in App B. If the Login ID does not already exist, I'm having the pipeline create a new client record, and if it does exist, do nothing.I know this isn't best practice and I'm sure there is a Jinja reference that I can use to speed this up but I'm a rookie when it comes to jinja. Can anyone offer assistance? Thanks in advance!
Hello,I am trying to create a report that tracks each contact attempt by week.Right now, I have a report that will track the users calls based on a Contact Date field but if this field is updated, the original Contact Date information is removed from the report, and the record is adjusted based on the most recent Contact Date. I have tried to create an additional field named Contact Date #2 to track both times the candidate was reached out to, but the reports are only able to use one field to summarize the data. I included a screenshot of the report. In the week of 10/13, the 1 candidate was also contacted on the week of 10/20, but their information only appears in the week of 10/13.Is there a way to connect two reports? Or is there an easier way to track each time someone attempted to contact a candidate?
Anyone come up with a simple way to calculate a median of a field. I am thinking of using the "new" query formulas with GetRecords, etc. Anyone solve this already?------------------------------Melissa Freel------------------------------
Approximately 5-minute readIn the ever-evolving landscape of data management, Quickbase's Admin Console Connected (ACC) tables (known also as Sync tables) stand out as a pivotal tool for administrators. These tables are more than just a feature - they represent a methodology for streamlined data governance and management.This blog post delves into the strategic setup and utilization of ACC tables, guiding you through a journey of efficient administration and governance of your Quickbase realm.The Governance Core AppsTo establish a comprehensive governance framework, realm admins need to create three core applications. These three apps lay a solid foundation, which allows for easy expansion and subsequent modifications. For in-depth instructions, go to the Exchange and search for "GCA Instructions". This app will guide you through the build below:Step 1 - Create an app called Admin Console Sync Hub: This is the centralized location for all ACC tables and is crucial for wareh
When a Quickbase server gets a large UPSERT via API, how does the server perform the process/calculation to locate the correct Record ID# and determine whether to update/add the record in the table?Does the Quickbase system have a preference for the order of records? I'm thinking about what uses more processing in terms of an UPSERT. When I API a bulk UPSERT to a QB table leveraging a UNIQUE field (not the Record ID#) what is the preferred sort order of the records UPSERTED?I can sort using the UNIQUE field.I can sort using Record ID#.I can not sort.Wonder if anyone at Quickbase has performed this type of test and measured the performance?
Really amazing to have the ability to natively create PDF's in Quickbase now but I have a question to see if anyone knows how to take this a step further.We currently have a document builder code page that runs via a URL button (See attached image for code) and extracts a number of key fields from a Quickbase record to create a PDF and it then attaches the PDF to a field. These PDF's are old and contain information that's no longer relevant in the footer, which is why the new PDF creator is so great ,we can now refresh documents.The question is, how or IF, its possible to use the new native document generator process to automatically attach the new PDF that gets created to the same field where the old one used to be attached to. This is to avoid the need to manually download and attach the newly generated PDF.I appreciate this is still very new to everyone, I've also not asked Quickbase support on this, I thought I'd try speak to the Qrew for the very first time and see if anyone
Hi all,I have a very large table that I want to clean up, and I'm not sure how to automatically export all these file attachments into SharePoint. Any pointers would be appreciated! Jay
Have an app where faculty submit leave requests. Then seven admins must approve request before it is ultimately approved. I created a pipeline that when a faculty member submits a leave request, new approver records are created for each admin role with a status of "Pending". Wondering if this is possible:I want to create a formula-url field in Leave Requests table that is a link to a "Pending" approver record, in Approver Decisions table, based on the related leave request and that the username is same as Approver username. I started this idea by finding this formula via a google search but I'm stumped as to how to move forward: URLRoot() & "db/" & [_DBID_APPROVERS] & "?a=er&rid=" & [Record ID#].Any help would be appreciated.Kim
Good afternoon, Still learning QB and I need help with conditional formatting. I have a list of airport codes and each airport has one hotel or multiple hotels related to that city. When an user selects the airport they want too, I want the hotel field to provide all the hotels related that city. I have been struggling with issue for a while now. Thank you for all the help.
Good morning, Happy Thursday. The ask is to change the Quickbase Gantt Template App date format. The Gantt Template App can be found on the Exchange as a Quickbase alternative to Microsoft Project. The Quickbase Gantt Plugin has great out of the box functionality, but I can't figure out where to change the date format.If anyone has any experience using this Project Plan type plugin and has figured out how to change/customize settings (such as Date Formats) we would appreciate your insight. Thanks in advance,
I want to create a report using two tables whcih are linked. Do I create a report table where I put all the fields I want into the reports table then I can generate a report from this table? Thanks
For my project, I ideally would like to create a pie chart. With what I read online I can’t do that with the variables I have now, so I created a table with two columns. First column, called names, consists of a full name, while the second column, called changes, consists of multiple variables that are separated by a semicolon. For the changes column, I need to separate each variable into a row of its own but still have it associated with the name. What can I do to achieve this?The end goal is it use this table to see what names are associated with the changes column a distinct number of times. Like Name McName is associated with "No Changes" 37 times. I also created summary report with the same variables but I'm not sure how to proceed with that either.I'm open to suggestions! Thank you!
Good Afternoon,I created a basic inventory system app that allows me to log a few fields (name, part #, location, etc.). One of these fields is a file attachment field for uploading a picture of the item.I am trying to download the report (197 records each with a photo) but I am unable to download or print the report since it is such a large file (1,686,015 KB). Is there a way to use some field to compress the image so that my report is not so large when trying to download as a PDF or print?Thank you,
Hey!I could use some help updating my badges within the community. I definitely have earned badges, and have been waiting for them to be updated here, but to no avail. Is there an admin available to reach out and help resolve this?Thanks!Ender
I am attempting to streamline (by removing manual actions) our part tracking process for newly machined parts and am looking for a way to add a "Save and New" button to the body of the form that preforms the same way as the built in Save and New button.Each part after machining is etched with a QR code that contains the relevant data for the part. Current setup below allows the user to click in the Part 3D Scan box, scan the QR code on the part at which time the data inputted and parsed into the correct boxes then it auto tabs to the Save and New button and pushes enter.My issue lies with the functionality of the button. Using the code I found in this forum I can "Save and Edit" however I can not figure out how to modify the code in order for it to open a new record for entry.var text url = URLRoot() & "db/" & Dbid() & "?a=er&rid=%%rid%%";var text link = "<a href='" & $url & "' data-replaceRid='true' style='font-size: 11pt;margin-left: 5px; margin
I had a report in my previous app that I wanted to rebuild.I am having difficulty. I want the conditions to be all Any Field or field"and field"and" field"and" field "and" fieldbut I am having trouble getting the and
I have top tier QB enterprise access. I need a way to build and run a script within QB and have it systematically run it on a schedule. what I want to do can't be done with the default pipeline builder.I have a table that has a ticket number, open date, resolution date and a check box called Hard Down. The objective is to review each ticket ticket and determine if it was open at 7:30 am each day and has the Hard Down box checked. For every day the ticket was open at 7:30 am, we will insert the ticket number and the date it was open into a separate table. For example, if a ticket was opened on 10/3/2024 at 09:00 am and resolved on 10/6/2024 at 06:45 am. There would be 2 rows added to the Hard Down Trends table for dates (Ex. INC00000001234567 10/04/2024 and INC00000001234567 10/05/2024). We would not include 10/3 because it was created after 7:30 am. We would also not include 10/6 because it was resolved before 7:30 am.With all of that sai
I have Table A with all of the delay records. I have Table B that counts them by airports using a summary field in a table relationship. I have Table C that I want to grab the top five from Table B using maximum summary fields in a table relationship with Table B.Here is Table B. When I add a summary field in the relationship with Table C, I put in maximum and it returns nothing. Below is what I'm using for the summary field. Both of the fields are numeric.Does anyone have any idea why this might be happening? I followed a Kirk Trachy YouTube video explaining how to do this and followed the direction exact to what he showed in the video.
I've been able to successfully extract the surname of a user account using this formula: UserToName([Record Owner], "FF")The problem is that the user account was created as first name Richard and the contact record that corresponds to that user was set up as "Rick", so I'm not going to be able to make a match.My goal was to compare the record owner to a snapped value that occurs in a previous process, but when I tried changing the actual user account to Rick to circumvent the fact that the snapped field it is comparing to will not change, but apparently once the user name is set up it doesn't change.Is it possible that the user account will update after some period of time? if not, I'm open to other suggestions/ideas, and I thank you in advance for your input.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.