Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I have financial metrics (net income, gross income, etc.) uploaded as records into QuickBase with a date indicator...e.g. in 2022, we made $125,000 in NOI. In 2021, we made $100,000. How do I make a summary report that compares the $100,000 in 2021 to the $125,000 in 2022?------------------------------Colton Runnels------------------------------
How do I remove unwanted sums and totals at the bottom of the default report? I have a report that tracks leasing percentage over a period of dates and the default report is summing those percentages at the bottom.------------------------------Colton Runnels------------------------------
what is existing user in QB as below , i need to fill it up and and also what is quick base application name as motioned below in the form Hotel user details Hotel Name MARSHA Code Existing User in QB The Westin Cairo Golf, Resort & SPA CAIWI Applications required access to: QuickBase applications name: 2a) Hotel user access role -select one applicable** General Manager* 2b) For A&L Recon INTL tool specify user access** A&L Reviewer ------------------------------Mahmoud El Balsha------------------------------
I am trying to figure out total "Days on Orientation and "Days Overdue". My current formulas are able to give me the total days, and not business days. What do I need to add to the below formula to count only business days?Total days on orientation:If([Process Status]="Completed",([Orientation Completed]-[Effective Date]),Today()-[Effective Date])Total Days Overdue:Today()-[OVT Due Date]------------------------------Lynda Schutter------------------------------
I have a multiple choice field (Purchasing Review and Approval) with one value "Reviewed and Approved." The field is empty until someone approves. To log the user and date, I enabled Log Entries for this field.After value "Reviewed and Approved" is selected, I don't want this field to be editable. However, my form rule is not working in this field. If I select a different multiple choice field that does not have Log Entries enabled, the rule is working.NOTE: originally I had 2 values "Not Reviewed or Approved" and "Reviewed and Approved", but it had the same issue.Also, I've set a notification (currently to myself for testing) that when the value changes to "Reviewed and Approved", a notification is sent. This is also not working.Is this a QB limitation when using Log Entries, or am I doing something wrong? Thank you for your help!------------------------------Diane Sinawi------------------------------
We have an app that we built to manage two bin inventory system and allows a user to scan a bar code on a physical Kan Ban Card . We scan a part number ie(100-2300) into a grid edit report. The field we scan is a related table look up field. It worked great until we got over 1000 records and then the drop down list changed to a Browse for an item look up.. This has dramatically slowed down our process. Is there anyway to over ride it back to a drop down list? Thank you!------------------------------jonathan duke------------------------------
I have a field that is Multi-text that has words and numbers. I need for when the box is checked that has the name and amount to total into another field anyone have any idea how to make this work?------------------------------Chasity Johnson------------------------------
Hi All - newb here and I'm having trouble with something simple. Our app is used to pass requests around our team. We have a Notes table (child) where all of the detailed communications go that attach to the Requests table (parent). I'm trying to create a button when someone completes a Note record, it save and return them to the Request record they were adding the note to so they can continue editing (if necessary) the Requests record.it seems it would need to be a var text URLONE / URLTWO situation but I'm a bit at a loss after that. Any assist would be much appreciated!------------------------------Becky------------------------------
Hello,We currently have two tables on that we have a relationship built. Tasks and Customers.On the task, we have validation built so that if the status of the task is different from the status of the client, it allows for the user to update the customer from the task form with a dropdown of options [Status Change].I am currently attempting to create a text button that does the following: Validation is met, so [Status Change] = null Saves the task record and redirects to the customer record Validation is not met, so [Status Change] is not null Saves the current task that they are on with the information that is filled out Updates the customer record with the item from [Status Change] Redirects them back to the customer's form This is the formula that we have written:If([Status Change]=null,"<a class='Vibrant Primary' style=\"width:310px; text-align: center;\" href='" & URLRoot() & "db/" &[_DBID_xxxxxxxxxxx] & "?dfid=14&a=er" & "&key=" & [Phone
I would like an easier way to track department meeting attendance. I have a table for Departments, Staff, and a child table in common called Members which associates many staff with many departments and includes the start & end date of their involvement with the department. I also have a table called Meetings which is child to Departments and a table called Attendees which is child to both Meetings and Members. Each time I create a Meeting record, I select a Department and then add a large number of Attendees (selection restricted to only active Members of the selected Department). Adding attendees this way is time-consuming, so I created a Pipeline which runs when a Meeting record is saved. It queries all active Members of a Department and creates Attendees for each found as children of the Meeting. However, this Pipeline often takes 15-30 seconds to execute. While I have access to the Pipelines page, my fellow users don't and it's not obvious to them that a Pipeline is running wh
I'm looking to see if anyone has a template for a Content Management System using Quickbase? Specifically, for all our MarCom efforts? If you have one that you wouldn't mind sharing or if you can point to one, I'd be greatly appreciative.------------------------------Dominic Rodriguez------------------------------
Oh man do I need some help... I have a kanban that i am trying to color code based on a due date that has passed. So I have a status field and when that status changes to for example "Status 1", a dynamic form rule logs in the date in another field... based on that date, within 2 days, green. 4 days, yellow. so on, red.... BUT WHEN STATUS CHANGES to "Status 2" it logs in the date in a different field and the same concept applies. So I want the ticket colors to change based on how long a status has not been changes. Maybe I could change it so whenever status changes, it logs a new date in the same field. I am pretty lost and could use some help! Thank You in advance------------------------------Eddy Elasmar------------------------------
Hi, a colleague of mine went to China early January, starting from around 19Jan23, she could not access project and task pages, she can still login QB and see the home page. Any suggests?Thank you very much!------------------------------xiaonan tang------------------------------
[ANNUAL PTO DAYS - ALLOWED]IF [YEARS EMPLOYED]<.75, 0,IF [YEARS EMPLOYED]>.7501 and less than 3.0, 5,IF [YEARS EMPLOYED]>3.01 and less than 8.0, 10,IF [YEARS EMPLOYED]>8.01 and less than 10, 15, IF [YEARS EMPLOYED]>10.01 , 20Thank you for your assistance...------------------------------BuildPro------------------------------
We have a table report where the output format selected is Comma Separated Values.The report shows in the reports panel for the Administrator role, but is completely hidden for users in other roles.What in the role permissions could possibly restrict CSV reports from being visible in certain roles?We've double checked: All roles have access to the report - it is visible when output set to "Normal" Role normally does not have access to Import/Export, but we removed that restriction while testing and the report still was not visible when set to CSV Save Common Reports is also normally off for the roles, but we removed that restriction while testing and the report was still not visible when set to CSV We rebuilt the report and it is still only visible when the output is set to "Normal" Hide UI for creating and customizing reports option is not selected The report will export as a CSV when accessed by a button on a Homepage, so the report is available, it just won't show in the panel.Any
Is it possible to specify which app is active when a user signs into quickbase? My initial account only had access to one app. Now I am the admin for several apps. The first app I had access to has been deprecated and removed from the realm. Now I get an error page every time I sign on. Is there a way to set a different app as my default?------------------------------Paul Peterson------------------------------
Using Pipelines for the first time to have a record automatically be created. The creating of the record is no problem. However, I can't get the fields to update with data. After looking how the fields were updated manually, I see there are rules created to update the fields. Here is a pic of one of those rules:So when the numeric field called " Support" is blank, it will get updated by a numeric lookup field called "# of Cases in the Last Month Form". When I got to create my pipeline, I am not seeing the field "# of Cases in the Last Month Form" or any of the other lookup fields available for selection in the pipeline. Below is the pipeline I created to create the record:When selecting a field for "Select Fields to Specify Values", the field "# of Cases in the Last Month Form" is not available to select. I tried to update "Support" with the field ID, the field name, and a.# of Cases in the Last Month Form" (along with all the brackets / paranth
Hi,I've created a report to pick records from a table based on a set criteria - is it possible to add a formula object to a form to display the number of records in my Record Picker report.Want to use the count of records to enable / disable certain features from within the report.RgdsPat------------------------------Patrick O'Neill------------------------------
I am looking for a way to expose non-windows-1252 characters when Users paste them into text fields in Quickbase.I tried this but it doesn't work.If(Contains([Scope change Description],"'", true,false)If(Contains(URLEncode([Scope change Description]),"'", true,false)If(Contains([Scope change Description],"URLEncode(')", true,false)If(Contains(URLEncode([Scope change Description]),"URLEncode(')", true,false)Thought I'd see if anyone has cracked this before I find the answer through random trying. I submitted a support case to Quickbase support as well. If I find anything I'll post it here.------------------------------Jim Harrisontransparency = knowledge + understanding : The Scrum Dudes------------------------------
Tried a few searches but not quite sure how to describe my desire in just a few words.What I'd like to find out if it is possible would be to build an application for the tracking and routing of invoices. I know I can build tables and pipelines to functionally achieve this but the part I'm not sure how to do is to design the app so that when a user receives an email, indicating they have an invoice to review, to build in the ability for them to indicate somehow in that email their response.We are currently using a SharePoint Power Automate workflow but it seems to run into issues and I am the only one that knows how to investigate and fix those flows. The email provides basic information in the body, includes the original invoice as an attachment and then gives them the option to Approve or Reject from right in the email. For the majority of our invoice approvers they never actually visit our SP site, their interactions are solely through the approval emails they rece
Hello quickbase community!I would like to know how to create a button that edits my table (DB1) and creates a record in another (DB2) with various data from the first table (DB1).Thank you very much.Regards,------------------------------Herberth Solano------------------------------
I'm trying to create a formula based on the following and having no luck. If you have any suggestions they would be truly appreciated.If [New Medical Plan] is not null OR [New Dental Plan] is not null OR [New Vision Plan] is not null Concatenate [Control],[Suffix],[State]Thank you------------------------------Kathy Benjamin------------------------------
I need a link from one table to a record (form) in another table and I can't seem to get a pipeline to work.For Example:I am in MATERIAL ORDERS table, record 204.PJDWhile in this record, I need a button to link directly to 204.PJD in ORDERS tableNeed a pipeline to automatically make this happen when OPTS VERIFIED (lookup field from JOBS table) is updated in the Jobs table.------------------------------BuildPro------------------------------
Hi,I am trying to figure out a formula that will show 2 days after the record is created.I have a date field [Response Needed By] and I want it to automatically populate the date for 2 days after the record was created.Thank you------------------------------Fatima Khan------------------------------
Can anybody break down the components of the URL for a report when you enter grid edit mode? Specifically, the portions having to do with QID and ridList?I have two reports (standard reports in grid edit mode), that I'm displaying as iframes linked to an html code page, on a home page. It has to be this way, because there is no way that I can tell to filter parent record selection on a report built in grid edit mode. My solution works great for one day, and then something happens where the numbers associated with qid and ridlist in the URL change and I have to fix the HTML code pages. https://...quickbase.com/db/bniuwc3g7?a=q&qid=-1000005&ridList=2908&dlta=su94~su83~mog~&qskip=0&qtbtx=__none&navBack=true&originalQid=29Does anybody know how to dynamically change those elements of the URL so I don't have to fix it every day? Many thanks!!------------------------------Elena Larrabee------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.