Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
On August 1, 2022 we are going live with quickbase.com/account. Our new accounts page will be your hub for making changes to your Quickbase plans and entitlements (upgrade, downgrade, cancellation). Don't worry you will be able to access this new hub from right inside of your Account CSR, in the same place where you have been accustomed to making changes. With the new process, we will walk you through gathering the important information for your change. Once we have collected all the important details they will be sent to a representative who will help you through your changes. Ensuring that you’re on the right plan and entitlements for you is our priority, so we want to make sure you have the human touch. No changes will be made to how you manage your user access, apps, permissions, in your Quickbase account. We understand that this new process may be an adjustment from the previous workflow. If you would like to make any changes in the old sy
Is it possible to integrate comment boxes in forms allowing us to tag Users by @mentioning them? ------------------------------Paymon Eskandanian------------------------------
Hello!I am currently building a quickbase database and would like to display duplicate records when a user enters an employee ID in a lookup field. This display is just to alert the user that this employee already has multiple records in the database, nothing will be done about it. It is just an FYI. I came across formula query and tried to modify GetFieldValues(GetRecords("{6.EX.'"&[Manager name]&"'}"), 10) to fit my needs but the syntax error kept saying something like "expecting text but encountering textlist." I am not a coder and would really appreciate if someone could guide me on how to set this up. Thank you!!!------------------------------Nicole Bruun------------------------------
The filter for the District Name column is a drop down that the user can choose a selection from whereas the Division ID column the user types in what they are searching for. How would I go about changing the Division ID column to a drop down?------------------------------Jennifer Hall------------------------------
Hey everyone,QuickBase typically bases the "+ New" form on the main form. Is there a way to create a unique (i.e. greatly simplified) +New form? Doesn't appear to be an option in the form editor.Thanks,Rick------------------------------Rick Satenstein------------------------------
Does anyone know the correct syntax to check if a field equals a certain text string?This checks if the field is blank:{% if a.fieldA is none %}If I want to see if FieldA ="test", does anyone know the syntax?Ive tried the following with no success{% if a.fieldA==test %}{% if a.fieldA is 'test' %}------------------------------Mike Tamoush------------------------------
URL to identify the app has cross app relationship? I have used once but i missed it.------------------------------Murali Lokesh raja------------------------------
Hi,I noticed one of my rule has been modified automatically. Field name in the action section has been changed. I'm not sure in which cases does it happen? Please advise.------------------------------Mrunali Kadam------------------------------
I have a handful of places in my application where a user needs to approve something, however that user is doesn't have access to the area where the approval is captured so they want to be able to send an email where the user can just click a button or even a link is fine that will just change that field in the record to yes or no without them having to navigate them to the actual record?Also, if a file attachment is sent via email notification, the user should be able to open that attachment from the email correct?------------------------------Chris Swirtz------------------------------
We have a parent table - Projects.And a child table - Vendor InvoicesWe have a button to create a Vendor Invoice record from the parent.We often receive vendor invoices that cover multiple projects.We currently have to go into each parent and create these records separately.Sometimes this can be dozens of projects at a time, so it is cumbersome and time consuming.Is there a way to create multiple child records and have them reference the various parent records that they need to reference?------------------------------Vonda M. Hall, CPAChief Financial OfficerMercury Tech Partners, LLCwww.mercurytechpartners.com ------------------------------
I have a from using IFV=1 to limit standard controls. I want the user to be able to print before they submit the form, and when I start this process the record is in edit mode. Here's how I attempted it:var text URL = URLRoot() & "db/" & Dbid() & "?a=dr&ifv=1&printr=&rid=" &[DSR ID#];"<a class='Vibrant Primary SaveBeforeNavigating' data-replaceRid=true \nstyle=\"text-decoration:none; background: #0863f5; border-radius: 5px; color: #FFFFFF; display: inline-block; padding: 4px 4px 4px 4px; width:140px; \ntext-align: center; \ntext-shadow: none; \nborder: 2px solid #0863f5; \nfont-size: 12px \"href='"& $URL& "'>Print DSR</a>"I tried putting the printr function towards the front like this, and it says "access denied" var text URL = URLRoot() & "db/" & Dbid() & "?a=printr&dr&ifv=1&rid=" &[DSR ID#]It does the same with display record first.var text URL = URLRoot() & "db/" & Dbid() & "?a=dr&printr
I have a webhook setup using the HTTP Json PUT request to update a value in a specific record of a 3rd party system, TopDesk. The body contains the change data instruction. All works well when I specify at the end of the URL the search value. Instead of using a hardcoded value entered in the pipeline I want to use a field value from the record that triggers this pipeline upon change. Can someone help me how to code the table & field name properly in the URL to make this work ? thank you ! https://ark.topdesk.net/tas/api/incidents/number/I076116------------------------------Waldo Remijn------------------------------
I want to trick QB into grouping and sorting alphabetical, except for one category that I want to always be last.My only idea is a formula rich text that lists the categories, but for the one unique category add a 'z' on front but make that z white text color and like font size 1. Then group and sort by that rich text field. Anyone have a more elegant solution?------------------------------Mike Tamoush------------------------------
HelloAll, I am looking for a way to have an option, either a button, report or maybe a pipeline that is like a grid edit that already has come field filled out. If you were to use the button idea, you would hit the button and a grid edit report would come up. When it did it would have all 28 of my products filled out plus 2 other fields and allow the user to then fill out the remaining field on the report. They would hit save and all 28 product orders would then be added to our list. My list of products is in another app but I can easily add a sync table to the app where the orders are for ease of connection if needed. Basically when we get a new customer, we have to enter in orders for all 28 products and just looking for a way to save the team time as grid edit only has 5 rows to start and adding rows and the copy/paste gets tedious. Any help is appreciated. Jen------------------------------Jennifer Silberstein-------------------------
I'm working with a pipeline that will retrieve a JSON object using a webhook. I would prefer to do some logic in the pipeline rather than creating several new fields in the table. In a few instances the JSON will have values in one of two related fields. If they are able to scan a barcode there will be a value in the scan field, if not there will be a value in a related text field. Here's the question, will the Jinja below yield the output discussed above:{% if a.scan_value <> "" %}{{a.scan_value}}{% else%}{{a.text_value}}{% endif %}------------------------------Paul Peterson------------------------------
I want to remove the ability to check a box on a report and be presented with the option to delete. I don't want to do this everywhere, but just certain reports which are only intended to be a visual display on a from to represent data in a child table.I'm not looking to disable the ability of a user or a role to delete that record. I just don't want them performing that action from the particular report.------------------------------Wade Myers------------------------------
Does anyone know if a QSP who has an add on or custom code which can compare two text fields to highlight changes? I have a client who is essentially looking for functionality similar to what Word can do in comparing two documents, except in this case it would be to compare the "before" and "after" values in two fields a child table which is an Audit Log of changes to a particular tracked field on a Parent table.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------
I have a 'On New Event' pipeline to create a record in a Review Log table triggered on a change to a checkbox field - either checked or unchecked. If the checkbox is checked, the Approved field in the Review Log table should read 'yes'. If unchecked (was checked), then it should read 'no. However, it is reading 'no' for both checked and unchecked changes. I found the Jinja code somewhere but am unable to find it again so can't compare if I'm missing something. Here is my code for populating the Approved field with the pipeline during the Create Record step:{% if a.review_food_security_approved == TRUE %}yes{% else %}no{% endif %}So if the checkbox is checked, it is still recording a 'no' and I don't know why. What am I missing in my code?------------------------------Amy Gosz------------------------------
Hello! I am admittedly new to quickbase. I am having problems with my formula in a table not working. (10^(6.67956-(1002.711/(((Average([Return bend Temp 1],[Return bend Temp 2],[Return bend Temp 3],[Return bend Temp 4])+459.67)*0.145)-14.7))))-[System Discharge Pressure] "Return Bend 1, Return Bend 2, Return Bend 3, Return Bend 4 and System Discharge Pressure" are all user inputs. For instance, if I enter:RB1 = 80.8RB2 = 80.4RB3 = 80RB4 = 80.6System Discharge = 140This should yield: 1.161Am I inputting the formula wrong or missing something? Using the wrong nomenclature?I worked this formula out in Excel first and verified it works then transferred it to quickbase:=(((POWER(10, (6.67956-(1002.711/(((A2+459.67)*(5/9))-25.215)))))*0.145)-14.7)-D1Any help is appreciated! Thank you!------------------------------Nick Van Laar------------------------------
Hello,I would like to create an app with 2 main functions:1. Request Price2. Answer to price request.You will see my app structure on picture "Capture.PNG".You will see the interface of "Request Price Form" on picture "Capture1.PNG".You will see the interface of "Sourcing Answer Form" on picture "Capture2.PNG".You have the list of all filed of "Request Price" table on picture "Capture3.PNG".In a nutshell, I would like to setup the "Status" field from table "Request Price" to change the status automatically to "Completed" once there is at least one "Sourcing Answer" Submitted for this specific price request.I tried to do it myself by using Formula Rich Text field with the following code but it does not work (picture "Capture4.PNG"):If(IsNull([Sourcing answers]), "Pending", "Complete")But it does not work as it show alaws "Complexe" even when there is not sourcing answer done for the Sourcing request (picture "Capture5.PNG").Your help will be greatly appreciated. Thank you in advance.Ant
Hello all, I'm fairly new to QB so I apologize if this is a stupid question. Here is what I'm trying to accomplish. I have a list of dates and I need to capture dates within a 6 week time span. In essence, I want to be able to highlight events happening from now through the next 6 weeks, not including ones that have already passed. I first created a checkbox field which worked and would check the box when within that timeframe but didn't drop off past events. So I created this formula: If([Date]<=Today()+Weeks(6),"Current",[Date]<Today(), "Past",[Date]>Today()+Weeks(6), "Future")The current and future work great but the past still isn't working for those dates that have passed. Open to any and all suggestions!------------------------------Annalise Sansouci------------------------------
Is there a way to remove this text from a multi-select drop down?------------------------------Rachel Capiral------------------------------
Here is my Loom Video explaining my issue with SimpleText to Quickbase using Zapier Video: SimpleText to Quickbase------------------------------Jennifer Meyer------------------------------
I'm going through the Pipelines Certification track in University. I noticed that "Managing Pipelines in the My pipelines Page" hasn't been updated to reflect the new experience. For certification, I want to make sure if questions are based on this old experience that is outlined in university? When I roll out something new, I make sure to update process documents and training before going live. I would hope this would be the same with Quickbase, but it doesn't seem to be. ------------------------------Dwight Munson------------------------------
Greater New Orleans & Baton Rouge TCS has offices in Baton Rouge, Metairie and Mandeville.Selected candidate will be able to work from any of these locations.The Program Management Systems Developer ("PMSD") is responsible for building,implementing, and maintaining QuickBase applications, dashboards, and integrations around custom program and project delivery policies and processes; often using scripts, APIs, and third-party integration tools along with native QuickBase functionality and web applications. The PMSD will work with senior TCS staff, subject matter experts, and external clients, helping to translate desired outcomes and processes into action, while ensuring performance, integrity, and security of the database. Please see attachment for more details. Please Direct All Inquiries and Resumes to Traci Cougle at: tcougle@teamtitlellc.com------------------------------Gregory Kelly------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.