Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I have a summary report that groups my Rolling AR using the field [A/R Age Group] using this 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 and [Days in AR (Age)] < 181, "91-180 days",If([Days in AR (Age)] > 180, "180+ days"))))) The issue I am having is the way it displays here: Obviously I do not want the 180+ days where it is, I want it at the at the end of the groups. Any ideas how I can achieve this? Maybe a Rich text field or something? Any help is greatly appreciated! Kelly ------------------------------Kelly Lyons------------------------------
Hi, I am curious to know if pipelines and related workflows of an app are also transferred to the new account when the app is transferred to another billing account. Thanks in advance! Regards ------------------------------shivani jain------------------------------
Hello, I was addressed with something I am not familiar with. My colleague would like to have the following: A red flag to appear when something is not uploaded. The breakdown: We have 1 table, that has all of our information on. It is called "Water Systems". And it has any and all information pertaining to that specific water system. We have another table called "Documents" and this table allows us to display documents on the "Water Systems" pages. I was asked to have a Red Flag displayed when a document is NOT uploaded to the water system, so we can see that we need to take action. We have paper reports we upload each month to the documents for each water system, sometimes, a month will get missed for a specific water system and we miss it too, because we manage so many water systems across the state. Is there a way to make a red flag when a document is not uploaded to the water system one month? ------------------------------Newman, Savi-------
Hello all, Please suggest me a solution about how to display a success message after submitting a quickbase form.------------------------------vikas pasula------------------------------
I have two fields Assigned to Primary and Assigned To Backup. I want to show a color for both (each different) on one record (calendar item). Is it possible?------------------------------Ann Developer)------------------------------
I am trying to build a formula that pulls a single record via a unique field, I want to pull just a single field regardless if there are several records that match my search query. My current formula's I am trying are; GetFieldValues(GetRecordByUniqueField([Record ID#], 7, [_DB_Alias]), 6) this formula fails as it sees a textlist from my understanding that is multiple records instead of a single record, GetFieldValues(GetRecords("{7.EX.[Record ID#]}&options=num-1",[_DB_Alias]),6) this fails for the same reason as I am pulling multiple records via the GetRecords function but applied the limit of num-1 as an option. Neither work and I would like to pull only a single record with a single field back using either of these functions.------------------------------Colin Burns------------------------------
Hi. I have a SharePoint list and all I want to do is to pull that into a Quickbase table in my app. Basically keep the Quickbase table in sync with the SharePoint List, It goes in one direction only. As items are updated in the SharePoint list, I need the table in Quickbase refreshed. I don't necessarily need this done on an event-driven basis, it's also ok if I just query the sharepoint list once a day for example. Eventually I will use this table in QB for a relationship. I enter a new record in quickbase in my main table and want to select from a list of users. that list of users will be in a separate QB table. that separate users QB table should pull in the source list of users from the sharepoint list. How do i get a list of users from a sharepoint list into a quickbase table, that i can use that table as a lookup field in a form for another table? But I can't find anywhere how to do this. I've tried to set up a pipeline in this direction, but
We have a set of pipelines that pull a lot of data from Sharepoint into quickbase. Yesterday they all failed; and they did again today. The error message I get is "Remote service reported an error: The request is unprocessable because it uses too many resources". I googled it but still don't really understand what the error means. Can anybody else what I need to do to fix the pipelines?------------------------------Krista Sibery------------------------------
Is there a way to have your multiple choice text field sort in more ways than alphabetical or "Order shown here"? Or put another way, is there a way to select what "Order shown here" refers to? I have a source table that is a list of active and inactive funding sources. I am using this as a global pick list for multiple tables in my app. I want it to display active funding sources first, with inactive below. i.e. sort active first and inactive second. Ideally it would also be alphbetical after the active/inactive sorting. I tried setting the default report to have the proper formatting, when you open the table it displays how I want it, but the field list in the other tables are either based on when the data was entered (order shown here) or just alphabetically. It appears that "order shown here" is based on the row number. Any advice would be greatly appreciated. ------------------------------Ryan Williams------------------------------
Looking to see if there is anyone out there that uses Five9 Cloud Contact Center with Quickbase. Pros/Cons? Please feel free to email me directly if you would rather not post. Thanks, Kim Cameron kimcameron@vttinc.com------------------------------Kim Cameron------------------------------
In our data analysis task, we encounter a scenario where we need to determine the average percentage of Consent Date entries compared to Date Requested entries in a table. The steps are: Count the total number of entries recorded in the Consent Date field. Count the total number of entries recorded in the Date Requested field. Calculate the ratio of Consent Date entries to Date Requested entries. Convert the ratio into a percentage average. All my values are entered into the table, but I don't have the know-how to write the formula. I imagine it would be a table report generating this percentage. Thank you for your wisdom.------------------------------Ev von Cort------------------------------
Hi all, I am trying to use pipeline to first search/filter out the records that I want, then within those records, I want to sum up a field ("hours") and update a record on another app. I tried the following: Search records --> Look up the record that I want to update --> update record with sum For the update record step, I have the following jinja code but it's giving me an error because it exceeded 100 records: {% set total = namespace(value=0) %}{% for r in range(90) %}{% set total.value = total.value + a.hours|default(0,true) %}{% endfor %}{{ total.value }} Is there another way to do this? I wanted to try the "For each" loop but there isn't a global variable that I can assign. Thank you! ------------------------------Jay------------------------------
Hi guys. I have created a Global variable (say, "Date" with value = 01/10/2023). I'm using this global variable in various formula fields. But Can I use this Global variable in any Pipeline & Dynamic form rules (old form)? Note: I know we can create a local Date field with Date field=ToDate([Date]) on table, but I don't want to create a new field. :) ------------------------------Vivek Vishwanath------------------------------
I don't understand this error message. ------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
My iPhone updated to the latest iOS, and now i cannot attach files or photos to a file attachment field. I am thinking it is some sort of new security setting, but I cant find it. Does anyone know the solution? Edit: I figured out that it just won't add any photos that were already on the device before the update. Any new photos will add. Something strange with the security settings. Luckily, I only need to attach new photos, but if anyone knows what setting this is, let me know.------------------------------Mike Tamoush------------------------------
I have a report in a parent table that I need to pull in records in a child table to also display in the report, However, when I go to add the fields they are not an option and there isn't the option to select fields from another table. I already have a relationship built between the tables...but not sure of how else to have this field pull into a parent table report. Thanks!------------------------------LB------------------------------
Is anyone experiencing new behavior with the grid-edit option? This is happening in regular table reports AND specifically grid-edit reports. When clicking the grid edit option at the top corner the page reloads with an absurd amount of fields. This new view is not a default report - or any report that exists as far as I can find. At first my fix was to make reports grid-edit from the start but now even those are showing the same behavior. The correct columns show in preview and then reload with a huge number of columns when displaying for any record entry. I know that this is not the expected behavior - many users are reporting that they can no longer grid edit as they were able to last week. My support ticket was closed because this is "expected behavior" and I was told that I should submit a feature request if I wanted to be able to customize my grid edit columns. I know that I've done this before many times so I'm feeling lost. Is this a glitch only in my app? I have a few tables t
Hi y'all, I am attempting to work out the conversion rate for our Sales agents to be displayed for management in a nice gauge. I am partially there; however, the result being returned is not the expected result. What I am trying to do is get all the records where the Agent is assigned and where the Agreement Signed date/time field is null. I return the records for the last 30 days where the Agent is assigned and the Agreement Signed is not null, and it excludes any records older than that where the Agreement Signed is not null. I have this formula: var number Sale = If(not IsNull([Agreement Signed]) and ToDate([Agreement Signed]) >= Today() - Days(30) and [Sales Agent Name] = "Agent Name", 1, 0); var number NoSale = If([Sales Agent Name] = "Agent Name" and IsNull([Agreement Signed]), 1, 0); var number ConversionRate = If(($Sale + $NoSale) <> 0, ($Sale / ($Sale + $NoSale)) * 100, 0); $Conversio
My Y Axis is showing up on decimals, not whole number percentages. But, then others are showing the other way. I don't understand why the difference. I have done comparisons of chart setting and I can't see the difference. ------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
I am stumped! I am trying to make my current (basic) YOY report better. I have several "clubs" and each of them have new enrollments, membership renewals, and cancellations. I have not had a problem showing the basics, but this is where I am stumped...I would like for the cancellations to somehow reflect when received and also the original enrollment of that member. Here is a brief example: YR-2020 2020 2021 2022 2023 ASC Members 1082 0 0 0 ASC Renewals 0 489 235 191 ASC CXLs 73 2 0 0 So, I am showing all of the activity happening to the members originally enrolled in 2020. I am able to get the individual components but not reflect back on the original year if that makes sense? Or maybe I would need to do a summary report for each year and then pull from each of those to create a true year over year look? If this has made sense to anyone, please let me know what you think. Thanks, Kim ------------------------------Kim Cameron-----
If([Project Type]="Extended",SumValues(GetRecords("{186.EX.'"&[ResetID]&"'}",[_DBID_RESETS]),28),SumValues(GetRecords("{186.EX.'"&[ResetID]&"'}AND{144.IR.'this mon'}),[_DBID_RESETS]),28) The period after the IR. statement I am receiving "Please check the syntax of your formula. Look for.... I cannot figure out what I am missing here.------------------------------Hans Hamm------------------------------
I have the Docusign integration working well except 3 issues. Can anyone help? The checkboxes in the Docusign Template are not showing up to map. My dates are showing up with long time stamps. Can I make it just a date? The proper field type and formatting is selected in Quikbase. My currency is showing up with no comma and one decimal. The proper field type and formatting is selected in Quikbase. Thanks in advance!!------------------------------Tiber Capital------------------------------
Hello, I've built a template in DocuSign and mapped the fields to QuickBase via pipelines but the checkbox fields on my DocuSign template don't appear as input fields on the pipeline. ------------------------------Amrom Muller------------------------------
Hey there, I've got a record picker that will be used almost exclusively in Grid Edit mode. In grid edit mode, how can I sort the values in that record picker on a field of my choosing?------------------------------Nathaniel Cahill------------------------------
I need to display the field value for each child record of the parent table in a report in a Combined Text summary relationship field. I'm getting this error when trying to create the combined text summary field: "That summary function cannot be applied to this field..." The field I need to create a summary of is being pulled from yet another child table (SEO Bucket Rate Card) (grandchild) related to the 1st child table (SEO Deliverables) of the parent table (SEO Deliverable Cycle) Table Name / Relationship `SEO Deliverable Cycles` = Parent `SEO Deliverables` = Child `SEO Bucket Rate Card` = Grandchild I'm stumped - any way around this?------------------------------Matt Makris------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.