Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello,I am looking for any advice/help on QuickBase's Document Template issues I have been experiencing. I have a word template that I have uploaded that is a single page, however it keeps spanning multiple pages when I uploaded. Has anyone been able to adjust the spacing in Document Templates? I can't find any way to do it, it seems to default to a double space and I want single spaces. Has anyone been able to find a way to keep their documents templates to just a single page easily? Thanks
Hi, does anybody happen to know if table notifications are on the roadmap for future QBL releases?I haven't had any luck finding any mention of this feature being on the horizon on the QBL documentation. By contrast, pipelines and connected tables have been mentioned in QBL release notes as being planned for future versions & even occasionally popped up with support in specific historical QBL versions.Notifications are a pretty critical workflow feature for a lot of the apps that my team manages. I know that, in the meantime, we can duplicate the notifications across our DEV/TEST/PROD apps manually, but this is one of the bigger blockers to us fully using QBL and SLM for app lifecycle management. I'm concerned that it seems they may not be on the roadmap at all yet.Thank you!
I am trying to convert a field that is not a user field to be able to read first name, middle name, last name. I have a field that reads last name, first name middle name/initial (Smith,John Q). I want a field where I can convert it to read as John Q Smith. I have found a formula that I think may work but when I try it, it just shows the original format (Smith,John Q). Is there something I need to update or another formula to use to accomplish this?
I'm building a Quickbase Pipeline that triggers on an incoming webhook request containing a JSON array. I want to loop through each record in that array and create a new entry in a Webhook table. What would be the correct JSON URL format for accessing the incoming request data via the webhook?
Good day everyone! Through some searching I did find this YAML Document creation - Save PDF to field in record | Qrew Discussions to create and email and Document Templet. Looking through the YAML, I couldn't tell if this would work with a document templet that has to also pull from specific fields in the record we want. For instance when we finish a job, we have a button that Generates a service closing report that populates some information based off that job. The generate document button is with in the report and grabs the fields we need from there.My end goal is to automate this for my guys on the road, where clicking generate document will also:Attach the Document to the RecordEmail the generated document to a subset of people associated with the job.
Hello QB Experts,I’m a Quickbase user, and I’ve noticed that both Quickbase and Pipelines offer somewhat limited programming capabilities.I’m wondering if it’s possible to use Quickbase primarily as a database system (and visualization/application), where I:Export data using PipelinesProcess and analyze the data externally using languages like Python or JavaScript (e.g., using Pandas, NumPy, etc.) with complex programming.Then write the processed data back into Quickbase as records via Pipelines in near real-timeIf this approach is feasible:What platforms or tools would you recommend for handling the external processing?What skills or knowledge should I focus on to implement this effectively?Are there any example apps, tutorials, or Quickbase resources that demonstrate a similar workflow for learning and practice?Thanks in advance!
While using an iPhone or iPad mobile device, I'm trying to figure out how to display the filter icon on reports, but can't get it to display. Is the option to change report filters on mobile devices still supported?See the attached screen shot for for an example of what I'm looking for. I'm using Safari as the browser and also tried displaying the filter icon using the Quickbase mobile app.Thanks, Jim Lieder
Did QB recently (within the past few months) make any updates that would impact a user being auto-logged out due to inactivity? Admittedly this hasn't happened to me as I spend a big chunk of my day in QB, but I've had a lot of users complain that they've been getting logged out more and more often. Apparently they used to go the entire day without getting logged out (despite our realm-level policy being set at 2 hours of inactivity before triggering a log out), and now they're reporting as little as 30 minutes of inactivity before being asked to log back in again. It's a mild annoyance that's impacted a lot of my users.Something I never really noticed because I hardly go 20 minutes without using QB during work hours, but maybe our 2 hour logout policy at the realm level wasn't being enforced properly and now it sort of is?
Hi everyone, I had a user request a line chart that is filterable by contact showing the Total Opportunities Created as one line and another line showing the total revenue generated. The idea is the lines would have 2-3 colors per set (YTD, last year, 2 years ago) and would be filterable by the contact they select. The challenge is to my knowledge you cannot dynamically filter formula queries. So how would you go about this? Basically when he does his quarterly business review meetings with clients he wants to pull up a chart showing how many opportunities we generated and how much revenue generated for that person. Than switch to another person for the next meeting
I have a pipeline that says it's updating a record but it's not.I have an identical pipeline that is working. It take a file attachment uploads it to Sharepoint and then updates the quickbase record with the link to the sharepoint attachment.I have two on the same quickbase but different tables. The first one I created works fine and the second one says it works and it does except for updating the quickbase record with the sharepoint link.How can I tell where it is failing?Carol
I have two related questions!Someone suggested using grid edit reports on my forms for a more all-in-one parent-child editable comprehensive form. That's not working at least on my end -- has anyone had grid reports be available within a form?I'm reorganizing another section of my app for a division that hasn't moved over to my current setup yet. In their legacy setup, there is currently a one-form-fits-all, which requires many things based upon the service level they rendered. We're moving to a "Clients", "Cases", and "Service Calls" -- which means I no longer can require things at the Client or Case level based upon the extent of the service call..... is this just a trade off I have to make? I'm concerned people might not go back into the parent record and update with additional information as it's received in this new setup (and hence why the grid edit would honestly be a fabulous option -- bring the Service Call record right onto the master record and edit it all from there).
I have three tables in Quickbase:EmployeesTrainingsProfilesI’m trying to build a Pipeline that automatically assigns trainings to employees based on their "profile".Example:The "profile" called “Basic”requires:CPR TrainingFirst Aid TrainingIf John Doe is assigned the “Basic” profile, the Pipeline should automatically add John Doe to the existing CPR and First Aid training records.A few important requirements:The Pipeline should only add trainings where the Employee Profile matches the Training Profile.The Pipeline must check for duplicate trainings and NOT add the employee to a training if they are already associated with it.If this can be done without a Pipeline I am all ears.
My parent table is "Change Requests" and child table is "Prompts." The prompts tables houses prompts to a chatbot and the Change requests table houses all change requests (bugs found, knowledgebase expansion etc) that stem from prompts that have a negative feedback.So each prompt could have a change request. I created a Related Change request numeric reference to link the two tables and a corresponding Change Request (Text (reference proxy) ) and this allows me to look up and choose a parent record to assign the child to.However, I first need to create the parent record before it shows in the drop down menu of the Change Request (Text (reference proxy)) field. Further, I would like to filter this drop down to only show Change requests related to that particular Bot (as the Prompt table houses data for multiple Bots).Is there a way to create a new 'Change Requests' record from within the Prompt's table?I have Prompts collected for two Bots - Is it possible to filter the Change Req
My app has a few different role, the main ones being admin and business. as of now the admin role is behaving exactly how i would expect it to, (i.e., records are read only based on certain flags) but the business role (the one the actually users will use) is not behaving the same way as it is allowing edits. I dont have any form rules at the role level, the tables used have no restrictions on which fields to modify. How can i get the business role to behave the same as admin so records are read only based on certain flags?
When a parent record is added, and a specific "issue type" is selected from the drop down list is there a way to require a task record to be created. The add task is a linked table within the parent record.
I have a pipeline with a search records step using an advanced query. It is successfully returning the records I'm after, but I would like to also sort the results so I can grab a particular one.Is it possible to specify options for an advanced query within a pipeline search records, or am I limited to just a simple query string? The documentation doesn't mention how to incorporate other params in a pipeline just the query string.My current query string:{'3'.XEX.{{a.id}}}AND{'16'.EX.'Update'}Thanks!
I have a pipeline which has a search step from a list of students. In the filter I want to include the names I want and not the entire list. SchoolName is xxx ANDStudent Name contains John OR Student name contains Michael ORStudent Name contains Joan OR.......they are 24how can I approach this using using advance filters
I have a pipeline that when an attachment is saved in QB, then it takes that attachment moves it to SharePoint and then retrieves the SharePoint Link and updates the quickbase record with that link.Now I want to know is there a way for an email that has attachments, to save the attachment also. Right now when they open the email, in order to see the attachment, they have to open the email in Outlook.Thanks,Carol
I am trying to access the XML API from Excel. If I embed my User Token in the request URL, things work fine: I go to Data -> From Web, paste in my query URL, and after a little drilling down, I got my data.HOWEVER: The spreadsheet that calls the API is to be passed around, and word on the street is that leaving my User Token in a shared document is Not A Great Idea(tm).If I use the query URL without my User Token, I get an authentication window of sorts from Excel, but if I select the Basic tab and enter my credentials, I get a message "We couldn't authenticate with the credentials provided. Please try again".My goal is to have every user enter their own QuickBase credentials when refreshing the data in the spreadsheet. I can't use the QuickBase add-on for Excel, and I can't create a shared account to access the data.Is there a good way to do this? Thanks!
Hi folks. I am trying to get an advanced filter to work in a pipeline so that I don't have to enter all 81 combinations in.I don't speak Jinja (yet), so I used AI to help me code this. It looks good to me, but when we ran a test, the pipeline did not trigger. I assume it has to do with the way which the Jinja is written. Can anyone help me understand what I did wrong, here?Here is the offending code. It's also been tried without the various cleanup filters on the fields (trim, float, string).All string values for these fields come from pre-defined lists, and the two hours fields are numerics. I think the problem has to be either the syntax or references; I don't think the actual logic is bad.{{(a.Req_Status|string|trim) == 'Submitted'and (a.Requested_Hours|float) < (a.Provider_Expected_Hours|float)and (a.Approv_Mgr1_Response|string|trim) in ['Approved', 'Not Available', 'Not Required']and (a.Approv_Mgr2_Response|string|trim) in ['Approved', 'Not Available', 'Not Required']and (a.App
I am trying to create a dynamic report that will stay updated with our top 25 clients based on their ACV. I have a checkbox field on each account labeled 'Top 25'. My goal is to have this automatically updated based on each account’s ACV. Ideally this proccess would: Look at all eligible AccountsRank them by ACV from highest to lowestIdentify only the top 25Check the Top 25 checkbox for those AccountsUncheck Accounts that fall out of the Top 25Recalculate this automatically on a schedule The main issue I'm having is the Search Records step lets me set a record limit of 25 without giving me an option to sort the results by ACV. Because of that, I’m concerned that limiting the search to 25 records would not necessarily return the 25 highest ACV accounts. Any help will be appreciated. Thanks!
Wanted to see if I could get report records using JSON Fetch step. I get a response but there are no records in the response, just headers and metadata. Method: POSTURL: https://api.quickbase.com/v1/records/queryAuth schema: Quickbase UsertokenHeaders:QB-Realm-Hostname: yourrealm.quickbase.comContent-Type: application/jsonAccept: application/jsonGet a report.For future me.
In quickbase, I have a field for user and datetime. There are several project status like pending, submitted, review,approved and denied. Everytime in the status field change I want to record who did the change and date time. I want to use the two buttons. submitted by and submitted datetime field to track the audit history or logs. I did try with a pipeline but there is no data being recorded. Anyone done this before?
Looking to have a gauge chart with 0 entries being what good looks like. We are using it to identify action items for our team. As QuickBase won't allow you to have your start larger than your goal, and results displaying based on a percentage, it makes setting the colors for the gauge super challenging as well. Any suggestions?
Hi,Is there a way for my app settings to automatically default to 'open in the same page' when editing a report? I know how to change the setting within the field itself but not when editing a report record. This ends up with a host of tabs open in my browser vs. staying within the project record itself.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.