Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I have created a table for the one group in my department. Within that group there are a couple of different job types. When creating a report, is there a way to only include certain members of the group? Example: I have a table of Nurses, I have created a field called Nurse type. I want to create a report for Nurse coordinators. Can I make a report using the field "Nurses" without having all the nurse types in my report?------------------------------Campbell H.------------------------------
Whenever we try to update an item using search records and then update record, its says the following error : "Validation error: This pipe requires a single item target, not a list"Can anyone help me what is this error relating to ?I cannot understand what is the method to debug and check the correct method.------------------------------Souvik Chaki------------------------------
Can I disable editing for some columns/ not to be edited in the grid edit mode? In my report, there are 2 columns which only needs to be updated by user so I wanted to keep remaining columns read only/ non-editable. Is there way to do this?------------------------------Mrunali Kadam------------------------------
I have created a cross table with the date as a pivot field. This created a cross table report with date running in ascending order.How to sort cross table so that the pivot field runs in descending order ?------------------------------Udaya Venkataramana------------------------------
I have a summary report showing calls made by date. Its summarized by date. I am using the system create date as the grouping date. The report sorts in asending order by default. I am trying to get it to sort by desending order so the latest date is on the top. How can this be done?
I've created a grid edit report to serve as a queue. Basically the user that works the queue will receive a daily email with a link to the report and the user will tick a checkbox next to each item she wants to mark as completed. The report is filtered to show only items that have not yet been checked so the next time it is loaded the checked items have been removed from her queue. The problem is the report redirects to the dashboard or somewhere else when she saves making the whole thing very cumbersome to work with. I would rather the report reload when she saves her changes. Is there any way to either modify the link I send her or configure the report to reload the current grid edit report when saved? Any help is much appreciated!------------------------------george------------------------------
Hi All!I feel like this is a thing and I'm just blanking on how to do it, but haven't found anything online. All I'm looking to do is to import a csv into a QB table when forwarding the email (with CSV attachment) to a specific email address. I completely understand how to do this when utilizing the webhook endpoint. I thought there was a more direct way of doing this without needing to utilize an external parser. Any help would be awesome!Thank You!Chris------------------------------Chris------------------------------
I am working on a dashboard layout for home pages. So I set myself up one. Everyone else in the organization uses pages. I like that I can resize both vertically & horizontally. But I see that I am limited to 12 rows. I am limited to just 3 or 4 charts or tables. I tried on pages, but when I try to take a pie chart and squeeze it into a small space, it does squeeze vertically but I can make it smaller horizontally. It takes up too much space, so I like the Dashboard page better. But it would be good to have a bit more real-estate to work with up & down.------------------------------Bob T.------------------------------
Hello,I have a pipeline created that sends a email with links to our billing documents, since we can't actually attach documents to the email. For any given job, we may have six to eight different documents. For the jobs that have fewer documents, I have dead links showing up in the email. Is there a way to only have the links show up if there is in fact a valid link in the field?------------------------------Lenny Brooks------------------------------
I have a pipeline where I have a Fetch JSON and then Iterate over JSON records. After that step I create the quickbase record but it is only creating the first record in the array and does not create the remaining list items.#Pipelines #array #json ------------------------------Ty G------------------------------
I have taken an HTML5 Web page design I did for a couple of my website clients. I like it because it has great navigation buttons at the top and when looked at on a phone shows an HTML menu selection.So, I have decided since it looks like Dashboard pages, don't give a lot of real-estate to work with to incorporate my charts and tables on my Code page. Is it possible to add a report, embed into my web page?------------------------------Bob T.------------------------------
Hi Is it possible to use field names on the RestAPIs, similar to the XML option? Quickbase API PortalFor the xml option you are able to use field names as follows: > Field names are nearly identical to field labels; if you know the field label, you can determine the field name by converting all characters to lowercase and replacing all non-alphanumeric characters (including spaces) with an underscore.When I attempt this with the Rest as below for example: { "to": "br2shmsne", "data": [ { "first_name": { "value": "This is my text: First Name 1" } } ], "fieldsToReturn": [ "24" ] } the error is always "Unknown field with Id \"0\"." ------------------------------Melissa Palmer------------------------------
Good morning, I have been using Quickbase for about 2 months and have set up some very basic pipelines (to Quickbooks, Google Drive and a few amongst Quickbase apps). I went in today to try and use another pipeline and received the error message "The CSRF Token is Missing" when trying to add a new User Token to connect an app I had just made. I have not experienced this before and have not found a similar thread here. Any advice on how to correct this? Thank you,------------------------------Steve fydenkevez------------------------------
I wanted to track the history records of a specific field. It's like the formula in the table below. Does anyone know how to create this formula? I want to track WHO changed WHAT field(OLD VALUE vs NEW VALUE)by WHEN.This field is from builder program/exchange/PI-01 Job Candidate Tracker/Candidates. It doesn't tell me how to create this formula.------------------------------Di Miran------------------------------
HI all please assist with the formula for the below. Duration - Formula Duration - Calculate duration between start and end time and subtract 1 hour if lunch is checked.------------------------------Boitumelo Segaole------------------------------
Hello:Before I was issued a TD email and laptop, I used my personal email address and devices to access Quick Base.Now I currently use QB exclusively on my TD laptop using my TD credentials - however I noticed that my QB notifications are redirected to my personal email only.I checked my account settings on QB - and my TD email address is the only one on file.So I am not exactly sure why the notifications are being redirected. Can someone please advise on this mystery?Thanks.------------------------------Sonia Lowe------------------------------
I can't seem to find a solution anywhere so here is my question:I have 4 fields. A, B, C, D D is a formula field that totals A, B, &C. I want to be able to adjust A, B or C and have the new total for D to reflect the changes in addition to what the total was previously. Any thoughts?------------------------------Steven Pearson------------------------------
Hi,I need help with a formula. I want it to look at a quality score field and return text. I wrote it to show the text if the score is less than 97 but I want it to be more than 0 and less than 97 because it is reading the field when it is empty.This formula works fine but it also returns the text if all the fields are empty. If([TOP ACES Quality]<97 and [Satisfaction Score]<95 and [CE Score]<97.6 and [NPS Score]<79.3 and [FCR Score]<95 ,"Missed 5 of 5") Please help.------------------------------Fatima Khan------------------------------
Is it possible to create a pipeline that will create a word document/pdf from a rich text field in each record? Then email that document as an attachment to the person who initiated the pipeline.Use Case: I need to send an email to the person who initiates a pipeline that will contain a preformatted email, including data from the pipeline run and create an attachment from a rich text field in each record that is identified in the trigger. I am not seeing a channel that will create any type of document that can be used as an email attachment.------------------------------Paul Peterson------------------------------
Hello,My setup:1. I get text data from sources, blend and mangle it together in Alteryx2. Data leaves Alteryx via API tool, arrives in table in QuickbaseI can add records easily from Alteryx.Where I'm having issues is when I try to send over text data which includes HTML tags. The field I want to sent HTML information into is a Rich Text field. The problem is that some of the records will not populate the the HTML information in the Rich Text fields; it populates absolutely nothing. To add insult to injury, if the Rich Text field gets skipped, it will fail to populate any subsequent fields in the record. I spent a few hours stripping out various tags I can live without in Alteryx...the usual suspects, like ', &, <BR>, a handful of others, and I can't seem to find the right combination to get it where I am able to successfully send over data every single time where all the fields are populated. Does anyone have experience with this? Are there things I should be doing i
For a state - I want to show how did on a performance measure (there are about 9 performance measures) on a monthly basis. I am trying to figure out to best way to set-up the table, so that i can capture the measurement month, the state, the measurement, and the value - so I can created a monthly trend report for each of the 9 measures and see each state against together and separately. What is the best set-up for the table to make monthly entry as easy as possible.------------------------------Lashell Thomas------------------------------
Trying to get an import of data from a file to create records in a QB app. I tried the CSV Handler but there is a 10K row max whereas my file will always be greater than 10K. Started looking into the JSON Handler as I can create a JSON file via my Alteryx workflow.The wall I'm hitting at the moment is the JSON URL within the Fetch JSON step. Since my JSON file is stored on my OneDrive, no other option and the pipeline starts with a OneDrive trigger, I can't seem to figure out how to populate the JSON URL field. I've tried a few different variations based on what I can find on the web (new to JSON).When I paste in the filepath to the OneDrive, I get "validation error: no connection adapters were found for 'C:\\Users\\xxxx'. (double clashes were added even though I copied single slashes into the URL)I then changed it to 'file://localhost/C:/Users/xxxx' with the same validation error.Any assistance would be greatly appreciated.------------------------------Ro
Can I create user-defined filter view in the QuickBase? Multiple users will be accessing this report so they want to create their own filter and save it for future references.------------------------------Mrunali Kadam------------------------------
Hello, I am needing to calculate employee tenure in years and months. I currently have a date field "Start Date" for the date of hire. Is there a formula to easily calculate this?Thank you in advance!------------------------------Addie Brunson------------------------------
Hi Everyone, I'm trying to redirect a Save and Keep working button to a particular tab in the same form. Is it possible to do so? Please help.Thanks------------------------------Hema Rajendran------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.