Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I that a Total field that needs to... 1st look at a Manual entry field and pull the value it if it is populated. Caveat, if 0 is entered in the Manual field then the Total needs to be 0. So I have taken the "treat blanks as 0" off the Manual field. 2nd if there is NOT a value in the Manual field, and Charge Filing Fee is Checked then apply Filling Fee to the Total. IF Charge Filing Fee is not checked then the Total is 0. Below is my current formula. The piece that I can figure out is if 0 is entered into the Manual field. If([Filing Fees - Manual]<>0, [Filing Fees - Manual], If([Fee Schedule - Charge Filing Fee?]=true, [Fee Schedule - Filing Fees (per Filing)],0)) ------------------------------Ashley Solomon------------------------------
Looking to see if it is possible to dynamically show/hide the address map on a form. I know I can modify the field on the form to not display the map, but that is an all or nothing option. Ideally I'd like to create a button that is "clickable" when viewing the form (not editing) which would, when clicked, either show or hide the address map. Considered having a checkbox in the background that is updated on button press. If box is checked, show the map, otherwise it should be hidden. Having the map is a nice feature, but it takes up a lot of real estate. Just trying to see if there is a way to allow the user to see a map when interested but otherwise it would be hidden. Is something like this possible? Thanks------------------------------Ember------------------------------
I have Parent Table (CM) where in Form I have imbedded child table record (CM CI Pair) to add data.I want to prevent users at certain point (when Status change to "Approved" to not be able to add new rows to this table and related it with Parent table record).Example: If CM [CM Status]=Approved, than cannot relate new "CM CI Pair". With Role setup I can prevent from Edition, but how to prevent from Adding related records? ------------------------------Adam Krzyzanek------------------------------
I have a Formula-Rich Text button in a row with some URL buttons and they won't align correctly Anyone else run into this or know how to fix?:Notice the middle button is higher than the others. Why!?------------------------------Jeff Peterson------------------------------
Hello, When I opened up my QuickBase tables today, I found that I only have a record's "Edit" icon/button available in any report I view. The "View" icon/button is gone. I made sure that "Allow viewing records from this report" is enabled, so that's not the issue. Has anyone seen this problem before? ------------------------------Christopher Job------------------------------
Does anyone know if there is a fix for this, or should I recreate my connected table?I have a master app containing our customer information. I pull information from this into other apps via connected tables.The connected table in one of my apps has added extra characters into the middle of the name field for some customers. My other apps are all OK.The P2P on the end is supposed to be there.Should read: FAIR FAMILY FARMS P2PReads: FAIR FAMILY FARMS LLCÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â P2P This customer is ok: WES SOLLENBERGER P2P ------------------------------Anne Martin------------------------------
So, I am trying to make it to where I have a submitter, and then an approver, and others can see it, but the only people who can edit the request is done by the submitter/approver. Do I need to create different roles for each approver so that X can change only requests with their name as the approver or submitter, or is there another way?------------------------------Michelle Craig------------------------------
Hi: I am trying to build webhook pipline where I need to supply a token that is returned from the request. The token is embedded in a long text string separated with delimiters. When I go to use this token, I am able to use a split jinja template to get at the "front" part of the token. {{b.content.split(':"')[1]}} However, there is another irrelevant text string after the token separated with a ',' Can somone suggest how I nest my jinja templates to do this and do I do another "split" or??? Please and thank you! Melissa ------------------------------Melissa Freel------------------------------
Hello. I have a multiselect text field 'Construction Plan - ASMT' with 6 values. I need to create a summary report to count the Construction Plan and the status it is in. Screen shot below. Without creating a child table for this field, can i create a summary report where the textlist field items are separated out? Today we are doing this in Access. Thank you.------------------------------Uma Harithsa------------------------------
I have several notifications and every time the notification gets emailed one comes from notify@quickbase.com and one comes from my email. How do I turn one of these off? Getting two emails for every notification is excessive.------------------------------Steve Venne------------------------------
Hi, I'm looking for some guidance on why the "Sign it" field on my app forms has stopped working. It used to be that you click "sign it" which took you to new window and allowed you to sign and submit, then returned the signature to the form. At the moment, the pop up window opens and allows you to sign but it won't allow submitting the signature and returning it to the form. The pop-up error I get is "Record ID, Field ID, or DBID not found. Please check the URL and try again." The code I currently have in the field is below: URLRoot() & "db/" & Dbid() & "?a=dbpage&pageid=2&dbid=" & Dbid() & "&fid=" & 28 & "&rid=" & [Record ID#] This code was added to the forms over a year ago and has worked great since but suddenly stopped functioning. If anyone has any input as to why the URL is no longer working, I would really appreciate your assistance. Thanks! ------------------------------Yasmin Boyrati------------------------------
Introducing Qrew Group Highlights, a blog series dedicated to highlighting a Customer Network or Community-led Qrew Group. Each month, we'll highlight a different Customer Network or Qrew Group. What are Qrew Groups you ask? BAM. Enablement link. Check out the upcoming Customer Networks on our Events page. If you want to connect with others in The Qrew, no better place to do just that than through Qrew Groups. Register for some events, share your successes, and see how others in The Qrew are winning with Quickbase. If you haven't had a chance to meet Senior Customer Success Manager Caroline Stuart-Freas yet, you're missing out. An American living in London, Caroline joined Quickbase in the spring of 2022, and just recently completed her first year at Quickbase. Her enthusiasm for her customers is evident every time you get a chance to speak with her. She goes the extra mile to make her meetings entertaining. Caroline oversees the Customer Network program, and serves as the admin
Introducing "Q Tips", a blog series designed for Qrew members to share tips with the rest of The Qrew. Q Tips are short and sweet. 5 minutes or less. The idea behind a Q Tip is there's something you do in Quickbase that makes your life easier, and you want to give access to this gold nugget to the rest of The Qrew. Do you want to submit your own Q Tip? Join the Champions Program and take the Q Tip challenge! I'll review all submissions and publish entries everyone in The Qrew can benefit from. What do you get? Points, badges, and the priceless feeling of knowing you made The Qrew a little bit smarter today. As a Tech Support Representative with over 6 years experience at Quickbase, Maria Peralta has seen it all. When's she's not maintaining her urban chicken coop and bee hives, Maria's crushing support cases, over 8,000 of them in her career. But what's one of the most common cases she sees in the Tech Support queue? Transferring apps. Makes sense right. Someone suddenly le
Does anybody have a quick solution to change to change form and then launch print dialog ? Tried combination of Magic buttons with no luck.------------------------------Trevor Kent------------------------------
I am trying to figure out a way if its possible to make a field that will generate a random four digit pin number. Is this possible in QB? ------------------------------William Hunter------------------------------
Is there a way to figure out what record was accessed by "de-coding" the Log ID? I am tracking a field for changes, however...without knowing what record it changed, it's not much help? example: this field changed, but on what record? Log ID ------------------------------BuildPro------------------------------
I have seen several posts where I can change the background and/or underline color of a tab within a form, but I'm wondering if there is a way to programmatically change that color.I am building an app for tracking our various insurance polices. Some policies will have multiple coverages each with their own set of data points, but some may only have 1 or 2 types of coverages. My form would be designed so that each coverage type would be its own tab that way it wouldn't be unbearably long for the end user.I was hoping to include a checkbox perhaps at the "beginning" of each coverage tab, that would be used to indicate if the policy has that coverage type. That checkbox would also be used in a calculated or formula field so that if checked it would change that coverage type tab to Green. That way, a user would be able to quickly identify which coverages were included as those that are would be Green while the rest would be white, or some other color.Is something l
Hi I am trying to set up a scenario. i have two fields 1> build complete = checkbox 2> actual build completion date = formula date.The expectation is when the operator checks the build complete, the date is recorded in the actual build completion date (field)I tried a few syntax's but i am unable to get the formula correct. Any suggestions?------------------------------kartik lakshmanan------------------------------
Hi,I am creating a form with a child table inside it and I want to be able to add attachment in grid edit mod but it seems that I can't...Any thoughts ?Thanks,
Hello,I have a pipeline running, which populates 300 line items when you click "Add new station" however, once the user creates new record, the child table is being slowly populated in the background. I would like to change the "Save and close" button to say "Submit" and keep the user on the same page instead of exiting out. Is there a way to do this so they can just refresh and have all the records at the same place?------------------------------Sunakshi Sethi------------------------------
Hello,I have two tables with parent and child relation. It is setup to create a record in child table with a single click on parent table record. One click in "add record" column of the parent table create a record in child table. Is there a way I can select multiple record and create a single record in child table. Most often I need to create a single record for single entry. But once in a while, we get bulk where all the entries in parent table are similar and will suffice with single entry with multiple ids/references. Thank you so much for your help. ------------------------------Tapish Bij------------------------------
I'm setting up an email notification and would like to have it sent to a customer based on a record being modified. Is there a way to do this? In the body of the message you can 'Choose fields & markers' to insert a field to display the info, if there was something like this for the email address...------------------------------John Kulakowski------------------------------
hello,I have two tables. parent named location has a field serial numberchild named equipment also has a field new serial number they are related by parent - Record #ID with a text reference proxy "location ID" to the child.the trigger is set so when i create / change a child record and i fill in "set" a new serial number I would like the parent serial number updated to serial number in the child..I have tried many options I can't seem to find out how to push the new serial number from the child to the serial number field in the parent table. thx-N------------------------------Nic M------------------------------
I recently learned from a QB Blog Post that if you add a user to a user group in order to give access to an app (rather than individual access), the app will not appear in the users my app page. In order to get it to appear, you must send a specific invite to the user. Once the users clicks the invite, the app is now shown in their my apps page.This is decidedly inconvenient. We have a master app that every new employee is granted access too. As soon as they are an employee, they are added to a master group, and have access to this app. However, this means they will not see the app until they are sent an invitation and click on the link. How to people handle this? Do you simply send invites to everyone and hope they click? Do you not use groups, and instead use all individual account access?------------------------------Mike Tamoush------------------------------
Hi all I'm trying to get the following json object to be assembled during a pipeline:{{{ "service":"CreateOrder", "site_Acc_id":"gausolar", "order_source":"GoSolr Test", "fname":a.name, "lname":a.surname, "email":a.email, "mobile":a.mobile_number, "wnumber":a.mobile_number, "email":a.email, "unit_id":"", "street_num":"", "street_name":a.premise_address, "region":a.area_of_install, "city":"", "suburb":"", "service_array":[ { "supplier_sku":a.system_size_sku, "roof_type":a.roof_type, "flat_roof":a.is_flat_roof } ], "instl_address":a.premise_address, "postalcode":"", "promocode":"", "sales_stage":"To
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.