Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hi everyone,I'm trying to find a way to create a field that counts the # of times an email address exists within a table based on a date field within that record.Example: Record is created with an email address and a date of interaction. Goal - return the # of times that email address already exists in other records on or before the date of that interaction.My formula query currently is: Size(GetRecords("{145.OBF.'" & [Date of Interaction] & "'}"))Which DOES work, but it's counting huge numbers, and I don't understand why. The results are in the thousands, for an email address that if I search for it, only exists 21 times. I *think* it's because my field 145 is also a formula query which reads - Trim(If([NEW Contact Email Address]="",[Contacts Table Field - Email Address],[NEW Contact Email Address]))I'm wondering if it's not counting the results in the field, but query; however, when I switched the field to the field 'NEW Contact Email Address] I returne
So, the problem I am having is that I have three different fields and if last field is clicked and has a value in I want to put it into another field within the same form. Likewise if no value is in the last field and there is one picked in to the second to last field I want to display that value. However my code isn't working it keeps on displaying random numbers?
I can't figure out how to do "=EOMONTH(A1,0)" like I can in Excel. Any ideas how to do this? The purpose is to bucketize all dates in a month across all months/years to a single date bucket for each month through time?
Hello, I'm attempting to create a change log to show the previous and new result changes from 3 tables into a "change log" table. I'm missing something with setting up the relationships I think and setting up the pipeline to pull in all fields at the same time regardless if all of them have a change...I attempted to also use the formula given in this training to color code the fields that have changes and it does not work. And I also referenced this material https://community.quickbase.com/discussions/quickbase-discussions/creating-data-change-logs-using-pipelines/84044
I have an approve button and right now when the user uses it it directs them to the detail record that the approval button is for. How do I change the button to have it direct them back to the page they were on before they clicked the approve button. Here is how the formula is setup now.URLRoot() & "db/" & [_DBID_Onboarding_details] & "?act=API_EditRecord&apptoken=*AppToken*&_fid_15=" & URLEncode(User()) & "&_fid_16=" & URLEncode(Today()) & "&_fid_26=1" & "&rid=" & [Record ID#] & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#])
I posted this feedback in hopes of getting attention of R&D, but it has been more than 5 months since the new forms were released.I'm certain I'm not the only person using Iforms. The failure to make the new forms capable to remove all user access but what is required for better handling of large populations of users for input is inhibiting every Quickbase developer from moving forward with new forms. Any work done to build out new forms results in a backlog to have to either go back and use a legacy form, or simply wait to release the new functionality in our apps.My hope in posting this here is to raise awareness that there is a feedback items out there that needs your support by acknowledging it, and ask you to also comment here to expand awareness.It's best practice to transition to new forms and features to allow Quickbase to grow and improve. It should be best practice for R&D to complete the task in a reasonable period of time when asking customers to use their new featu
Hi Everyone,I'm Krunal! I’m excited to connect with fellow finance enthusiasts and professionals. As the Qrew leader of the Cash Money Qrew, I’m passionate about all things related to finance, data analysis, and process optimization. Whether you’re a seasoned financial wizard or just starting out, I’d love to hear from you!About the Cash Money Qrew: Our group focuses on leveraging QuickBase Cash Money Qrew to streamline financial processes, track expenses, and analyze financial data. We’re a mix of accountants, financial analysts, and business owners who believe in the power of data-driven decision-making.What I’m Looking For: I’m interested in meeting others who share similar use cases. Are you using QuickBase for financial reporting, budgeting, or forecasting? Do you have tips for creating efficient financial workflows? Let’s exchange ideas, best practices, and success stories!How You Can Connect:Reply to this post: Share a brief introduction about yourself, your finan
All morning with this today. Not good.
I have many fields that contain data that needs to be displayed in scientific notation. Is there a way to display numbers this way?
Hello,The purpose of my pipeline is to dynamically add a user via API calls. The user who submits the request to add a "new" user has to input the "new" users email address. I understand that I then need to use that email address within the API_GetUserInfo to check if the user's email exists on any realm within Quickbase. If it does, then I should use the @id response data and insert it into API_AddUserToRole -> API_SendInvitation. If it doesn't exist, then I should use API_ProvisionUser -> API_SendInvitation.My issue is that if a user is not found within the API_GetUserInfo, it throws an error: "Quickbase reported an error: 2 : Invalid input : The user with the specified email address or username does not exist."I have tried adding an if statement to avoid the error and simply continue on:{% if b.json.qdbapi.user['@id'] != "" %}true{% endif %}However, it still throws the error if the user is not found. Is there any way to prevent this error from occurring?Thank you.
Hey Everyone, Our vendor was able to make some changes and we can now access our email notifications page in My Settings. (Go to My Settings > Notifications and Follows). Can we use this thread to test it? Adjust your email notification settings and let's see if this is working or still having issues. Prayers up. -Ben
Has anyone found a way to copy the new forms? With the legacy forms there was a little copy button next to the form, but the new forms only have a search icon. Will I have to completely re-create a form from scratch if I want to copy it?------------------------------Justin Owens------------------------------
I have to change a date field from it's current state: automatically populated from a calendar event sign up, to a new state: manual entry. This field is in reports, pipelines, rules, etc. Will there be fallout from this change?Additionally, I have to change another date field from manual input to formula driven based on another field's selection. Will there be fallout from this change as well?
Hellos,I have a scenario where I have a table where orphaned children exists , they can be recognised visually from hyperlink (See Screenshot).The question is how to filter for them so they can be deleted in QuickBase . I can do this easily outside of QuickBase but how to do this natively ?
Suddenly no Calendar reports will load in new forms. Anyone else seeing this? I've been dealing with this issue for most of the day today. I'm hoping it's resolved before I have to switch everything back to the old forms.They either show the spinning loading animation, or it just freezes and never loads like in the attached screenshot. They still seem to be working in the old forms though.
Using function Left in a formula to pull all text before a trailing "-O"If the Code has a "-" in the middle, it pulls back value prior to first "-"Code = JKL-6-O results in JKLI've tried Left([Code],"-O") and Left([Code],";-O,") with both resulting in JKLWhat is correct syntax to only strip "-O"?
I need help with creating an userid field from the username that is listed in a related field. The userid then will be used to set permissions. Is there a formula work-around to make this work. In big need of this.... Thanks in Advance!
Hi All, I've started a discussion on the new experience. Please share your feedback here on the new experience.
What syntax will people use now that QB has updated their URLS?ie, a redirect to a record used to look something like:URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & URLEncode([Record ID#])Now, will it be like this?URLRoot() & "nav/app/" & AppID() & "table/" & Dbid() & "action/dr?rid=" &URLEncode([Record ID#]That can't be right.....do we just stick with the original?
Hi.I have a need to "duplicate" the record and populate some fields on the new record (from the original record).It's not saving my current record before adding the new record, how do I get it to save first? I have the advanced setting turned on.This is my Formula URL Button:If( [Request] = "Include Existing Contractor + Add NEW FTE for Conversion", URLRoot() & "db/" & Dbid() & "?a=API_GenAddRecordForm" & "&_fid_53=" & URLEncode([Related Business case]) & "&_fid_129=60" & // Softcode the Months Needed to 60 FTE "&_fid_68=This Request is related to " & URLEncode([Request]) & "&_fid_123=14" & // Sets Request to "New FTE (Related Conversion)" "&_fid_127=FTE" & // New Employee Type "&_fid_43=" & URLEncode([Contractor PID - Dept]) &
I want my Alt Text field label to show above the field on the form instead of on the left side of it. I know there is a way I just cant remember. I am using the old forms. I've attched a photo. The part highlighted in green is what I am aiming to do. The part in red is what I need to fix. Please help :)
Easy question here, but for some reason I am struggling. All I want is to create a number field that has a static numeric value that is not editable. This is being used in a calculation. Hoping this field can show as view only with the static value displayed.Thanks,Brian
Hello, any help/advice would be much appreciated.I'm trying to send a reminder email to users in a specific Role, in a specific App, using Pipelines.As far as I can tell, there is not a JSON RESTful API call that does this (Get Users only returns all users for an App, with no info on Roles). However, API_UserRoles returns each user from an app with what Roles they have. In theory, I could somehow loop over this and send the email to only those users with a specific role.I can successfully use the Quickbase Channel -> 'Quickbase APIs' -> 'Make Request' step to call API_UserRoles and get this data.Here's where I run into trouble: How do I process this XML into a form that another step could use (e.g. loop over it and send emails)? I found this question: "To capture an XML response from an API in Pipelines" but I can't seem to figure out how get {{a.json.qdbapi.value}}. When I try to view its contents (emailed to myself) it is blank. There isn't any "Result
Hello, I have a table with a field Date-Consumption (Date) and Quantity-Consumption (Numeric) and I want to obtain the average consumption of the last 30 days, for example if my consumption begins in MAY/01/2024 to today You should obtain the sum of the last 30 days and divide it by the days that have passed, which for this example would be 20
Hi Quickbase Community,I am facing an issue with a pipeline designed to add quantities to an existing field in my Quickbase app, but it keeps overwriting the existing values instead of accumulating them.Context:Tables Involved:Transactions: Records of items being added or removed from containers.Containers: Contains fields for tracking quantities of different items in specific compartments.Fields Involved:Transactions Table:Action Type: Indicates the type of transaction (e.g., "Add Item to Container").Container Compartment: Specifies the compartment (e.g., "Compartment A").Container ID: The ID of the container to which the item is being added.Item Name: Name of the item.Item Quantity: Quantity of the item being added.Containers Table:Compartment A Quantity: Field to store the quantity of items added to compartment "Compartment A". Current Pipeline Configuration:Trigger: On new or modified records in the Transactions table where Action Type is "Add Item to Container".Condition: The
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.