Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Moving into a new phase of our QB rollout. I have a report I want to make available as read only. I ahve done what I thought I needed to, but upon testing as a viewer, the "edit" icon is still available and when it is clicked on it takes the test user to an editable page. What am I missing? The report is below and some other applicable screenshots.------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
Hello! This is a two-part question: 1. I have a legacy form with an embedded report where my stores can click on grid edit and make their updates. After a calculated cutoff date, I don't want them to be able to edit anymore. I've added a section to appear after the cutoff date (and hide the editable section) with a report that is meant to be view only, but the report still offers the grid edit option. I know that grid edit ability is role based, but is there a way to cut it off at the report level? I can't shut it off at the role level, as some stores will have a later cutoff date and still need to grid edit. 2. Is there a way to separate grid edit from search and replace in a report? I want my stores to be able to grid edit, but not to search and replace. Any other creative solutions are welcomed and appreciated! Thank you.------------------------------Kimberley Ravizza------------------------------
Hi, I'm using Project management app as a model to create my new app. Each tasks in the template task have 2-4 help links attached to it, Hence I tried using Rich text field type to enter the question with link but when I use this field in grid edit report all the formatting details are displaying as below. So I updated my question field link to text multiline and trying to add a new field to add all the links associated to that question. Note: I have 400 questions to be added in the template table with overall 250 links in total. I tried adding links to formula rich text to show or hide links according to the QID but this makes the formula very lengthy and not sure if this an effective way. Please let me know if you have come across this kind of req and what helped the best. Thanks, ------------------------------Hema------------------------------
Hi there, Please be kind as I am very new at this :) I'm in need of sending an email to clients with a list of time entries for the month (up to the current date). I am trying to use Pipelines to accomplish this and can't seem to figure it out. Here are the basics of the setup: TABLE 1 - CONTRACTS Contract Name Status TABLE 2 - Time Cards Related Contract Time Card Date # of Hours STEP 1: Quickbase Search Records on Contract table (Query - a) Filtering by Status = Active STEP 2: Loop through records STEP 3: Quickbase Search Records on Time Cards table (Query - b) Filtering by Time Card Date between {{(time.now).replace(day=1)}} and {{ time.now }} STEP 4: Condition If Quickbase Search Records on Time Cards table is not empty STEP 5: IF condition is met, Outlook Send an Email (Action - c) Here is where I don't know how to get the records found from Step 3 into that email body. I would like to put the data into a nice html table format, but I just don't know how to l
Hi all, I've got a simple report that summarizes city population data by total, min, max, average, etc. All works well. But when I include a summary field with standard deviation in it, I get a ton of extra significant digits. How do I get rid of those? Thanks! Ry------------------------------Ry Marcattilio-McCracken------------------------------
I'm trying to set up a pipeline that will trigger when a Status field changes from "Inactive" to any other value. All I've been able to find is this thread from several years ago, that I can't respond to at this point: Pipelines - how to look at original value and new value of field? I have attempted two versions, {a.$prev_Status}='Inactive' and {a.$prev.Status}='Inactive'. Neither triggered when I updated a record. I have included a screenshot of my trigger setup, any idea what I'm doing wrong or another way to get the result I'm after? ------------------------------Amy Christensen------------------------------
How do I get certain fields to 'auto-suggest' information. For example, I input many phone numbers, but I use certain ones more often than others. How can I get my boxes to give me a drop down of frequently used information so I do not have to manually enter it everytime.------------------------------Lisa Gilmore------------------------------
I need help with a best practice on charting information, using data entered monthly. I will try and explain below...We have lots of data we track by monthly numbers. I have setup a simple table to allow a user to simply input the total number of events for that month. I would like to display these in a chart, based on FY, but don't really want the label to be 10-1-2023, as an example. I would rather have Oct as the abbreviation. I can't figure out how to do this and still be able to display in the correct chronological sequence. If I just use month names, I can only get them to display in an incorrect order. ------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
A Time of Day field lists from 12AM to 11:30PM. Can I create a formula that tells the list to start at 6AM? My employees are clicking 2:30AM when they mean 2:30PM. I'm trying to limit the options of AM time.------------------------------Jillian------------------------------
I'm trying to figure out why one text is white and one text is black when they both share the same background color ------------------------------Everett Patterson------------------------------
How do you restore availabilities and shifts that were accidentally deleted?------------------------------Dynette Burke------------------------------
How can one use quick base platform to get new clients and grow new business?------------------------------David Mensah------------------------------
I have a table that tracks inventory at our locations. Every 2 weeks we measure and report the inventory so that every 2 weeks there is a new record for the inventory. I'm trying to create a formula where the beginning inventory of one period (record) is always the ending inventory of the period (record) previous to the current. I have formula queries that return the result from the table itself and also lookup fields from a parent record, but I can't seem to make a formula that is not recursive / references itself, because by definition ending inventory formula is (beginning inventory - sales + receipts = ending inventory)------------------------------Brian Hunot------------------------------
Hello, I'm interested in integrating a Gen AI tool, like ChatGPT, into my Quickbase application. Is it feasible, and if so, what's the recommended approach for implementing this integration? ------------------------------DIPA PANCHALL------------------------------
I have data (Individual Units/Jobs) scrapped from builders' websites and want to import it into a specific table. I have built an "Import" table because I want my pipeline to check for duplicates before it imports into my "Units" table. The data that I scrap often is the same + new units. After checking for duplicates I want it to only import the unique or new units. Does anybody have a good reference to help, or know how I should build my pipeline? I assume I need to start with an import then run a query on the import table and the units table, and then create based on not finding any that match a specific field that is the "SKU" for the unit.------------------------------Ryan Broderick------------------------------
I followed another thread and was successfully able to create time blocks in a calendar report. However, because I created a new field for moving forward, I have thousands of records without any data in that field. I am trying to create a formula that states if the field is empty then add an hour from another time of day field. I had [Appointment Start Time] already and have created [Appointment Estimated End Time] (Both Formula - Time of Day fields) In the calendar, the calendar is based on a Timestamp field of [Work Order Date] + [Appointment Start Time] (Formula - Date/Time field) For the Calendar's "End Date" I will also use a Timestamp field of [Work Order Date] + [Appointment Estimated End Time] (Formula - Date/Time field) It will work - but brings me to the issue that I want to enter data into the empty fields of [Appointment Estimated End Time] so that all previous records still show within the calendar. I know this is wrong but I want it to read something like: IF (is
Moving on to my next application. We keep track of Adobe subscriptions so we can charge the proper departments. I have the table and such setup, I just need help with the Yearly Cost formula. I have a bunch of checkbox that can be checked to indicate which subscriptions a user has. I get a new yearly cost each year that I can use to update the formula. So my formula in plain terms, I just don't know formula syntax here yet. If field 1 is checked/true, add $1. If false, add $0. If field 2 is checked/true, add $2.If false, add $0 and so on. ------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
On mobile, if you have an address field there is an option to push the arrow or locate button, and it will open your mapping software and show you on the map. Does anyone know how to replicate this behavior with a code page and button push? I want my user to quickly be able to get to their maps but not necessarily need a random, dummy address field open in edit mode.------------------------------Mike Tamoush------------------------------
Hello All, I have a conditional dropdown that is working when editing a record from a report via grid edit, as well as when editing a record from the form where the value is already filled in. However it does not work when adding a new record or editing a record that does Not have a value already filled in. The Conditional value is on the form, yet the dropdown asks to fill in the conditional value first (which it already is) Anyone have a logical explanation/understanding of what's going on here? ------------------------------Dan Park------------------------------
I have 25 tables in one app. 22 are unused tables. They were previously used to track data but have since been migrated to another program. My currently used tables still have relationships to a majority of these tables that are not updated. Do these tables effect functionality for the active tables apart from the obvious missing data? Does it slow the program down? Thanks!------------------------------HP------------------------------
I have a table with a Date field called "Verbal Creation Date". This field is auto populated when a button is pressed. What would be the best way to auto populate a field called "Previous Verbal Dates" if the Name on the record matches on a new record. So in other words, if the name on the older record matches the one on the newly created record and the old record "Verbal Creation Date" field is populated, populate the new records field "Previous Verbal Dates" with the date in the old records "Verbal Creation Date" field. Thanks, Brian------------------------------Brian Dunk------------------------------
There are several fields in my table that are often "N/A". I would like these fields to auto-populate with "N/A" is blank or to be able to have a button that will turn these fields value to "N/A" when clicked. I see there is the "default value" feature, however this doesn't seem to work on records that have already been created. For this use case, the records are already loaded into the table with basic information and the customer is responsible for filling in the details, so the "N/A" doesn't populate on those already-created records. What is the best way to do this?------------------------------Kara Neal------------------------------
We recently switched to the new form and users are having issues deleting attachments. No form rules have been changed from the old form or permissions. We have found that the only way they can delete attachments is if we give them edit field property permissions. Does anyone know why this is? The only thing has changed is moving from the old form to the new form. ------------------------------Codi Smith------------------------------
Hi All, One of the largest hurdles that I have encountered with trying to deploy Quickbase solutions in Australia is the policies/restrictions around data storage overseas. I am wondering if anyone has also encountered this problem and if there are ways to still supply support with Quickbase to these types of situations?------------------------------Josh Hamilton------------------------------
I know for years getting this information has been almost impossible. I wanted to see if there has been any updates. I need to be able to pull back the user role of a user listed in a user field. I do not give my users multiple roles so it will only be one. Is there any way to do this now without having to create a new table to house the information?------------------------------Carol Mcconnell------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.