Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Table 1 - RequirementsTable 2 - Meetings For each requirement there can be multiple meetings, owned by separate sales rep.I already have these two tables, Now if SalesPerson_A has a Meeting_1 for Requirement_1 then an associated record is created in Table 2 - Meetings, but if the same SalesPerson_A has 5-7 follow up meetings for the same Requirement_1 then 5-7 more separate associates records are created and we have created a field dropdown - Round of meeting where we are manually managing, 1st, 2nd, 3rd, etc to keep track, then we are manually copy pasting the previous meetings links in the coming up meeting to access them. this is too outdated and time taking.Also SalesPerson_B can also have a Meeting_1 for Requirement_1 then another new record is created in Table 2 - Meetings n for further follow ups its same manual way.What i want to achieve is that if SalesPerson_A has a Meeting_1 for Requirement_1 then an associated record is created in Table 2, Called Record 1, then I can h
I've created a system where when a user clicks "Create New Agreement" URL button, a new record will be created that brings over key information, including the "predecessors" record ID so that the new record can capture that this previous agreement is a "predecessor". However, I'm trying to figure out a way on how to link the "predecessor" record to the newly created agreement as I want a user to actively see in the "predecessor" record that this work has already been completed. Any recommendations on how to do this? Thanks!
I have a parent table called principal investigators (PI) that has a child table called "applications". This is for external users to apply to a grant we are hosting, all the information will come through a form in the applications table. However, I want to pull information from the applications table into the PI table for future querying. Very simply, users will put in their name, email address, and departmental affiliations which I want to then create a record in the PI table if it does not exist. If it does exist, I want to update the applications table with the related PI record ID. I cannot get this to trigger properly and I have tried many times. It fails at the IF/ELSE statement. Here is my YAML file below if it helps (I removed identifying information): # Add PI to table## Account slugs:# - quickbase[DB]: Realm Default Account <None>---- META:name: Add PI to tableenabled: false- TRIGGER quickbase[DB] record on_create -> a:inputs-meta:allow_triggers: Any
Can a RESTful API be used to create lookup fields using a pipeline? Or, can anyone suggest a faster way to create 130 lookup fields for a use case in which I have 130 relationships between two tables (I need a new lookup field for each relationship)? I'm hoping to find a faster way of doing this other than manually one-by-one.
Hi,I have 2 tables, I would like to add a button in the form from the Accounts table that takes me directly to the related record in the Findings table. Both tables have the same Account ID field so I have created a table to table relationship between the two. I'm assuming I can achieve this with a url field with a formula that some how finds the related record in the Findings table by matching the account ID# but I have no idea what that formula would be. Please helpThanks
Hey Qrew!For my help desk application, I need to be able to change the record owner from time to time in cases where I add tickets on behalf of requesters.It was relatively simple in legacy forms to change the record owner at the bottom of the page, and I'm wondering if anyone has found a way to do the same in new forms.If I need to, I can still view the record in legacy forms and make the switch, but it is slightly annoying and takes extra time to switch back and forth between form styles and view modes.Also, I attempted to create a workaround by using a pipeline to edit the record based on an override field; however, I got an error back stating that the "Record Owner" field cannot be modified. I also tried to take the long route and use the QuickBase API_EditRecord, but I ran into walls that way as well. So, at this point, I am open to any suggestions.All thoughts are appreciated!
In a new QB app we created, we have a table "Phishing Attempts" where we want to create records by importing a spreadsheet. We also have a table "Targeted Users" which has employee info such as Employee ID, email, position, etc.Phishing Attempts table has a relationship with Targeted Users table, where we have the Employee ID field from Targeted Users included in the Phishing Attempts record form along with lookup fields that are automatically pulled from Targeted Users table.The spreadsheet we want to import to create new records in Phishing Attempts table includes an employee ID number. When we import the spreadsheet, we select the target field Employee ID in the Phishing Attempts form.The problem is that the Employee ID field in the Phishing Attempts form is not populating when we do the import. The ID number in the spreadsheet matches exactly what is in Employee ID in Targeted Users table.Is this not working because the Employee ID field in Phishing Attempts is pulling from Targete
I am using the formula below for a duration TAT. I have checked off the HH:MM:SS for the type and it is still displaying 0:00:00 for things that are one hour from rec'd to acknowledged time enteredDays(WeekdaySub(ToDate([Acknowledgment Date/Time]),ToDate([Communication Received Date/Time]))) Do you have any suggestions on how to get the TAT to display accurately?Thank youJill
Thank you to everyone who joined us for Empower Pro this month. I’m grateful for your time, your questions, and your curiosity. I believe that learning drives innovation. Picking up a new skill often opens the door to an entirely new way of thinking – and then, all of a sudden, you find yourself achieving outcomes that you might have never previously imagined. Changes like that rarely happen overnight, but they are profound and important. They can change how you work, how you see your own potential, and how you see the world. I hope those of you who were able to attend EmpowerPro learned a new skill, saw things a new way, or saw opportunities to help make your teams work better. As always, we are always looking for ways to connect and answer your questions. We also love hearing about your practical uses for Quickbase and how you’ve solved real business problems, inspired others, and found new ways of working. Or leave a question or comment below! That’s part of who we are, and who we’
I am leaving Notion for QB. I created an exact copy of my Notion database (it was pretty simple) in QB and exported the Notion data into CSV. I started the import and in the preview screen it looked perfect. But every time I hit "import" I get "Can not update built-in fields values." I can't find any simple solutions to this, just very complex instructions about API, which is a little beyond my skills! Does anyone know of a simple workaround? Thank you!
I have a parent table called Deliverables that pulls in the Project Name into my child table called Buy Out.In Buy Out, each project has multiple Scopes.Each Scope can have many line items over time, with a Date field that’s filled in by the user.What I want:A Table Report that groups by Project Name → then by Scope.Under each Scope, I only want to display the most recent line item (based on the Date field).So if Project A has Scopes Electrical, Mechanical, and Plumbing, I’d only see the latest record for Electrical, the latest for Mechanical, and the latest for Plumbing.What’s happening now:If I create a Summary field for Maximum Date, it only gives me the most recent record for the whole Project, not per Scope.In a Summary Report, I can see the max dates by Scope, but I can’t get all the other line item details.In a Table Report, I can group and sort so the latest is on top, but I can’t filter it to only show that one row per Scope.What I’m asking:How can I build a Table Report that
I have a form that has 4 sections, that I want to hide or show, based on the selections from two dropdowns.Conditions:If dropdown 1 = "Approval" & dropdown 2 = "A" OR "B" then hide sections 2,3If dropdown 1 = "Approval" & dropdown 2 = "C" then hide sections 2,3 and show section 4If dropdown 1 <> "Approval" & regardless of the value in dropdown 2, I would like it to hide sections 2, 3, 4How can I do this? by the time it gets to the third rule, it shows all the sections.
Is there any way to create placeholders for users intentionally?
Hi,I have a table of Account_Templates. It is a many to many table where many Templates have many Accounts. The Account has an associated lookup value, we'll call Question. Many accounts might have the same value for this Question field.I want my pipeline to search these Account-Templates and create a record on table Template_Questions. A new record should be created for only the unique combinations of field Template and field Question ([Template]-[Question]). My pipeline is currently structured as:1. Prepare Bulk Upsert to Template_Questions2. Search Account_Templates for all recordsLoop{3. For each search record found, add an upsert row where the key field equals "[Template]-[Question]".}Loop End4. Commit UpsertWhen I run this pipeline, I get an error of duplicate values trying to be created.Is there a way to trim the upsert of duplicates before committing it?Alternative ideas are welcome.Thank you,Curtis
Hi!Does anyone know if an app restore will also restore a sync table's connection?
Previously when you would grid edit child records from the parent, clicking save would redirected back to the parent. With the new grid edit, it no longer redirects you back to the parent. Am I missing something?
Hello, Is it possible for me to transfer quantity data on one record to another record? As an example, Record A has 10 laptops. Record B has 5 laptops. I would like to transfer 2 laptops from Record A to Record B. I've tried different methods, but I keep hitting a wall.
Me again.This is the perfectionist in me. I'd love suggestions on if it's possible (and how) to write a formula that calculates a person's age based upon DOB field, converts it into a category ("0-12", "13-17", etc.), AND ALSO where that field can apply the reference date based upon a report filter.So, if in the future I need to see a report and the age needs to convert to the date where it would be in the beginning of that date range (or even more ideally, if it can reference the first date of service within the filtered time range on a connected table and apply the rule as it would have been in that time frame), that way I can always see what we would have received as a report-out at that point in time if I needed to go back and spot-check something.I know that sounds terribly convoluted. It's for grants reporting, and honestly these are some of the items that get at some of the most obnoxious calculations we're asked to report out on...... If I can't make it perfect, no bi
Hi all! A daunting task I've put off forever is here. I need to build some dimensional reporting. Here's what I need to do:Extrapolate the following:Total individual clients served within a quarter, by the specific funding stream (upline from Interactions, Clients may be having multiple cases across multiple funding streams, and the stream is set at the Interaction level)Total individuals new that fiscal quarter for the fiscal yearIndividual client demographics (feeding from Client table)Individual client case victimization types (feeding from Case table)Individual clients who received any services across 4 service bucketsAnd then, the easy part, just a quick-and-dirty count of services by sub-category (about 30 of them or so)My table structure:Clients --> Cases --> Interactions > [Interactions Parent]: Funding Stream > [Interactions Parent]: Service LineWhat I have built so fa
We are trying to test out a new version of a form. Our testing group contains people from roles that all use different dashboards. Say we have 20 people in group 1 using dash 1, 20 in group 2 using dash 2, and 20 in group 3 using dash 3. We want 5 people from each of those groups to test out a new form.If we create a role that uses that new form, and move it up the hierarchy they'll get the new form, but they'll all have to share a dashboard. This is not something we can have them do. They need to continue to use their existing dashboards? When will we have the ability to set Dashboards on a per-user level instead of only on a per-role? And what is the reason behind not allowing that?I understand that in this current scenario our only option is likely to create 3 new roles, but that's silly, and starts to become impossible to maintain once we start needing to have others testing different forms and mix-and-match them from different groups. The most simple solution would be to allow per
Hi all. I have a timecards table where users track all the things they're working on. Relatedly, we have a separate child timecard table, with a narrower field list but otherwise the exact same records. This was done a while ago to reduce volume on long term storage of these records because we hit the table limit of 500 MB. So anytime a timecard record gets created or edited in the parent table, there's a pipeline that checks to see if the record has any related child timecard records. If not, it creates a new child timecard record with all the relevant fields populated. If there is already a child timecard record, it updates that child record with all the newest field values. Then as the last step (only for new timecards), updates the newly created child timecard record with the Related Parent Timecard value so it's easy to verify all timecards have exactly 1 child record. Other than being resource-intensive, this pipeline works perfectly fine most of the time. However, twice/mon
Have a timesheets table and it helps with accruing Paid time off.I need to implement a policy that PTO will max out at 160 hours in a running total field. The running total field looks like this:var text QONE = "{23.BF.'" & [Date] & "'}AND {56.EX.'"& [Related Resource] &"'}";var text QTWO = "{23.EX.'" &[Date] & "'}AND{3.LTE.'" & [Record ID#] & "'}AND {56.EX.'"& [Related Resource] &"'}";Min(160,Nz(SumValues(GetRecords($QONE),193)+Nz(SumValues(GetRecords($QTWO),193),0)))THE PROBLEM: When I use the Min function it doesnt calculate against the 160 value in the formula. If the balance is 200 hours, any subsequent line entries build off the 200 value although the table above shows 160. Here is the table without the Min function:When I try to change the formula in the PTO in the something likeIf([PTO BALANCE]>=160,0,[Hours worked]*[PTO Rate] I get an error that I cannot write a formula for a field that is based on its
Hi, I have this formula URL where the user submits all branch. when the user clicks the button it comes the chrome prompt of Leaving the site? (Picture below) This the code i have written in the formula url field: var text markCompleted = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&apptoken=" &"&rid=" & URLEncode([Record ID#]) &"&_fid_921=1" &"&rdr="&URLEncode( URLRoot() & "db/" & Dbid() & "?a=er&dfid=34&rid=" & ToText([Record ID#]) & "&page=15")$markCompletedCan someone help me fix this? **I have remove the token.
Hey Qrew!Question for your expertise.I have a request from my userbase to create a number of pipelines to help transmit a request from one app to another.The gist is, when a request in system A meets certain criteria, that request needs to be submitted in system B or C. The pipeline will take the request details from system A and distribute them to the appropriate system.The roadblock I'm facing is that I have site (name, company, address, etc) and site contact (name, email, phone, etc) data that needs to be brought over from system A into B or C, but none of the record IDs match between these systems. So if I use the pipeline and pull site record ID 10 from system A, site record ID 10 will pull something completely different in B and C. I need either a translation layer in each system, or if there is a way to universalize without ruining existent data, I would prefer that.As always, your wisdom is appreciated!
I have reached 90 Pipeline (triggers) limit for my table.I need to do more pipelines with that table, anyone has a workaround ? (I cannot turn off pipelines)Here's what I've tried so far:1- Zapier/Make : doesn't work because I cannot trigger a zap if a specific field was updated. 2- Consolidate pipelines: Doesn't work because I cannot set a condition of "what trigger caused this pipeline to fire)3- Look up field in another table and trigger the field based on that: Doesn't work, QB doesn't trigger workflows on lookup fields4- (3) + A formula field that dynamically sets the value matching the field on the main table: Doesn't work, QB doesn't trigger workflows on formula fields
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.