Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I'm trying to set up a QA audit table with an accompanying form for staff to evaluate medical records. The problem I'm running into is both the auditor and the person whose record is being audited are employees and thus their names come from the same field of the same staff table. I could go the cheap route and make one of the 2 fields on the form a text block but I'd rather not. Is there a way to have a form pull 2 different names from a related table instead of locking on one?Thanks in advance
I'm looking to help to create a formula for a field REQUESTED LOAN AMOUNT that I am looking to have a formula based on the following logic.I have a list that users can choose. Transaction TypeAcquisition, Refinance, SupplementalThere is a radio box Loan Req Input - the user selects one either LTV or Loan Req $ Input.The formula I’m looking to write looks at the selection Transaction Type and then to the Loan Req Input and performs the calculationIf Acquisition and LTV selected, then multiply Acq price * LTV Request Input, if $ Input then use the $ Loan Request Input If Refinance and LTV selected, then LTV Request Input * Value, if $ Input than use $ Loan Request Inputthe same is for supplemental like the refinance.Thank you,Eric
Does slist and option=sortorder work within formula queries?In my formula query my items return the correct values but the sort does not work. Also does num-# work with the amount of records you want returned.var text Query ="{27.EX." & [Order Type] & "} &slist=3&options=sortorder-D";------------------------------Tyrone Grey------------------------------
Hello, I really enjoy the new features of the 'build your own' notification. More specifically, I think the ability to choose the 'record changes' element is very useful.A couple questions popped up in my head as I started using this:1. What feature allows this ("this" being 'record changes') element to exist? I assume it is some sort of API? Second, can this same 'record changes' element be utilized in pipelines somehow? I know I can do it with jinja2, I've done it before, but it is cumbersome and time-consuming. If there is some type of shortcut I can use I'd love to learn
Hello,I was getting this error when selecting a name from a lookup field on my form. I am now getting this error when i check a checkbox. I don't have any conflicts with my rules and I have not been able to find any information on this error. Is there anyone that can help me?
One of my co-workers is not able to use a button I created to populate a report. How do I give her access to create a record on this report? She is getting the below error.
Is there a way to create a table-to-table relationship that you can use with a multiple-choice field?For context, I am trying to create an inspection form that pulls questions from another table based on the equipment that is selected at the top of the inspection form. The questions on the inspection form need to have a "Pass" or "Fail" option, hence why I would like them to be multiple choice. Or if there were some formula that would do something similar, that could also be helpful.Any feedback would be greatly appreciated!
I have a table that is for "jobs", which has a one to many relationship with the "daily job updates" table. I have a formula - duration field on the "jobs" table for the # of days that a job was in progress. I also have a # of daily job updates field as a summary field in the "jobs" table. In practice, for every day that a job is in progress there should be a daily job update. So at the end of the job, the # of days in progress and the # of daily job updates should be the same.I need a report that tells me how many jobs didn't meet this criteria and how many daily job updates were missed. My thoughts were to just make a formula - checkbox in the background that if( ([# of days in progress] - [# of daily job updates])>0, true, false), and then a formula - numeric that is just [# of days in progress] - [# of daily job updates] to list on the actual report drilldown.Is this the best way to do this, or am I going the more difficult route?
I have a table for submitting and approving change requests. My table has a submitter role and multiple user roles (one for each approval function so that their access is limited to modifying only the appropriate field). Due to some complex approval requirements, different request types have different approval requirements, so when the form is submitted, a form rule changes the status of certain approvers to "not required." In order for this rule to work, the submitter role needs modify access to the approval fields. That works fine except for the few cases where someone in one of the approval roles also has a submitter role. In this case, the access permissions "overlap" and these users have access to change every field. Does anyone have suggestions on how to manage this? I've tried having different forms for different roles, but again the overlap between roles prevents this from being a workable solution.Thanks in advance!Chuck
Hi Community,As a part of inhouse automation that we are trying to achieve we are utilizing API capabilities of Quickbase to read/write data to QB tables via Alteryx tool.The Alteryx tool has a desktop version and gallery/server web portal.The Alteryx workflow works perfectly even now with desktop version but has starting to fail out on when ran on server portal since July4th post a MS patch to our server. Error Message: "Error Transferring data. Couldn't connect to server". Seems like the connection is failing.Not sure if any of you has encountered similar issue or would know anything about it. We are working for Alteryx support on this but meanwhile wanted to post here for inputs.Thanks in advanceParas Goyal
I have a field that is using a table for a drop down of a list of companies. When saved the company is displayed as a numbers. However, when that field in included in some reports, the field is alphabetical. I am sure this is a easy setting somewhere, but I cannot find it. Any help would be appreciated.
Hi,In a Quickbase pipeline, I need to fetch a single record from a table. That record needs to be the newest record added to the table. I tried two common approaches but neither seems possible using "Search Records" or "Lookup Record" steps: - Filtering so that Record ID = "MAX(Record ID)" - Sorting by Record ID descending and limiting results to 1.Any help would be appreciated.Kinds regards,Uri
I need a some formula help to show the results of a checkbox summary field. If the checkbox result is yes, then I want to show the message 1" or more Invoices is missing our Cost!" and if the result is no "Our cost is up to date"I a drawing a blank so any help is appreciated!
Hi!I'm creating a gauge report that shows the percentage of POs Invoiced/Current Project Budget (aka Percent Consumed). This report is going on a dashboard that has a dynamic filter for Project Priority. After lots of trial and error, I decided to create summary fields in a parent table called "Universal Reporting Record". The summary fields specify the percentage for each priority... 1, 2, 3 and the combination of all three as All.I am then using a formula in the gauge report to specify which Percent Consumed field should be used depending on the priority:The percentage for "All" should be 13.4%, but it continues to show 17% and I cannot figure out why. The other priorities (1, 2, and 3) show correctly as the dynamic filter is changed. The calculation is done on $s Consumed/Total Budget. These are the same fields used in the summary table mentioned above, just different labels for the dashboard.Here are the results for Project Priority = 1 which are
Hello,Why do the new Quickbase custom email notifications send separate emails to each recipient instead of a single email to all? Also, why can't I CC roles and have to specify individual users? If custom notifications can't achieve this, is it possible in Quickbase at all? I've also heard that the Outlook channel pipeline can't add field markers to emails, which feels very limiting.
No changes to already existing pipelines can be made, most pipelines are related to creating or updating records.Changes in fields or field assignments result in the error "Check your entries and try again or contact Support". Refreshing the schema results in the error message "Schema refreshed with errors". Exporting the YAML for an existing pipeline and importing to create a new pipeline results in an error preventing pipeline creation. I can create a new pipeline from scratch and make changes.Possibly related - we made a change to force UTF-8 encoding just before the pipeline issues started happening as we started having certain characters being replaced with ? or the code for the character in our records.
Do you want to display in a field the result of a search in another table (child table)? Watch the video.Do you need help or advice? Contact me: marbentor@gmail.com Yuotube Video Here......
Hi,Is it possible to create multiple child records automatically based off of a quantity field in the parent table?For example - A new parent record is created and the Order quantity field in the parent record is 25. I would need 25 new child records created.Second nice to have feature would be that each new record has a component number assigned from 1-25.------------------------------Allison Corriveau------------------------------
Hi all!I am playing around with some options for my team in a new workflow. We have a Companies table that has all the known Companies. We will also have an Orders table that brings in information from online orders. The idea is to match each Order Record to an existing Company Record. (Each Company can have many Orders).What I would like to add, if possible, is a button or way to Add a new Company Record using the information in the Order Record (Company Name and Address) without having to retype all that information.Any recommendations?
When adding a Report (table) to a Dashboard -- the report is not displaying correctly (appears "squeezed"). The Report also does not "expand" when resizing the widget. Also, for many of the columns I have the "display without wrapping" checked for the field --Any tips or tricks (workarounds) -- for this?Thank you
Hi folks,I am trying to create a database of regulations and the app keep dropping the trailing zeros. However, for my purposes, they are critical. In world of regulations, 820.1 is different from 820.10 and 820.100.Thus, I can't just tell it to go to three decimals or those will all look the same.Is there a way to do this?
Hello AEC Qrew! Planning to attend a few conferences in-person this August? Come say hi to the Quickbase team at these AEC-focused conferences this August: AGC Technology Conference August 6th-8thChicago, ILSay hello to the Quickbase team at booth #13 and join us at "Bootcamp #2: Blueprint to Digital: Empowering Construction Professionals with Citizen Coding." Rob Salaj, Customer Advisor - Construction, will be hosting a bootcamp workshop along side Jeff Sample from Ironman of IT LLC. In this workshop, you'll learn to define real-world construction problems suitable for digital solutions, structure data effectively to reflect construction processes, and develop a simple application using no-code platforms. Ideal for anyone looking to simplify their workflow through technology, this session requires no prior coding experience. Participants will leave with a clear understanding of problem identification, data structuring, and basic app development, enabling you to embrace the role o
I need assistance with setting up a pipeline in my Quickbase app to aggregate data by month. This will be the first time I've used pipelines.The tables involved are called:APP Credentialing Table: This table contains the raw data I need to aggregate. Namely, 3 date fields. APP Date Summary Table: This table is where I want to update the aggregated counts. It has 2 fields. Month/Year (text) and Count (Numeric). Specifically, I need to:Retrieve and filter records from the APP Credentialing Table.Group these records by Month/Year and count them.Update the APP Date Summary Table with the aggregated monthly counts.Could you please provide guidance on how to configure the pipeline to perform these tasks? If this even can work. Thank you!
I have a pipeline where I send a webhook "Get" request to an endpoint and it responds with an array of JSON records. My question is how do I iterate through those records?For example, the array contains two values: ID and Name. As the next step in the pipeline I want to search my table to see if the ID already exists and if it does not create a new record.
We are trying to build an inspection form for clamps that are used throughout a manufacturing plant. There are about 100 clamps in total. Each clamp is inspected with the same 11 questions, which can have one of three answers (Pass/Needs Repairs/Fail). The clamps are divided up by areas throughout the plant, so each area's current paper form has anywhere from 5-15 clamps. Each clamp is also assigned a unique serial number, and one of five model numbers.Is there a way to set this form up so that by selecting one of the 13 areas, we can answer all 11 inspection questions for the applicable area? Ideally all personnel throughout the plant use the same form which filters out only their applicable area and respective clamps.We have tried using lookup tables by creating a table with all clamps and their associated serial #, model #, area, etc. and have run into issues with getting the questions to populate as a multiple-choice field in the inspection form.Any help would be greatly appreciate
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.