Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I'm regularly importing 5k rows of data into various child tables. The data comes from outside my organization and uses their keys. My parent table uses the default rid as the key field and has all the foreign keys as just plain fields. The foreign keys are a wide mix of numbers or alpha strings or guids etc.Right now the process I put the data through is to use a pipeline on record create in the child table to search the parent table for a match on the foreign key, return the rid, and update the related field on the child recordAs an Example -- my employee, treated like a sales agent by the vendor, has an vendor provided agentid, and an employee ID I provided.Sale.AgentID Sale.RelatedEmployee -> Employee.RID Employee.VendorsAgentIDABCD 123 &
I know how to show a goal line in bar charts. A feedback ticket asked how to have two goal lines, as Monday-Thursday we have a goal of 900 patient encounters. But on Friday some clinics are open just half a day and the goal line suggested is 450. Is there a way to do this?------------------------------Bob T.------------------------------
I am not seeing much online on how to create a New Project with an existing Customer using a pipeline. We already have it set to create a new customer in Quickbooks when a new record is created in Quickbase; but I am not finding a way to add a new Project with our Job Number in it. Any advice? Thank you!Jennifer------------------------------Jennifer Meyer------------------------------
My client asked for a button that upon trying to save a record, if they left some selections as "no", a message would pop-up asking them either to confirm that is correct, or go back to the form and make changes. I know I can set up a message based on the selections in those fields, but giving them more than one button option I assume is going to require some special coding. The message would also need to list the fields that were left as "no".------------------------------Chris Swirtz------------------------------
What does User ID = 1 mean in the Audit Logs?------------------------------Adam Keever------------------------------
My pipeline is finding the record I want to update but it is not updating the reference field in the record as intended with the record Id# from the parent. Is what I am trying to do possible?------------------------------George Bramhall------------------------------
Dear Expert, Due to our business closing down, I would like to ask how to backup entire apps in QB ? I notice File attachments is not backup as well here. I would like to back up entire apps, along with those tables and possible attachments, dynamic rules and etc. Appreciate for you help if I can execute this backup in easy way . Thank you------------------------------Quickbase Admin------------------------------
Good evening,Do Builder Account users have access to the Quickbase JSON RESTful API? I'm trying to retrieve records from a table within an application I created using Python and the script is returning the following 401 error shown below.I've included the Python code that I'm currently using down below. If anyone has any insight to offer on this issue, it would be greatly appreciated.Thank you in advance for your time.Returned Error Message:{"message": "Unauthorized","description": "Invalid Authorization."}Python Code: import json import requests headers = { 'QB-Realm-Hostname': '*****', 'User-Agent': 'Edge/13.1058', 'Authorization': '*****'} body = {"from":"*****","select":[6,7,8,9],"where":"{6.EX.'2021'}","sortBy":[{"fieldId":6,"order":"ASC"}],"groupBy":[{"fieldId":6,"grouping":"equal-values"}],"options":{"skip":0,"top":0}} r = requests.post('https://api.quickbase.com/v1/records/query', headers = headers, json = body ) print(json.dumps(r.json(),indent=4))------
Im working with a multiple choice field named Status. There are 7 choices in the field. I'm trying to build a Pipeline that triggers when the Status field changes from a specific value to any of the other options, trigger a Pipeline:When Status is changed from Open, trigger Pipeline.I've been messing around with the $prev syntax and various conditions but can't nail this down. I don't want it to trigger any time other than when it goes from that specific Open status to something else.------------------------------Raymond Sakar------------------------------
Hello Everyone, I have used Formula URL in my previous notification and it works fine. But my recent Notification with Formula - URL button is not working as expected. Please help.Thanks,HR The Notification with Formula -URL link(working as expected) : The Notification with Formula -URL link (Not working) ------------------------------Hema Rajendran------------------------------
I've a formula field which is read only/non-editable on the form. Can you please advise how can we make it editable? or is there any other workaround?------------------------------Mrunali Kadam------------------------------
I may just be missing this but is there a way using the new Audit log administration function to filter, sort or search ?
I have a calendar report showing records for each day. Is it possible for the calendar to display all the records for a day and not show the "+X more" option at the bottom when, in my case, there is more than 4 records for any given day? When I click the "+X more" link it takes me to that day and again I have to click on "+X more" link to see all the records for that day. Seems like an unnecessary amount of clicks to get to the list of records for a day.Thanks,Brian------------------------------Brian Dunk------------------------------
We have ~80 Employees and need to keep a historical record of what jobs they have worked on. Crew assignments are made by entering a new record when an employee changes jobs so the only data entry per se is a new "Job" and new "Assignment Start Date." When a new assignment date is entered the old job assignment is complete, so I need to calculate the duration and end date (which is new assignment date, less one day) for the previous assignment record.I figured out a way to tag the most recent entry and after testing, it seems to be working as required. Now what I need to figure out is how to calculate the end date and elapsed days an employee was assigned to a particular job.------------------------------Keith Hendrick------------------------------
Has anyone noticed that on a two column sort with a text field and a numeric field that the sort order is incorrect? For example I am sorting on "numericField" and then on "Country". As you can see, in the image below, the sort order is incorrect. I filed a case with Quickbase and got this response:Good evening Claude,Thank you for contacting QuickBase support. I see what you are describing. Although, realistically speaking, normal applications won't have the country names you've input. I suspect the randomness of your country inputs is causing the issue (and likely the sorting is reading the Z in "IAMxEdvzZ". Are you able to replicate this same problem with real country names?Can you also please invite me to the application? I'd like to show this to my team for their input. ------------------------------Claude von Roesgen------------------------------
I have two tables 1) has agency names 2) has products. The agency table has summary totals for all the products which is good. I can view the agency table and click on the totals and get the related products detail. I need to be able to export a report that contains both the agency row showing with the summarized totals AND detail rows that make up the totals. Both tables have the same fields. Is there a way I can get both tables/details on one report?------------------------------Barbara Alvarez------------------------------
[SAND DATE STATUS]IF THE DATE IN [SAND DATE] FIELD IS "before today", display red status button, otherwise display blue button.IF(ToText([SAND DATE])<(today)),"<img src=\"https://images.quickbase.com/si/24/204-warning.png\" title=\"delete\">","<img src=\"https://images.quickbase.com/si/16/224-point_blue.png\" title=\"TO DO\">")------------------------------BuildPro------------------------------
Hello,I have 2 tables that separate projects from my internal team, and external team. I would like to pull a single report that shows both entries and information regarding the projects in both tables.However, it looks like I haven't found a way to do this. Can someone support me in identifying if this is possible?Thank you so much------------------------------Anthony Wong------------------------------
Hello,I have a table that contains my sales reps and their commission plans.Whenever I generate a project in my projects table, it links the sales reps' commission percentage to each project.I have a 3rd table (Costs) that calculates fixed costs on projects and calculates commissions related to this information. The look-up numeric field pulls the commission amount from the projects table.I'm trying to make the look-up field in Costs for the commission percentage be a snapshot, as contracts and commissions change, i can't have it affect older projects that were created during a different contract value.Whenever I change the field to a look-up field, the snapshot option disappears.Can someone help me with this? Thank You So Much------------------------------Anthony Wong------------------------------
Hello!I am trying to create custom department groups in one of my reports. For example. we have a department here called Production Team and another one named Sales Team. Both of these are part of the Market Division. We want to track sales volume within the Market Division. I don't want to create a new field for this, I just want it to appear in the report.Hopefully someone knows how to do this! I feel silly- it seems like it should be easy enough.Let me know, thank you!------------------------------Karah Weber------------------------------
I am trying to write a system that will allow a multilevel BOM. I can use a many-to-many table to allow the same part to be attached to many different higher level parts. I can write reports that show high level parts and all the parts that go into it, and reports that show all the higher level parts that a single part can go into. But, I don't know how to write a report that shows a high level part, the parts that go into it, and the parts that go into those parts, all the way down to the base level parts.In other words, a fully exploded BOM.Does anyone have any examples or can give me a general framework on how to generate that? Thanks in advance!------------------------------Edward Hefter www.Sutubra.com------------------------------
I've a field called output date which needs to be incremented by 2 business days per input datee.g. Input date + 2 business days =Output dateCan you please help with the formula that can do this calculation?My current formula for the output date field (([Input Date Date]+Days(2))) doesn't understand business days logic and directly increments by 2 days.------------------------------Mrunali Kadam------------------------------
I know I am overthinking this but I can't get it right. I am just trying to create a weekly schedule for employees. The week would start on Monday and end on Sunday. I'd like a devoted app I could go in each week and create a new schedule and then print. I'd do it in excel but I want the report functions in QuickBase. I want to easily be able to find out how many Sundays a particular employee has been off for example.Can someone point me to a good example app (I couldn't find one) or tell me the easiest way to do this?This stuff use to be easy for me but a stroke has slowed me down and I am a very small operation. Your assistance is so appreciated.------------------------------Rhonda Jones------------------------------
I am new to using the subtables in Exact Forms Plus. I am getting this error: ** ERROR - Invalid Format in clist parameter - First Character should be L or R **when attempting to pull the data from our Customer Database Table into our Jobs Table. For our Project Manager field which pulls from our Employee Database Table I am getting this error: ~dbid=bsc9i2rxf,qry={'6'.EX.[Mitigation Production Manager]},groupfid=6,hdr=ffffffffffff,align=l,noheader,ahdr=c,noborder,astl=l,clist=LT6:50~What am I doing wrong?I have also added a few screenshots so you can see what my subtable settings look like.------------------------------Jennifer Meyer------------------------------
Our admin support team wants to know when a record was last modified except if certain fields were modified. As far as I know: one way to track this is to use email notifications that fire if a record was modified except for certain fields there are fields that can track when they, individually, were modified, but we'd have to change almost every field in the table to that type of field, which we don't want to do ...but they want a field they can sort by in reports that reflects this. I'm not sure there's any native way to do this, or even if there is a 3rd party add-in that enables this, but I told them I'd post a question about this. Any ideas?Thank you!!!------------------------------Amber Pollard------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.