Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
This is the output of a running pipeline I am testing. I have a search looking for records where a check box is checked. There are 87K records in this table. Am I doing this right or is this going to tell me it found 100 records where the check box is not checked? 8700 times... How do I filter the logs? ------------------------------Jim Harrisontransparency = knowledge + understanding : The Scrum Dudes------------------------------
I am looking to create 3 buttons at the bottom of a form:1. Clear Form Button - a button that when clicked will clear the form so the user can start over again without having to back out to the homepage and start a new record. The catch is that currently the from starts with 2 fields auto populated and ideally those would remain populated even though the rest were cleared. I have them set to read only if that helps. 2. Save and Finish Later Button - a button that will save the user's progress and returns the user to their homepage.3. Submit Button - a button that checks a checkbox, saves the record, and then returns the user to their home page.4. Cancel Button - I suppose while I am asking, a button that cancels he record and redirects the user back to their homepage would be nice as well.------------------------------Chris Swirtz------------------------------
Hello! I'm looking for help with the proper formula syntax to grab a string of numbers from a text field. The string I want will also be after the word "Code" and before the word "Order".Code: 123456789Order: XXXXXXXXThanks!------------------------------Raymond Sakar------------------------------
Is it mid-May already? 2022 is flying by and I’m currently digesting all the notes I took at my very first Empower conference at Quickbase. One of the best things about attending virtual conferences is that attendees can decide how they spend their time without distractions. The goal I set for myself was to go to as many Pipelines sessions as I could to pick up tips that will help with passing the Pipelines certification exam. Since I decided that I will take the exam at the end of June, this was my chance to connect with the exam authors, listen to Pipelines product managers, learn from other session attendees, and keenly observe how our expert trainers approach educating users on setting up and troubleshooting Pipelines. Here's how I made my experience at Empower 2022 Pipelines-focused Day 1 Monday, May 10th at 10:45 AM EST/7:45 AM PST: Keynote Address Started out my day attending the keynote by CEO, Ed Jennings. He dropped hints of new features and enhancements to Pipelines
I have a cx that needs an interpreter for mandarin/Chinese------------------------------Delisa Adams------------------------------
I am trying to pull data from another table that contains a list of keywords up to a table that has a Description field that may contain one, multiple, or none of the keywords. My end goal is pasted below, essentially I want to query GetFieldValues for specific fields on table 1 for every keyword contained in any given record in table 2.Is there a way to arrange a GetFieldValues(GetRecords()) formula to achieve the columns highlighted in Yellow?------------------------------Courtney Rapp------------------------------
I have an app with a Companies Table and a Offices Table related by a one Company to many Offices relationship. When a Company wants to create a new Office request, there is a few types of request to choose from (New, Renewal, Relocation), based on which choice is selected, certain info is shown/hidden on the Office record.Is it possible to create a button on the Company table that when clicked will create a new record in the Office table utilizing the specific type of request the user wants?For instance, if ABC Company wants to Renew a current office space, they would be able to click on a "Renew" Button and it will create a New Office record where "Renew" is already selected in the Type: dropdown so the correct information is already shown/hidden.Purpose being to save the user the step of having to click the New Office button and then selecting the type of Request from the dropdown.------------------------------Chris Swirtz------------------------------
I have an app with a Companies Table and an Offices Table which have a 1 Company can have many Offices relationship. Is it possible to set it up so that when a User from one of the Companies logs into the system, they can create a new Office linked to their Company without having to find their Company first and click the Add Office button?For instance, if Jon Smith from ABC Company logs in (ABC Company being a Company listed in the Companies Table), QuickBase doesn't recognize that Jon is affiliated with ABC company based on the email or something like that correct? I would need to somehow link Jon Smith to that ABC Company Record Right?------------------------------Chris Swirtz------------------------------
I have what I think is a fairly simple question, but would like an opinion as to what the best approach is to take to accomplish something. I have two apps where I would like to copy table data from one app to another. I would like to copy a "zip codes" table from App B into App A and have a Pipeline keep these tables synced. Keep in mind, this zip code table is not changed very often, maybe a few times a week. About 90 users use App A throughout the day but there is a downtime from 8 PM to about 4 AM each night/morning where few, if any, users are in the system. The zip codes table contains 33,000+ records. Should I have the Pipeline copy data as things change, or trigger on change, or should I run a nightly update where this happens automatically in order to prevent any slowdown in App A as things sync? What's the most efficient approach?------------------------------AR------------------------------
Hello colleagues,I have this problem, I have a ledger that has all the accounts and subaccounts of the company, in the attached table I made a relation of Account and Subaccount and in another table I make an accounting so that the value is related in the main table.The dilemma I have is that I need the values of the subaccounts to be added in the main account, is there any way to do it?------------------------------Jaime Fonseca------------------------------
Hello, can someone help me with the formula for getting the current date/time and set it as value on field with a click of a button? Basically, I'm trying to create a time in/out table where it will have two buttons and two fields. Clicking the Time In button populates the Time Int field with the current date/time, same thing for the Time Out button.------------------------------frnmj------------------------------
Hi all,Please accept my apologies as this is probably posted somewhere but I find that if you don't know how to explain it in QB speak, you can't find your solutions in the community site. This is one of those cases.I have an app where "Projects" is a table. I connect Projects to Notes, Intakes, Deliverables and other tables, Projects being the main record for everything.Let's say I'm adding a Note in the Notes table and because of the relationship with the Projects Table, I can select the project from the Project field's record picker. I have the picker showing the Project Name and the Project Year. To help my team with reducing confusion, I want to only show Projects in the record picker with a 2022 project year. Currently, it shows everything and we use the same project names each year, which is why the project year field is important.I thought that maybe I could do a custom rule but am lost at this point how to accomplish what I need to do.-------
I'm not sure if this is an easy thing I am just forgetting, but I want to have a two tabbed section in the middle of my form (vertically), and have a section beneath them with status and such that displays regardless of tab choice. Is this possible?------------------------------Davis Ward------------------------------
There are many posts here about using &ifv=1 at then end of a report URL in order to render the report solely, without all the other elements of QB (object ribbon, reports, etc.).This has many uses, including a way to get around the cap on the number of report widgets you can embed in a page.As of over the weekend, these have stopped rendering in our applications - the embedded reports just look blank on these pages. Does anyone know an alternative approach? Thanks!------------------------------Lucas Buxman------------------------------
I have a use case where I want to increment a counter field on a parent record (Phase Code) when a child record (Estimate-Phase) is modified/updated via a Webhook on the child table.HTTP method is POSTMessage format is XMLMessage header is QUICKBASE-ACTION API_EditRecordSo far I have the following for my Message body:<qdbapi><udata>Estimate-Phase Trigger Counter</udata> <usertoken>user_token_goes_here</usertoken><apptoken>app_token_goes_here</apptoken><rid>[Related Phase Code]</rid><field fid="676">[Estimate-Phase Trigger Counter + 1]</field></qdbapi>Am I formatting the field references correctly?------------------------------Jon FroderbergPRIME DeveloperHarder Mechanical Contractorshttps://www.harder.comPortland, OR801.946.0576------------------------------
Hello,I am trying to build a code page that would allow me to display some plots from Google Charts in which I feed some data from Quickbase. The idea is to then display the page in a form as iframe.I am really a beginner for what concerns code pages, so I would need some help.The following is one of the html pages where I would want to plug in my data. <html> <head> <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script> <script type="text/javascript"> google.charts.load('current', {'packages':['corechart']}); google.charts.setOnLoadCallback(drawChart); function drawChart() { var data = google.visualization.arrayToDataTable([ ['Year', 'Sales', 'Expenses'], ['2004', 1000, 400], &nbs
Hi all:Probably a simple question, but I have a notification for a table that I have put %recLink% in the notification. Works fine but it links to the DEFAULT form for that table. I want it to use a different form that I have developed for the table as the notification is set for a specific change that is made with the "NON-DEFAULT" form. How do I modify %recLink% or what would be the html that I would need to write out in my notification to have it pick the correct form to display the record?Thanks!Melissa------------------------------Melissa Freel------------------------------
If you want to add a bit of separation to your form I stumbled onto this. Maybe it's published but this works.See attached videoSo you have "TABS" and "Text" for form formatting.Well, let's say you want to delineate an area in a form by putting a box around it.Editing Form:1: (first "text" element.) <table style="width:100%;border:1px solid black">2: (last "text" element.) </table>You can encompass many fields on your form by putting the </table> further down.------------------------------Douglas Folk------------------------------
I've spent better part of last 1 hour to figure, so posting this for others. Thank you @Mark Shnier @Quick Base Junkie@ @Quick Base Junkie for posting numerous examples before me. I've a table containing my template task with sequence in order belowTaskName | Task SequenceTask A | 1Task B | 2Task C | 3Task D | 4Task E | 5 Challenge : When I copy these template task to Project task , I want predecessors to be define automatically via pipelinesSolution After you've created a pipeline to copy template task to project task table , use update record to define predecessor field (AboveTask) here to{% if c.task_sequence|int >1 %} {{c.id|int-1}} {% endif %} ------------------------------Prashant Maheshwari------------------------------
I have a support case regarding a pipeline issue that was opened on March 24th and is still unresolved. The person assigned to this case was not able to resolve the previous issue assigned to her and I have no confidence she will handle this one any better. This person does not respond to requests for updates and does not follow through on commitments she makes.@Evan Martinez, Who can I contact to get this issue escalated and resolved? As a follow up, how can I prevent future support cases from being assigned to this person?------------------------------Paul Peterson------------------------------
I'm a little puzzled with Pipelines' On New Event trigger. I see that there is a trigger option for On Add Record, On Modify Record and On Delete Record. They can all be set to trigger on the same On New Event step. What I don't get here is how do I follow up on each event in the step that follows this initial trigger? What I mean is, how do I differentiate whether I'm going to Create Record next, if the initial trigger is On Add Record. Or how do I write a step to follow thereafter to Delete Record if the trigger is On Delete Record? Lastly, how would I write an Update Record step if the initial trigger is On Modify Record?I don't see that there's a step by step way to identify what happened in the first trigger and tell the Pipeline to follow up and either Create, Update or Delete Record. It doesn't make sense to me why this option is grouped into the trigger for all three triggers when it seems like you can only use one trigger for the
I am getting an error message when I attempt to "Refresh schemas" - "Error refreshing schema. Something went wrong...". Yet, it doesn't point me to wear the problem is. Does anyone have any experience with this issue?------------------------------Scott Simcox------------------------------
I'm pulling in data from Salesforce that I may need to update or link back to the Salesforce record later, and it turns out the unique identifier in SF is a case-sensitive string. Any way we can create a unique field in Quick Base that is also case sensitive? Anyone figured out a work around option? Thanks!
Greetings,I have an app that has an invoice approval workflow. Invoices can be of 3 different types. For two of the three invoice types, approvers need to be able edit but not add or delete line items. In the case of the third type, approvers need to be able to add, edit, and delete line items. Invoice Items are on a table with a child relationship to the Invoice table. I'd like to be able to provide a grid edit report on the Invoice Approval Form that would allow access to the line item records. Is there a way to allow items to be deleted from the grid when the parent invoice is one type but prevent deleting for the other two types?Setting role-based Add/Delete/Edit table permissions seems only to apply to all records in the table. One is not able to allow only some records to be deleted based on type or other record specific data.I suppose I could use a custom data rule to prevent deletion in those cases but that will make for a clumsy user experience. Thanks in advance for your
I have been testing my pipelines that I have migrated from automations and they run much slower comparatively. A process that took maybe 5 seconds max to do in my automations, now takes 40 seconds to 2 minutes.I understand the Blaze engine was supposed to make pipelines faster, but the speed is still a far cry from the autos.I put in a support ticket to see if this was normal for the steps the pipelines were using. The response that I got, was that it was normal and that while pipelines are slower, they scale better than autos. Most of my pipelines are triggered by creation or update events. A common process in my app is when a user enters in data on a parent record which gets copied to a child record. The parent record that triggered the event is updated to have the input-text cleared from the field for future use.Here is why I did this.Most of the users in my company are looking at many different tabs, windows, Outlook, shared folders, and remote desktop screens while they are d
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.