Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello, I am relatively new to quickbase and am trying to learn the ropes. I have a form that my team uses for reviewing customer service calls. I am trying to make a bar graph that shows the frequency of each error category so that we can see what areas need training. I currently have a multi select text box that will allow you to select what errors occurred on a given call. However when trying to turn this data into a bar graph the error categories have been merge to say Greeting; Account Verification. Is there a way to split these up so I can see how many errors are made in each category?------------------------------Evan Holler------------------------------
Hi All, I'm trying to parse a specific value from the JSON. I'm trying to get the value of the "display_value" where the object's GID is equal to "1205664665921946". I need to get it based on the GID field value because the order of the custom_field objects can change. JSON sample (yellow number is what I need to parse) { "data": { "gid": "1205719503165790", "custom_fields": [ { "gid": "1202162434601082", "name": "Request Priority", "display_value": "Low" }, { "gid": "1202169451444424", "name": "Associated Product", "display_value": "C" }, { "gid": "1205664665921946", "name": "Primary URL", "display_
Hey QuickBase Community, I have a Duration Formula field that is looking at the difference between "today()" and the finish date of a given task record. the field is designed to tell me if the record is past due based on the finish date. the issue is it gives me a negative number of days for the task that are still yet to be completed aka not overdue yet. can you help me format this duration formula so that it only shows a positive # of days when the task is officially overdue? If([Status]="Overdue",Today() - [Finish Date],If([Status]="Not Started",Today() - [Finish Date],If([Status]="In Process",Today() - [Finish Date],null))) ------------------------------Jack Woods | Low Code 4 Lyfe------------------------------
Hi All, Please can you advise how to freeze the first column of the report in Quickbase, so when scrolling to the right we still can see the location name? Thank you.------------------------------Iryna Pylypenko------------------------------
I am trying to build a query that ranks the weights from high to low in a 1-X format. It is working, except when two records have the same weight it ranks them with the same number. Essentially, I want it to uniquely rank them. Is this possible in Quickbase? Current Formula: var text QUERY = "{355.GTE.'" & [Weight] & "'}AND{17.XEX.'Cancelled'}AND{17.XEX.'Complete'}AND{17.XEX.'Hold'}AND{9.XEX.'Research'}"; If([State]="Complete",null,If([State]="Cancelled",null,If([State]="Hold",null,If([Type of Contract]="Research",null, Size(GetRecords($QUERY))))))------------------------------Elizabeth Schlagel------------------------------
Hello, I'm attempting to create a field within my records that shows POTENTIAL duplicates. Some of our records are older and we don't necessarily want to completely merge records, so in order to help combat this, I want a list of the record IDs that share the same Phone Number. We can accomplish this via this formula:ToText( GetFieldValues( GetRecords("{'17'.EX.'"&[OFFICE_PHONE_NO]&"'}"),3)) We then want to take the record IDs that generates and create a link to each record ID, and this part has me a bit stumped. Has anyone had any experience with something similar?------------------------------Marc Ferro------------------------------
When viewing the "Usage" tab in the Field settings, we typically get a nice view to see where the field is used throughout the app, such as other dependent Fields like formulas, Forms, Form Rules and Reports. These references are linked too, for quick navigation. We also sometimes see a "Webhook" reference that is prefixed with "CLOUDPIPES_" followed by a series of numbers such as CLOUDPIPES_1234567890999999. When following the link, we get a Quickbase Warning stating "This Webhook cannot be opened." I believe Cloudpipes was acquired by Quickbase several years ago and perhaps powers Pipelines under the hood. Anyway, is there a way to cross-reference a given Cloudpipes Webhook ID from the Field's Usage tab (e.g. CLOUDPIPES_1234567890999999) to a Pipeline ID or Pipeline name? It's cumbersome and error prone to hunt through our many Pipelines to find if/when a given field is used! This question is similar to other forum posts, but a bit different.------------------------------B
Is there any way to share Pipelines between users so that multiple users can view/edit them? We have several pipelines that are used to provide functionality in our app and currently it's difficult to manage since only the user that created the Pipeline can maintain it.------------------------------Sean Carpenter------------------------------
I'd like to get your input on an automated approach for importing CSV data into Quick Base. I receive CSV files via Gmail, and these files contain both customer and loan-related information. In some cases, a single customer may have multiple loans. My objective is to automatically create separate tables for customers and loans in Quick Base. While I'm aware of the manual process, which involves downloading the CSV, splitting it into two separate files (one for customer data and another for loans), and then uploading these into Quick Base, I'm wondering if you have any suggestions or ideas for automating this process. Your insights would be greatly appreciated. Thank you for your assistance.------------------------------Ramesh SinghRamesh------------------------------
We have ~50 pipelines under a user's account. That user is leaving the company and their account will be disabled. The question is, how will this impact the pipelines? They are set up to be authenticated with tokens and not the account. All I have found on the forums were about automations and needing to update the owner for those. I don't know if that applies to pipelines as well. I'm a realm admin so I can see the pipelines in her account, in fact I set most of them up. Is there a way to transfer Pipeline ownership like automations had? Do we need to export them and import to another account, or am I missing another way to keep them running?------------------------------Robert Wressell------------------------------
I am working to create multiple Formula URL buttons that help with workflows through saving, editing, redirecting, etc. I've found scattered references that can be used with QB records/navigation, but I can't seem to find some sort of central reference for how to build/read URL strings. For instance: URLRoot() & "db/" & [_DBID_Projects] & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=" & [App Token] & "&_fid_266=" & true & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl()) I know what the URL accomplishes within my app, and can see how most of that is reflected in the string. But using that information to create new URL strings that do different things has been a struggle for me. https://helpv2.quickbase.com/hc/en-us/articles/4570366896532 only helps a little with using ?z= and some API functions https://helpv2.quickbase.com/hc/en-us/articles/4570286674196-Formula-queries- help
📣This discussion thread will be used for the purposes of sharing feedback and asking questions relating to the FastField/Quickbase webinar today.📣 Registration link above for those of you who haven't had a chance to register yet! See you there!------------------------------Ben Simon bsimon@quickbase.comDo you have Feedback on how to make Qrew Discussions a better experience? Let's chat!https://calendly.com/bsimon-2------------------------------
From a record form (record A) -- I have a Button on a related view (related child table) ---that when clicked -- a pipeline is triggered and a record is updated within a different app.....the record that is updated - is a Parent to "record A" -- all works well -- except -- I have to refresh my browser to see the updates --- for my "record A" -- is there a "Refresh" step within Pipelines? I would like to have the final step within my pipeline -- to refresh "record A".Thanks------------------------------Brad Elmore------------------------------
Hi there are some emails that do complete and email notification send because the email address is outdated. I need a list/report of these emails that are not sending in the pipeline. ------------------------------NOEL HODGES------------------------------
What I need is the date to automatically lock in on the signature date. So say they sign today, I need the date field to automatically populate 10/10/2023 Is there a formula that will do this? What I came up with was this but I don't think it would work. If([Signature] <> "", Today(), null) Thank you! ------------------------------Colin Fox------------------------------
I may be overthinking thhis, so I could use some help! I am trying to create an AR aging report to calculate a running 0-30, 31-60, 61-90 and 90+. I need to create these fields, and then break up the ARtotals by customers for each AR date range above. I have a "Days in AR (Age)" field with this formula: ToDays(Today()-[Date of Service]) And then I created a field "AR Age group" formula: If([Days in AR (Age)] < 31, "0-30 days",If([Days in AR (Age)] > 30 and [Days in AR (Age)] < 61, "31-60 days",If([Days in AR (Age)] > 60 and [Days in AR (Age)] < 91, "61-90 days",If([Days in AR (Age)] > 90, "90+ days")))) These both work great. I guess I am struggling with what I need my end result to look like. How do I extract all AR for Company A that is 0-30 days, 31-60 days etc? And then have this displayed in a report? ------------------------------Kelly Lyons------------------------------
I am creating a new form for our support tickets and I would like to include the ticket number field multiple times but it will not let me. I thought a workaround for this would be to embed the information in rich text, but this is not working. Any idea how to do this or a different workaround? Thank you!------------------------------Krista Sibery------------------------------
Hi All, Please can you confirm if there is a possibility to change the scale for 0 to 5 instead of having it from 1 to 6? Thank you.------------------------------Iryna Pylypenko------------------------------
Wondering if there is any way to open up a link to a local directory on my internal network without enabling special Browser settings or extensions. I thought that this was not possible, but in talking to another user we did find it possible to paste a link into a browser and have it display a local directory. https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=0dd70d9c-3701-455d-90bb-12987a867b76&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------
Have a pipeline that sends a gmail. The body is a field from my table. I can read that field utf-8 encoded in quickbase, but when the email is sent it changes the characters to ascii Using the gmail channel, any known workarround? Thanks------------------------------eduardo valdes------------------------------
Has anyone has any sucsess connecting to gmail for a pipeline ? Every time I attempt to connect I get an error message saying google has blocked QB's access. I have gone into my google account and changed the access to less secure, and there is no option anymore to connect an app... Any help appreciated.------------------------------damien page------------------------------
Hello, I'm needing to filter a completed Docusign document by the Record ID#, in order to match it back to a QB record. I have a Powerform in Docusign which I've added the QB Record ID# into the URL, which is sent via an email from a button on a Clients record. When they follow the Powerform link, the Record ID# is displayed on the document in a custom field. When the document is signed and completed, I have a Pipeline which uploads it to the Client Record in QB. I was using the email address to match the QB record with the Docusign document, but I have clients with the same email address, since the email is for the Guardian, who can have more than 1 client. This is why I'm trying to use the Record ID# to match it back to the correct client record. Here's how I have it filtering by email address: How can I get that custom field with the Record ID# to show in the pipeline filter so I can match it back to the correct Client? I know I need
I have 3 different fields that I need to incorporate into a formula to determine if the record qualifies to be on a variance report. # of Reviews for the Month - must be 5 or more Score - Prior Month - must not be null Score - Current Month - must not be null Nothing I try seems to work for this scenario. I'd appreciate any advise. ------------------------------Thanks,Sheila Allas------------------------------
Hi There,I am simply wondering what steps are needed in a pipeline to clear empty records from a child table. Thanks in advance!------------------------------Colin Fox------------------------------
We are getting ready to start a new project with a new client and they have provided links to Sandbox environments they created for each App we will be working with. However, those links expire and the next time we try to use them we can log into their system, but nothing shows in the "My Apps" section. With previous clients where I worked with a Sandbox, I would log into their live environment and then switch over to the Sandbox environment to work. Base on that, does a user need to be added to the Live and the Sandbox version to be able to have continuous access? I believe I even tried saving the Sandboxes in my bookmarks but that didn't work either.------------------------------Chris Swirtz------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.