Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Happy Halloween! New Forms ~ How Do I enable 'Dynamic Form Rules' I thought this question on 'New Forms' needed it's own thread. I have the administrative section setup. But I don't have 'Dynamic Form Rules.' The old form does, and this section is only available to administrator roles. How does this work in 'New Forms'? ------------------------------Bob T.------------------------------
Is there way to export a list of Text - Multiple Choice fields and the options for each one. I have a lot and I need a list of them but it will take forever to manually do it. Thanks!------------------------------Carol Mcconnell------------------------------
Background: Workstation Hardware (child) and Tracking Board Master (parent) are related with a conditional choice. Please see screenshot below. Issue: We are running into this issue where repeatedly the related table field on many rows is getting set to 0. It seems QuickBase Actions or Pipelines are changing this. But there is no pipeline or QB action that is changing the selection in for the dependent Related field to be nulled. Nor are any of the actions or pipelines changing the Related Tracking Board Master field itself. This one is really stumping us. We have multiple such relationships built in our database, but none of them are behaving this way. Seems like a bug. Any suggestions on how to debug this further? Thanks a lot. Uma------------------------------Uma HarithsaTrinity Health------------------------------
Hey All, I'm trying to use the "Copy this [record]" function since creating a new style form. When I return to an old style form, and click the button from under the More menu, I get routed to the selected record but on the new form. I tried creating a formula URL button to get around this function, but the formula URL button has the same issue.Any suggestions? Is this a known bug?------------------------------Sam Jones------------------------------
The collection of data for my Excel.cvs export for BOM item part numbers (PN) is working nicely, except Excel is treating some part numbers differently. In QB, all PNs are TEXT, some PNs are alphanumeric while others are numeric. When building the excel export routine in Pipelines, I am using the TEXT PN field in the "Part" header and defined as a STRING field. When opening the Excel.cvs after it's complete, the following occurs. Now, I have tried prefixing the PN with a hyphen (') since Excel recognizes everything thereafter as text - but this does not work. When selecting the two out of place occurrences below in the excel.cvs and manually adding a hyphen prefix in the excel address bar - all is well again and displayed correctly both position and value. The PNs that are acting differently, all seem to be of a numeric value within the text field PN. When Pipelines defines the table, there are few options to set attributes of each column Any insight into this painful anomaly woul
Is there a way to track notifications sent? I know there was a post about this in 2016, just wondering if there is a way to do this now.------------------------------Krista Sibery------------------------------
New Forms ~ Can I left justify my field labels? I like the new forms and have been working on redoing old forms. The old form allows more vertical space with text labels (see 1st image) that are left justified before the fields. On the new forms, the labels are on top of the fields, which may be used. But is it possible for me to have the labels left justified as the old forms give you the choice of either left or on top? (see 2nd image of new form with labels above their respective fields.)------------------------------Bob T.------------------------------
Good Afternoon All, Hope everybody is having a great Wednesday. Wondering if anyone has some insight on a problem I'm facing: I currently have a table that auto-imports fuel prices once or twice a week. I would like to create a formula that identifies the couple hundred records that were imported with the most recent date, so that I can create a bar chart of the most recent pricing. Has anyone ever written a formula that can identify records with the most recent date?------------------------------Aidon Olligschlager |Flight Operations Technical SupportPentastar AviationWaterford MIaolligschlager@pentastaraviation.com | 248-202-9587------------------------------
I have a summary report that I use to summarize information by week. I would like to only display the previous 4 weeks, but when I do this the "Totals" column just shows those 4 weeks for totals which is confusing based on what is displaying for other reports on the dashboard.I know that you can remove the totals row. Is there a way to remove the totals column in a summary report?
One of my users created a new app and added me as admin. I went into a table and opened a new entry. That entry does not have a "Customize Page" option. All the other apps and fields outside of this app my assistant created has that option. I confirmed that I am admin with all of the options to modify and change the tables in this app. Please help. ------------------------------Galen Shimoda------------------------------
For years, we have successfully used report link fields to link from records in table A to records into table B. We recently built a new main form for table B using report builder. Now, clicking on report links in table do not take us to the matching record in table B. Instead, a filtered report with only the record from table B is generated. This creates a needless extra step. Is it no longer possible to use report links to jump between records? The extra report step is not needed for direct matches. The report links are for unique fields - Record ID#. I have tried creating new report link fields and the issue persists. Has anyone found a workaround for this issue? Thanks ------------------------------Kaisa Janzen------------------------------
I have a table based on 3 digit zip that has the user listed for each 3 digit zip. On the main table/form, when a user clicks a checkbox, I would like the user field to update to the correct user based on the 3 digit zip code that is on the record. Can you advise how I would do that? ------------------------------Carol Mcconnell------------------------------
I have created a Formula - Numeric field for this, but I don't know how to write the formula. I need [Room Square Footage] divided by [Bench - Total] multiplied by [Bench - PI]. Could someone help me with this? Example entry: ------------------------------Meagan McOlin------------------------------
Currently re-building our governance app and need the ability to copy applications.. I have a pipeline that use's the Make Request action, but when I test it, it returns an authentication denied access error. The Make Request connection is using the "Realm Default Account" with my user, which is the standard name when you create a new connection. My user account is a super user. If I switch it to a user token connection, and grant that token access to the app I'm trying to copy, then it works fine. But I don't see a way to automatically add an app to a user token via API, so I don't think that method will work for me. Has anyone else accomplished this via Pipelines?------------------------------Jordan Bardwell------------------------------
Is it possible to create "Is Current User" report filter using a user-List field?------------------------------Christine White------------------------------
Hi all you clever people! I am new to Quickbase and learning fast! This might be an easy one for you, I don't know. I have created a Check box, now I need to know if there is a report that will be able to show me date, time and who checked the box? Thanks for your help------------------------------Jannie Coetzee------------------------------
Hi All,I want to start storing the file attachments on a google drive, the way that I want to structure this is I want to create a Pipeline that everytime a new record is created with an <address> this address will be the name of a folder on my google drive, and then every time that a file is attached to a particular field the file will be move to that folder, the name of the file will be the <address>+<field name>+<filename>Do we know if Pipelines supports this? Thanks in advance,
Hello, In my application I have a table that lists the diagnosis code and description that connects to another table to use the fields as options for a drop down. However, for some reason my fields have changed to what looks like should be a pre-populated field based on adding a record and I'm not sure how to change it back...? In the screen shot the diagnosis field should look like the fields below select a code and the description will populate into the form based off of the selection. Thanks!------------------------------LB------------------------------
Hi, Good Day! I am trying to export QuickBase table records into CSV for a given range of record IDs using the "Export Records to CSV" pipeline step. However, the pipeline step is failing with errors such as "Failed composing data No records were exported to CSV" or "Failed to retrieve source data No records were exported to CSV" for a given range of record id while running successfully for others. What could be the causing this failure? I've checked that records do exist in this batch of records for which pipeline is failing. Regards------------------------------shivani jain------------------------------
I have a scheduled pipeline set up to make some changes within my QuickBase application. However I have been receiving a number of errors on this pipeline which I am unsure how to resolve. The error that I am receiving is: Quickbase app is experiencing unusually heavy traffic Got a transient error from remote system. Retrying operation (1/15 with 7ms timeout) with a back-off. Any help on how to avoid this error would be appreciated. Thanks!------------------------------Caleb Gayton------------------------------
Is there a way to easily add a shaded background to every other row of a report to improve readability? The report uses filters so the record ID#s are not consecutive.------------------------------MARIE THERESE PLEWNARZ------------------------------
Hi All,Does the platform support that with an action button to trigger a pipeline? If this is the case how can this be accomplished?Thanks in advance,
Hi folks, I have only found one thread from about a year and a half ago relating to this error, and it appears unresolved. Following the recommendation of another QB Expert on here, I am creating a Pipeline to create a record when an option from a drop-down list of 'tasks' is selected, and I keep getting this error. All fields in question are Text fields. There are no numeric fields. Has anyone experienced this before? I feel like I can't move forward into the next steps in this project without resolving this first. Thank you! Jen------------------------------Jennifer Juhasz FamilySmartBC, Canada------------------------------
Hello, I have an interesting request. My QB app is pulling in entries and I am capturing the posting date of the entry / record. I can convert the posting date to a fiscal period such as Oct'23 using a formula field. I need the user to now select the fiscal period in which the entry will be reversed. I initially just created a static drop down field but received a request to make it variable so it only shows (in the drop down list) future fiscal periods. So if posting date is 10-01-2023...Fiscal period (Formula)= "Oct'23" Drop down list should show: Oct'23 Nov'23 Dec'23 Jan'24 etc If posting date is 05-29-2023 and Fiscal period (Formula) is "Jun'23" Drop down list should show: May'23 Jun'23 Jul'23 Aug'23 Sep'23 Oct'23 Nov'23 Dec'23 Jan'24 etc What's the best way to achieve this? Thanks. Deepa------------------------------Deepa Prashant------------------------------
Quickbase is focused on continually helping our customers improve their security by using the safest security protocols and aligning with industry best practices for data security and integrity. For that reason, Quickbase Sync (for connected tables) will be updating the SFTP connector to only allow connections to SFTP servers that use SHA-2. See the list of supported algorithms below. To give you time to transition, the current version of the SFTP connector (Version 1) will continue to be available for existing connections until the Quickbase May 2024 release. Beginning with the Quickbase November 2023 release, connection owners can switch existing connections to the new version (Version 2). Quickbase may automatically switch some connections to Version 2 based on the server version and algorithm currently being used by the connection’s SFTP server. New connections created after the November 2023 release will use Version 2. What do you need to do?If you are the owner of an SF
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.