Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I have the following rules set up and they fire appropriately if a user submits one form but if a user is submitting multiple forms, the rules start to fire inappropriately. I'm at a loss as to what to do about it. Does anyone have any ideas? ------------------------------Staci Eudy------------------------------
Hello colleagues, I have 4 data tables, those tables contain account numbers, I am needing to take the account numbers field of the 4 tables and show them in a different table and in a search field I can see the account numbers information of the 4 tables.I have tried to make the relations, but at the end I get 4 search fields and I don't know how to join them in only 1.Is there any way?------------------------------Jaime Fonseca------------------------------
Hello,I have two rules setup that say if checkbox1 is checked then uncheck checkbox2 and the other rule is if checkbox2 is checked then uncheck checkbox1. The first rule works but the second one does not. I am trying to make it so users cannot check both boxes, it's either one or the other but they can also have both unchecked if they want too.------------------------------
I would like to create a couple of pipelines to extract some details about my apps. Specifically, I want to create a pipeline using the Get tables for an app API call that will update the list of tables in another app. I am planning to schedule this pipeline to run once a month. I also want to create a pipeline that will use the table ids from the previous pipeline to create a csv containing the field names, fid, field type and relationship (if any). Initially I will schedule this pipeline to run daily.The API documentation doesn't contain detailed information.Any suggestions are greatly appreciated.------------------------------Paul Peterson------------------------------
Hi,I'm mapping out a build and am trying to understand if the following is possible. We receive a lot of PDF invoices via email through Outlook. These invoices are manually downloaded and processed outside of Outlook and QB with no easy way of tracking. Is it possible to have an Outlook Pipeline query the emails and then extract/copy the PDF from a given email into a request in QB? That way they don't even need to go into the Outlook inbox and all the "requests" are funneled to QB.I've browsed around, but I can't seem to find anything that indicates whether this is possible or not.Thanks!------------------------------Curtis Middleton------------------------------
I have found posts on this, but they don't address what I'm looking for, which is a report formula. I only want to see the last entry on a notes field that is already there and has multiple entries. I used the formulas in the posts I found, in the reports formula, and they didn't work. I can't set up a new text formula field so I'm looking for anything that will work in a report formula.Thank you------------------------------Steven Pearson------------------------------
Hi,Is there any way to hide this pencil icon on the report for certain users?------------------------------Mrunali Kadam------------------------------
I'm trying to add a filter to my connected table and app that only refreshes those records that have a Session Date on or before 90 days in the past. Although the filter for that field does allow for "is on or before" it does not give me an option for number of days in the past. Is there some way to write that in the filter that will do the same as it does in my table report filters?Thanks. Dawn------------------------------Dawn Rene------------------------------
I posted a week or so ago, but I am still looking to hire a consultant that can help tutor/build external APIs to map fields into QB from a few of our other programs. Please let me know if this is you!------------------------------Mike Tamoush------------------------------
I've been searching for a way to align numeric fields so that you can read them easily and the document looks polished. I've spent quite a lot of time already inserting 'blank' text form elements, saving it, going back to look at it, adding another one, saving it, etc. There must be an easier way. I am thinking it may involve a code page. The pdf attached here is after quite a bit of form element wrangling, and can all be undone by adding another field. But it takes a long time and now that I have many forms for different users, would have to repeat this process over and over. Any ideas or workarounds out there? Thank you.------------------------------Brian Hunot------------------------------
I have a report that I am displaying on a webpage using the below code. All displays as expected however, the pencil icon and the Eye ball icon both show next to each record. How can I remove those icons so that the report data is simply view only?<iframe src="https://xxxxxxxxx.quickbase.com/db/xxxxxxxxx?a=q&qid=17&ifv=1"; allowtransparency="true" onload="this.style.height=(this.contentDocument.body.scrollHeight+45) +'px !important';" scrolling="no" style="width:100%;min-height:1000px;border:none;overflow-y:hidden;overflow-x:hidden;"></iframe>------------------------------Brian Dunk------------------------------
Hello! I would like to have an icon show up in a table if more than a year has elapsed since a defined date. I believe the correct approach is to use a Rich Text Formula field but I'm struggling a bit to construct the correct formula.The defined date is "Last Raise" and I'd like a warning icon to show when today's date is 365 days or more after that date.Here's my draft Rich Text formula (that doesn't work!) - I know it's because I'm mixing operators but I just can't figure out the solution. Thanks in advance for the assist!If(Today()-[Last Raise]>365,"<img src=https://images.quickbase.com/si/16/241-triang_yellow.png>")------------------------------Eric Rovner------------------------------
Good morning, could you tell me please, How can I create table sort date specific period? so that this date is automatically extended.I need a sort from thursday to wednesday and every next week the sort was updated for the next week from these fields:------------------------------Dmitriy Serebrennikov------------------------------
Here is a loom video I created showing you an overview of what I am trying to do. How do I..... Loom remove preview How do I..... View this on Loom > Basically what I am trying to do is to create a line item in the estimate based on multiple choice answers in the table. Please tell me this is possible. Thank you,Jennifer ------------------------------Jennifer Meyer------------------------------
Hello all,I am having difficulties with building a pipelines to create a record from a API Link provided to me. I simply need to GET the information however I keep getting errors and am having difficulties just retrieving the data from the API Link, any suggestions/tips?------------------------------Mags------------------------------
I'm having a few issues that I'm trying to solve for a few different apps both around email buttons and sending form information.First, I have a Job Site Inspection Form that I wanted to create a button for that would allow the form to be emailed to a user from a drop down. I know how to configure the email drop down, but wasn't sure how to create a button based off that drop down and not just create a notification off of the "Save & Close" button.The second is for a CRM I'm working on and a quote request form within it.I was wondering if there was a way to replace the Save & Close button on a form or if I can change it to "Save & Send". Basically I need a way for the user to save the form and also a way for the user to send the form to multiple users including themselves on CC when a checkbox is selected.I've figured out the notification to send a copy of the form upon clicking the "Save & Close" button and know I can add additional stipulations like if a checkbox is s
Hello Everyone,I have a table report that the sales team uses to work through deals. I know we can create a formula for color-coding the records, just not sure what the formula would be.We want to color-code records like so: If the today's date is 1 week before [Closing Date] highlight red. If today's date is a month before [Closing Date], highlight yellow, etc. Once that date has passed, highlight another color. I really appreciate any help, thank you!------------------------------AG------------------------------
Ok, I know this should be possible...I have an App with 9 tables in it. This app is functioning as a Master Staff List, and also HR Database with Staff Assignments, pay, etc in it. Brief Description of the image below:1) The Employees table is the "Main" table - on that will be exported into another app for useage. 2) The Staff Assignments table contains active and inactive staff records, pay increases, job code changes, terminations, etc. 3) The Teams table contains a list of the 30 teams within the building.4) The Supv-Team Join Table, is a junction table, with data from Supervisors and Teams feeding into it; and allowing individual Supervisors to be linked with an Individual team, while maintaining historical data of past supervisors (inactive, etc). I need to be able to pull the Team Name (from the Supv-Team Join Table) into the Employees table for reporting. We need to have a list of staff that includes the team names. I have tried every w
Good morning, I need help creating a report that let's us know when something is NOT billed.How do we bill?We have an entry area that allows the person to manually type what they want billed.How do I create a report that shows me when nothing is typed in?------------------------------Newman, Savi------------------------------
I have used the form wizard to create custom forms. What is the best way to display records in the same custom format?From this post:form wizard------------------------------Adam Keever------------------------------
Hi,I'm currently having issues with scrolling a report and sorting my data. Scrolling: I have a summary report in my Dashboard that doesn't have a scrolling feature, so I can't scroll using my mouse. Is there a setting of some sort for this?Sorting: When I customize this summary report, the sorting feature (screenshot below) isn't working. There isn't an option to sort at all. I would like to move the current week first versus showing the oldest week.Thank you!Allie------------------------------Alexandra Loiselle------------------------------
Hi,I have 2 tables Employee and Task. Each Employee has many Tasks and those Tasks are defined weekly.In the Task Table I am trying to capture the count of the tasks by Employee Name+Week Number+Colour. So if an Employee has multiple tasks which results in the example like below.Row 1 Gunsham Lakhiani-14-GreenRow 2 Gunsham Lakhiani-14-GreenThis should be counted as 2 which is what i am trying to achieve by adding a column of Total Count which results in to 2 in each row. I would like to have the count 2 only in one row and not in the second row after which I want to just dump Employee Name,Color,Week Number and Total Count into some other table where the Total Count is not blank for certain calculations.Pl check the excel attachment or the Image below for your reference with the QB Ouput and the Desired Output.RegardsGunsham9821258653------------------------------Gunsham Lakhiani------------------------------
Hi guys,I have an events app that has a lot of tables and while everything is working fine, I'm running into a prob. The tables that come into play here are, Events, Employees, Time Off Requests. In Events, this is the actual events and is linked to mostly every table. In Employees, this is employee details and has checkbox fields for each day of the week (Sun, Mon, etc) where we can specify whether that employee is always unavailable for that day of the week. If all left unchecked, they're available every day of the week. In Time Off Requests, this is of course days the employee has requested off and has approved, unapproved, etc statuses. I'm open to changing some fields or approach here. But ideally what I'd like to happen is:When in an event, a relationship based field looks up the related employee to assign them to an event, but only shows employees that are available (based on days of week off, or time requests approved). For flexibility purpo
I need to create a form to put on my website which new clients can enter their data and it will put the data into Quickbase.I followed the couple Q&A links i found here but it still comes up blank when i try to create the html. I have created a Role for EOTI and it still isnt working. Any help would be greatly appreciated, Also if there are any freelance developers that would like to work part time helping build out some features i need it would save me a lot of time, and probably a few stressful moments.Id appreciate any help!------------------------------Matt Spanton------------------------------
I am using Juiced EF+ and I would like to highlight a row on the subtable when a certain criteria is met. I have a checkbox field in my data and when that checkbox is checked I want that row to be a different color on the PDF. Any ideas how to make this happen?------------------------------Amber Goodman------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.