Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I have a form that people use to submit data. The due date for the submissions has passed and I would like to add a message that "We are no longer accepting submissions" but I don't want to remove all the elements from the form in case I need to reuse or someone decides to reopen the form. What is the best way to notify someone when they click the form link that the form is closed and we are no longer accepting form submissions? Thanks, Brian ------------------------------Brian Dunk------------------------------
Hello! I am creating a notification and am wondering if I can change the hyperlink listed in the notification into a button. Is this possible via a rich-text formula? Please let me know!------------------------------System User------------------------------
Hi, Here is my issue. I have many reports that I would like to filter on [BP.PM] as the current user logged in. In addition, I need other users to be able to see the entire report, when they are logged in, without the [BP.PM] filter. Story...I have multiple Project Managers [BP.PM] so I only want them to see their assigned projects. BUT, several other ROLES/USERS need to see the entire report. For example: Roles/Users that need to see entire report: ADMIN, ANNETTE, GARRYD Do I need a MASTER REPORT that does not filter on [BP.PM] in addition to the filtered [BP.PM] report? ------------------------------BuildPro------------------------------
I'm trying to add a report formula and the formula is based on a multiple choice text field. It's simple, I'm trying to just pull the ones where there is nothing in the closed reason field. I can't seem to get it to work. This seems like something I should know but I can't figure it out. Thank you.------------------------------Carol Mcconnell------------------------------
Hi,I'm getting this error when I try to add a connected table. I'm not sure what to do.------------------------------Fatima Khan------------------------------
Hello... I am trying to enter Street 1, Street 2, City, State, Zip from one app's address field to another app's address field and get the error below. The pipeline is set up correctly and runs fine when I don't include the address fields. I am using the individual sub fields.This is what I get...has anyone else? "Validation error: Incorrect template "{{a.address_city}}: expected token 'end of print statement'. got 'Address_city"I don't see that error in the Troubleshooting section of Pipelines Help.Thanks!------------------------------Heather Bryant------------------------------
Edit! I think I've figured out the answer to my problem here, which is that it isn't a problem because the filters only 'save' for me, and everyone else sees what they're supposed to. Ignore! I've created a dashboard that allows users to access various pre-filtered reports, along with one that will display all records in a table. Some of those reports also have dynamic filters so users can find what they're looking for easily. I have everything set up so that the majority of users can't edit common reports. However, that means that those of us who can edit them frequently access reports, filter/search to find specific records, then forget to clear/reset our filters/search terms before we exit. Is there a way to automatically reset dynamic filters on exiting a report, so that anyone who opens it later won't find that it only shows certain data (and then contact me to ask why they can't find XYZ)? ------------------------------Michelle L------------------------------
Hello, Usually, i use a formula query to identify duplicates for a specific field but on this one table, it has over 500k records and the query cannot handle it. Have you guys find another solution in finding duplicates? I was hoping to mark the individual records (formula-checkbox) to see which records have the same info for the same field. thanks!------------------------------Tim D------------------------------
Good evening all.. Have a multi select text field (over 1000 selections (suburbs)) so I cant mark the field as MUST BE FILLED IN. I created a field using a formula to test if multi select field was filled in or not, with N/A the result if not. Split(List(" ; ", If( [TEST NEW SUBURBS]=null, "N/A"),If( [TEST NEW SUBURBS]<>null,ToText([TEST NEW SUBURBS])))) That marks another field N/A if this the Multi select field isnt used. SO i then tried to create a form rule that creates a pop up should the formula field say N/A but nothing pops up and the form saves... Any thoughts on this appreciated.... ------------------------------damien page------------------------------
Please help me understand how to push and pull data from QuickBase to Database. I'm trying to analyze if the data flows to QB and updates the backend tables. ------------------------------Nandini V------------------------------
I would like to find all records created 3-4 hours ago. How would I do it? Here's a few examples of what I've tried already ------------------------------James van der Walt------------------------------
Hi, I have an app that contains four related tables. One of the common relationships amongst all of the tables is a list of employees. One of the tables generates a report that groups the employees to create a summary report of numerical data generating a total for each employee. Here is my problem. I want to use the report generated group value for each employee from the grouped field in another table, but can't figure out the methodology to do it? I know I can generate a summary field in the parent table, but this is a total of all records (of all employees). I want to break this down to collect or calculate the total for each individual employee and apply it to existing fields using the same employees as it appears in the child table. Anyone have any idea? Thanks Jeff ------------------------------Jeff Rogerson------------------------------
Hello there! I'm really new to Quickbase but I'm learning VERY quickly. I need to create a report that only shows employees who are 30 past their separation date and I'm trying to figure out report formulas. I cannot get anything that doesn't have some part of it that returns an error. I'm well versed in Excel and I'm getting the impression that these formulas are not the same. Can anyone help me out with a formula for this type of return? Thank you!------------------------------Hannah Engelson------------------------------
Hi TeamThe solution is attached to this link, however I am just a bit confused about the last two steps in the process -1. Custom Role Permission - where exactly is this set up? what table is this set up in/2. One Role - "Users who are limited to their own department" where is this role created Your expert assistance appreciated.------------------------------Jessica Matenga------------------------------https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=ddb9bf43-a4cb-4db0-bd0b-48e97453b911&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer
I searched the board and didn't see anything that fell into this category so here is what I am trying to do..... I have a table that gets wiped out and then repopulated once a month by a .csv upload. One field in that table is called "Category". The number of distinct values in the "Category" field can vary between each upload, depending on that particular data set. One month, I may have distinct values of: 'Cat 1', 'Cat 2', 'Cat 3'. The next month, it may go all the way up to 'Cat 10'. Each month, I also want to generate .csv downloads for all records in each distinct "Category" value. If the number of distinct "Category" values was the same each month, I could hard code a pipeline to do this. But since the number of distinct values varies each month, I am unsure how to make this happen within Quickbase. Any suggestions will be appreciated. ------------------------------Aaron Bab1692@att.com------------------------------
So I have email notifications for one of my apps I am working on. So when I, the email owner, triggers the conditions for an email to be sent, it does what it is supposed to do. The issue is when an user triggers the conditions of an email to be sent, it does not send the email. Does anyone understand why this is happening and/or how to fix it? Thank you for your time and response.------------------------------Ryan Green------------------------------
Okay so this one is a big problem for me. I have created an app for the electrical side our company and during beta runs today I have found a very big problem. The code below is for a clock in button that I created that through other mechanisms can tell if the user is late, clocked in on another job, early, or on time/within a 10 minute window. Long story short one if a user hits the button 5 times quickly it will clock the user in 5 times. Is there some way to find the previous state of the button or see if the button was clicked so I can allow them to only clock in one time? I need some way to remove this error if anyone can think of something here. //This code takes the job and user record number and places them in the related fields to associate them together. Also, if the user is already clocked in and attempts to clock in again this will show a prompt letting them know they are already clocked in. //-------------------------------------------------------------------
I want to color code a field within a report, but the field is a Duration Type. Currently I am color coding within the report instead of just the field, but it's too much color and doesn't convey what I am needing. I am trying to give a heat map type look for a duration field. Does anyone know how to apply this color coding scheme within this field: Field Formula: Days In Discovery Today() - ToDate([Discovery Timestamp]) Color Coding Formula: var number DaysInDiscovery = ToDays([Days in Discovery]); If( $DaysInDiscovery >=45 and $DaysInDiscovery <= 60, "#74A235", $DaysInDiscovery>=61 and $DaysInDiscovery <= 90, "#90B433", $DaysInDiscovery>=91 and $DaysInDiscovery <= 120, "FFED44", $DaysInDiscovery>=121 and $DaysInDiscovery <= 180, "F9A900", $DaysInDiscovery >=181, "FF1100")------------------------------Elizabeth Schlagel------------------------------
For those of you in The Qrew who have seen "Oppenheimer", or know the story well of how he led a team on the Manhattan Project at Los Alamos, New Mexico in a race to put on the Trinity test, here's a question for you... How would you have designed a Quickbase app to make this project more efficient? What would be the key tables, relationships, Pipelines, APIs and other considerations you would include? What would be the governance needs you would have to factor in to make this the most secure Quickbase app in the history of Quickbase apps? Where do you think your app would help save this team time? If you have no idea what this film is about, here's your direction: You are running a top secret protect that involves hundreds of people. There are two people, you and one other person, who need to be able to see everything. You have eight different departments. Departments have department leads. Departments only need to see work in their department. Departments and leads cann
Can I format a QBase form to print to landscape instead of portrait?I create some simple brochures in QBase . . . and use a 'print' button to print to pdf: "<a class='Vibrant Success' href='"&Dbid()&"?a=printr&rid="& [Record ID#]&"&dfid=10'>Print</a>"Yet . . . although I can change my printer settings to print a landscape pdf . . . data from my form still prints in portrait.
I have a Kanban report set up that shows an individual user their projects separated by Status. One of the statuses is "Complete". Eventually, there can be 100's of "Complete" jobs and they don't all need to be seen on the Kanban report, so is there a way I can make it only show Completed jobs that are within the last month? I'm thinking this can be done with a report formula, but I'm terrible with formulas and code. Any help is much appreciated!! ------------------------------Allison Watson------------------------------
I am creating a work order. I have the form set up, and it makes sense. However, we have a series of tasks that are common; I want them to automatically be included in the form when the new work order is created. Tasks already have their own app (see bottom picture) ------------------------------Sid Fontoura------------------------------
Okay, as seen in figure 1 I have a drop down menu of my related jobs. This table is related to the parking docs for that job. What I am trying to accomplish, if possible, is to use the conditional values portion of the field seen in figure 2 and filter it down to where only the jobs with the parking docs eligible box checked seen in figure 3 will show. Is this even possible? Figure 1: Figure 2: Figure 3: ------------------------------William Hunter------------------------------
Hi Everyone, I am in Regulatory Affairs and looking to build an app to manage horizon scanning of regulatory issues where graphs would be displayed based on the inputs from Regulatory experts. Anyone know if there are templates I can use?------------------------------Shelly Ann Aiken------------------------------
Hi, I would like to create an 'n' number of records in a Poles table, when an 'n' number is added to a field in the Projects table. I'm pretty sure a pipeline is the way to go. I've created one that works with 1 new record, but how do I loop if it's more than one.------------------------------Mike------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.