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 child table (created by form engine) which contains a field that will be the (custom) key to its parent.The child table may have one or several records which should relate to one parent record.I created a pipeline that does correctly create the parent records, but it seems slow, and we could have many people entering these child records at one time. It is using an upsert (on rows created in the last five minutes, currently) to handle the fact that if there are multiple child records, only the first one should create a parent. I saw this discussion, below, and that's what led me to use the upsert - because of the comments about contention causing pipeline errors in this scenario if another strategy was used.Automation to create record if does not exist | Qrew DiscussionsThis discussion is from several years ago though - is an upsert still the best way to go in this scenario? And is there any way to make it faster?
Good morning,I am building a Transportation application for my team to use. When we request a pickup time from our transportation vendor, it is always in central time since we are based in Texas. Can QB convert the central time to local time based on my selected city?For example, I have an employee who needs to be picked up at LAX at 10 a.m. Pacific time, but we can only enter 12 p.m. Central time. How can I build a formula in QB that will convert noon central to 10 AM when I select LAX as a city? The same goes for all the cities we service. How can I make sure Daylight savings are accounted for?I have attached a spreadsheet of the cities we service regarding their summer and winter times.
Hey Community! Does anyone have a formula for a query to pull the URL of a related record's file attachment field? I'd like the URL to appear on the parent form and the user can click to download the file. Thanks!------------------------------Raymond Sakar------------------------------
Hello,I bought up this very issue 2 years ago, but it now looks like the solution is no longer working.https://community.quickbase.com/discussions/quickbase-discussions/pipelines-bug-json-value-not-being-parse-when-specifying-the-json-records-path/20129Steps to reproduce:Insert a fetch JSON and iterate JSON steps.In the Iterate JSON step, I've defined the JSON Records Path as: /response/results. I've included an example JSON response below.Inside the Iterate JSON loop, I'm tried using the following variables to refer to the custom_id parameter:{{c.raw_record.custom_id}}{{c.raw_record.['custom_id']}}However, I keep getting this error when the pipeline is run:Validation error: Incorrect template "{{c.raw_record.custom_id }}". ValueError: invalid literal for int() with base 10: 'raw_record'This is very strange as this method to refer to a JSON path used to work perfectly.I also doubled checked the activity log and using raw_record in the variable should be correct, because when you define
I really want to batch UPSERT to a unique field in Pipelines.I am using RestfulAPI to get a report ~ the data is filtered at the source. ChatGPT has shown me {{b.json.metadata.totalRecords > 0 }} is how I know my report has values.I want to iterate over the JSON, Restful API returns JSON ... I cannot select the Restful API as an input for the iterate step. Why must I add a FetchJSON step in front of the iterate step and essentially move the values from the Restful output to the fetch and then to the iterate?
I'm trying to set up a pipeline to move a file attachment to a folder in a SharePoint when a record is created. On the SharePoint step, I'm getting this error.Does anyone know what is causing this?Remote API returned authentication error: (invalid_grant) AADSTS700003: Device object was not found in the tenant
Hello Everyone,I created a SCC where the X Axis shows Supervisor Name and the Y Axis shows a stack of 5 different Formula Fields we'll call CB1, CB2, etc.My Filters are set to Status = Approved ANDEval Date Is During the Current Month.The chart can shows up to 5 columns 1 per Sup.What I want to do is create the chart to show 2 columns for each Sup. where 1 is data from the Prev. Month and the other for Current Month. Any help would be greatly appreciated.
I want to get a running total of the number of rows in a report. I have a formula that is COUNT([field name]), which returns a value of 1. To get the running total value, do I have to first create a var text query on the field I am counting?var text QUERY //var text QUERY = "{fid#.}";Is the Running Total formula: SumValues(GetRecords($QUERY),fid#)
Is it possible to hide the empty columns when a user filters the report?
Hi all,I'll try to keep this as brief as possible. I'd like to know if anyone has a similar sized application in production and if they see any performance issues as it pertains to record loading and report loading.I have an Accounts table (table A) that will have 1,500 records total at any given time. This table has 3 children tables B, C, and D with 72,000; 168,000; and 168,000 total records at any given time, respectively. These children records will all have an Account# to tie it to their parent.On table A, I need to keep up to 4 years worth of data (Current Year, Prior Year, etc.). As a result, I will need about 1,500 to 1,750 currency summary fields per year (6,000 to 7,500 in total). This number then gets doubled because Quickbase does not have a built-in way to display numbers in Accounting format, so I need an additional 6,000 to 7,500 rich text formula fields.At no point in table A should I ever need a report with more than 12 columns of calculated summary fields for all 1,50
I'm using Pipelines to track changes on hundreds of fields in a table. The step that writes a summary of the changes to a rich text field uses Jinja that looks like this:{% set fields = [ ('Field Name 1', a.field_name_1, a.$prev.field_name_1), ('Field Name 2', a.field_name_2, a.$prev.field_name_2), ... ('Field Name 200', a.field_name_200, a.$prev.field_name_200) ] %} {% for i in fields %} {% if i[1] != i[2] %} {{'• <b><u>' ~ i[0] ~ '</u></b> changed from <b>' ~ (i[2] if i[2] is not none else '(null)') ~ '</b> to <b>' ~ (i[1] if i[1] is not none else '(null)') ~ '</b><br />'}} {% endif %} {% endfor %}It works, however I'm questioning whether this can be done more elegantly, with Jinja or otherwise. I couldn't find a way to loop over the changed fields only in a generic fashion so I constructed tuples for each field. This makes the step very lengthy and difficult to find what I need; additionally my browser becomes sluggish when
We are using Gauge Reports on Dashboards to act as Actionable Items for a given workflow. For example I log on to Quickbase and my Dashboard loads with a bunch of Gauge reports. If the reports show 0, I know I am done. If the reports are greater than 0, I click the report to view the records where I need to perform some process to make the report 0. The Goal is 0.I can reverse the Low and High to apply the proper color coding. I cannot set the Goal to be 0. The Goal must always be greater than the Start At value. Has anyone come up with a solution for this without building a bunch of formulas? Am I missing something in the report settings?
All of a sudden a few of our end users are having issues with random tables and forms opening on quickbase on ipad browser. They get the Error "Something went wrong, try reloading this page." Tried resetting/deleting Clear History and Website Data from safari tried on chrome and still have the same issue. Restarted and force closed the applications as well. Tested as that user and cant replicate it. Not sure if this has to do to an iOS update or what. Anyone else seeing this? Have at least 3 users with the same issue started this week.
I hope that I'm completely overlooking an obvious setting; it appears that the new version of Forms no longer allows users to upload new versions of an existing file. Historically, users could enter a record in "Edit" mode, click "Choose File", then upload a new or updated version of the existing attachment.However, on the new version of Forms, users in my organization only have the ability to:Lock the current version of the File,Show Revision history of the field, orDelete the current version of the attachmentThere is no longer an option to "Choose File" as far as I can tell. I am referencing this guidance from Quickbase Help. Below, please see an example of the file attachment field shown in Edit Mode, and the only available edit options. If anyone has advice on how to upload a new version of an existing attachment, I would appreciate your support!
I have a report with thousands of records, I can use a filter to reduce the number of records; however, I want to select an exact number of records within a report. For example, the filter reduces the number of records 200, but I want to select the first 50 records. Is there a way to select a specific number of records within a report or a table?
Hello Quickbase peeps!So I ran into some challenges with the KPI Gauge widget. The KPI Gauge shows the correct percentage when creating it in 'Reports & charts' but the problem arises when I add the widget to dashboards; it shows 0%. After some troubleshooting, I've discovered that while previewing the KPI, it works just fine until you turn off 'New style'. Please see attached pics. Not sure if this is a bug or if there's any workaround/fixes for this. *Calculation is using summary formulasThanks!
Friends,I have a SharePoint list with book data. I have built a pipeline in quickbase that will insert a new row in the list whenever a new record is created in quickbaseI have created the connection to my SharePoint list correctly. It identifies the site and the list. But the pipeline is unable to add a record in Sharepoint. I keep getting these errors consistently. What am I doing wrong?I am new to Sharepoint integration with Quickbase. Please help.
I have a table of Training cycle start dates. Each record is a Training Start Date (FID 6 - Date Field) for a Training Team (FID 25 - Text lookup field from related Table) with a Start Date Status (FID 7 - Text). I have created a Formula Numeric field titled Rank.I need to rank the upcoming Training Start Dates for the Traditional team only, and exclude any dates that are past or do not have a Status of "Available." The one coming up soonest on/after today ranked 1, next ranked 2, and so on.We've tried several formulas without success.var text QUERY = "{6.AF.'" & Today() &"';}AND{25.EX.'Traditional'}AND{7.EX.'Available'}";If([Start Date Status]<>"Available", null, Size(GetRecords($QUERY))+1)Attempt 1 above failed. Returned rank 11 for all available start dates, past and present.var number position = Size(GetRecords("{6.AF.'"& Today() &"'}AND{25.EX.'Traditional'}AND{7.EX.'Available'}")), $position+1Attempt 2 above failed. Returned rank 10 for all available start da
We intercompany charges for Quickbase app usage and I have been asked if there is a way to suspend or pause an app while this intercompany charge is resolved. This app has like 225 users and about 50 roles. I really don't want to go user by user or even by role. I totally do not want to delete the app. Any ideas would be appreciated.
From the Women's Leadership Group here at Quickbase to all of our rockstar female builders and developers, Happy Women's History Month :) Thank you for all of the hard work that you do both on and off the field, for being apart of this growing community, and for being the best Quickbase fan-women you can be!I'd like to take a moment and reflect on what it means to be a woman in tech these days. According to Women in Tech, at the end of 2023, women held approximately 35% of tech jobs in the U.S., this number decreasing to the mid- to low-twenties when it came to leadership positions, dropping to 8-9% of women in C-Suite positions in tech. Representation has improved drastically over the last 40 years, but the tech space certainly has a ways to go.With all the awesomeness of Empower at the end of the month as well as it being a lot folks' end of Q1, we will not be meeting this month, but keep your eyes peeled for updates on cadence come April. In the meantime, let's use this thread
I team... I am really frustrated because I haven't found the way to hide the Native Save Buttons In Mobile App. Is there an easy way to do it? I normally use ifv=1 but it doesn't work in Mobile App. Please help because the Buttons are causing a lot of issues. Thank you!------------------------------David Rascon------------------------------
Hello I would like to make a unit number self generate Example 1000-(001,002,003) as more records are created.. is there a way to do this function? where it will generate the unit number based off the last record? Im a still pretty new to QB. Do I need to make the first record from there then ref that field in the max ID and add +1 to it?
Is this possible? Or are your only options to change the permissions of every field so the role cannot view, or alterntively change the permissions of every field to not allow to be added to a report?
Help Please. I have a multi-select field that has the options of Mail, Email and Dept to Initiate. Mail and Email can both be options. In that case, I want it to display "Mail and Email". But if just mail, "Mail, if just email, "email", etc. However I can't seem to get it work correctly. it does show both. Then will show just Mail, but when Email is selected it still shows Mail. I've looked at this so long and tried to refigure it that at this point is probably glaringly obvious, but I just can't see it. This is the current formula I have:var text Receipt=If(Contains(ToText([License Master - Renewals Received via:]),"Mail, Email")=true, "Mail and Email", Contains(ToText([Renewals Received via:]),"Mail, Email")=true,"Mail and Email", Contains(ToText([License Master - Renewals Received via:]),"Mail"), "Mail", Contains(ToText([Renewals Received via:]),"Mail"), "Mail", Contains(ToText([License Master - Renewals Received via:
Hello,I'm trying to create a button that will direct users to a different app to create a new record in the other app. The database ID for the other app is buwc5yqwzThe table ID in the other app is bupbavsbmThe related field in the other app is 38I've searched the community and attempted some examples that others tried but converting them from edit a record to adding a record, but I'm not getting anywhere. What I have attempted so far gives a Page unrecognized error. Attempt1: URLRoot() & "/db/buwc9wxmb" & "=API_GenAddRecordForm&_fid_38=" & [Record ID#] &"&z=" & Rurl()Attempt2: "https://xxxxx.quickbase.com/nav/app/buwc5yqwz/table/buwc9wxmb/action/nwr?a=cr&rid=new&field38="& URLEncode()Do I need to add a token? Thank you!
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.