Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
**EDITTED- I figured it out! But now I can't figure out how to delete this post...there is not enough caffeine in the world today...Hi All- my brain is fried and I can't figure out this but hoping one of ya'll knows this easy peasy (Looking at your genius Mark Shnier!). Basically I have a table that I want to create a formula query to get totals from another table after a certain date. So there is a total field on one table [Total Ride Cost] and a date field [Date of Ride]. I want it to pull and total all of the total ride costs after April 1 and put that into a second table. Thoughts? ------------------------------Annalise Sansouci------------------------------
I've been using EF successfully for the last couple of months. Starting yesterday when I click on 'Open From Quickbase' and supplied the app token, it does 'nothing'! It usually comes back with the dialog box to pick your QB table and form but the dialog box does not appear and it just sits on the word page. As far as I know nothing has changed. I spent a couple of hours with our IT Support and they were not able to figure anything out. Odd, I sent the token to our QB Support team and the dialog box with tables came up fine for them so it's seems to be an issue with my machine(?). Does anyone have any ideas what may be causing this? Thank youBarb------------------------------Barbara Alvarez------------------------------
I am working on a report that is used to build certificates for classes that we teach. The report is exported and then used to mail merge in our certificates.We teach classes that are either 1 day or multiple days / weeks. In the 1 day class, we would like the certificate to just display the date that the class was taken. In the case where the class spans multiple days, we would like the same field to show the extent of the class.I have created a report that grabs all the necessary data for the merge, and have created a report field of type formula-date and am attempting to concatenate within the report. We are using start date and end date as with most projects, but attempting the following.If([Project - Start Date]=[Project - End Date],[Project - Start Date],[Project - Start Date]&" - "&[Project - End Date]) As expected, i'm getting the dreaded "expecting date but found text" error. Any advice on how to resolve this?------------------------------B
I made a YTD formula-text field that states if End Date is null then "New Hires" and if not null "Separations". I then created a Summary Report that shows the number of employees that are separated between the "New Hires" and the "Separations". I'm not sure if this is possible, but I would like for the total to show a percent of the totals between the two. The percentage formula being Separations/New Hires*100.Could I add the formula in the YTD field, in the summary report, or do I need to take a whole different approach to this?------------------------------Ricky------------------------------
Here is my Loom video link: Finish Button Issues Loom remove preview Finish Button Issues View this on Loom > I am just not sure what I am missing.------------------------------Jennifer Meyer------------------------------
I have a table with records that only contain two fields "Name" and "Value". What I want to do is have a value in one record determine if additional records appear in a report.For example, if "Value" in Record 1 = "Show Additional Records", Records 2 and 3 would appear in the report along with Record 1, otherwise, they would not.I can't figure out how to control what shows in a report based upon a field in one of the individual records. Is this even possible?Any help would be appreciated.------------------------------Royce Patton------------------------------
Currently have a summary field that calculates the total of hours worked during a pay period start and pay period end. I now need to calculate the total of hours halfway through the pay period.------------------------------Willis Taylor------------------------------
I'm trying to return list of records in a table for a certain user and time frame but I want to limit the return to just the earliest record. There is a "Limit" field so I can get the pipeline search to return 1 record but there doesn't appear to be a way to sort the returned value by ascending date so I can retrieve just the earliest entry.Anyone figured out how to sort the return of a pipeline search query?Thanks------------------------------Stephen StudySoftware Development ManagerRobishaw Engineering IncHouston TX------------------------------
Hello -I am using a formula URL to create a new record in a table. The intent of the button is to essentially copy certain aspects of a record to a new record. (note: I know there are a couple native copy functionalities within QB but their limitations do not work for this use case) I would like to redirect the user to the new record in EDIT view but I am not sure what to add to the formula to do so. Currently, the end of my formula includes this (which redirects to the record on which the button was clicked): & "&rdr="&URLEncode( URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & RurHow do I need to alter my formula to redirect to the created record in EDIT view so they can make any changes needed from the original record?------------------------------Thanks in advance,Jennifer Paschal------------------------------
I am struggling on creating an Attrition Chart in Quickbase. I need to create a Total YTD New Hires and Total YTD Separations that shows the Attrition %. An example would be Separations YTD = 14 and YTD New Hires = 57 to the attrition being 12%. The New Hires field is Start Date and Separations field is End Date.-----------Ricky-----------
Hi I created a bar chart and when I run just the report the font is White inside the bar. I made the report part of my dashboard and when it displays there the font is black (harder to read) Any clue why this changes and how to fix it.------------------------------Bill Harned------------------------------
What is the best way to convert a combined text summary field to a list? Also, is it possible to find the highest value, lowest value and total items in the field?------------------------------Paul Peterson------------------------------
If I would like a checkbox to be turned on at 1:20 AM , below doesn't work If(ToTimeOfDay(Now())=ToTimeOfDay("1:20 am"),true,false)Surprisingly Below works If(ToTimeOfDay(Now())>ToTimeOfDay("1:20 am"),true,false)------------------------------Prashant Maheshwari------------------------------
I would appreciate any suggestions on the best way to set up a new app to be able to create this simple table: Market Total Items MS 2 Items MS 3 Items Houston 17 16 4 Indianapolis 22 0 0 Atlanta 13 7 6 Miami 0 0 0 Los Angeles 0 8 10 TOTAL 52 31 20 Each market has multiple records which have any number of items in the 3 categories. The different item types are summed to give the number shown above.It seems like a simple table, but I haven't been able to figure it out. Please help!------------------------------Mike Sanders------------------------------
I have created our own complex reporting service, so as not to depend on subscriptions and monthly payments.------------------------------Marcelo Benavides------------------------------
Does anyone use QR code scanning on iOS? I use it to get to specific records in QB. It used to work perfectly.Then a few days ago, when scanning on iOS it only takes you to yourrealm.quickbase.com, and leaves off the entire rest of the URL.Are other people having this issue?------------------------------Mike Tamoush------------------------------
Hello,I would like to clean up my searchable fields, assuming this will improve QBASE performance. Any suggestions on what field types definitely don't need to be searchable?thx------------------------------BuildPro------------------------------
I have a pipeline which copies address fields from one app to another. My - limited - experience shows that pipelines indeed can not write non-english caracters, only read them. So if in an address field contains any accented characters, it will not be copied, the old value stays in the destination. Now quickbase clearly states that pipelines can only read not write these characters if only my app and not the realm forces utf-8 (which is my case): About UTF-8 Support Is there some Jinja function which can be of help here ? Or how to make a pipeline change its mind to handle the non-english characters as a workaround to the realm not-set to UTF-8 enforcing? Thank You!------------------------------Laszlo M------------------------------
I'm trying to create a table report that only shows records that have had specific date fields modified since the last business day. I added a Report Formula to the report however the filters are not allowing me to select that as a criteria to compare against. The formula I added is:ToWeekdayP(Today()-Days(1))I had hoped to add filters like:Date1 is after <report formula>Date2 is after <report formula>Am I missing something (entirely possible) or has someone solved for this problem in a better way?------------------------------Jeremy LahnersLeadBaller------------------------------
I'm trying to pull in a field within text in a rich text formula field. New to html and QB rich text fields."<div style=\"font-size: 14px;font-weight:bold;\"align=\"center\">ABC, INC. CONSULTING AGREEMENT</div>"&"<br>"&"<div style=\"font-size: 14px;\">Consulting Agreement (this Agreement) is made as of [Today] and is a binding agreement.</div>"[Today] is the field I want to pull in but this actually puts "[Today]" in the field and not the actual date. Any ideas on where I went wrong? My [Today] formula field works perfectly. I want to be able to do the same with [Name] and [Address] within other text but thought I'd start with the date.------------------------------Dawn Rene------------------------------
What would cause a user field not to be updated?I have a checkbox, user and date field. I have a form rule that when the checkbox is checked to update the user to the current user and the date to the current date.The date updates but the user field will not. Here is the rule.------------------------------Carol Mcconnell------------------------------
Hello, I'm using predecessors in tasks, but when I go to select a preceding task, it gives me a list of ALL tasks, not just ones actually associated to the specific project I'm in. Is there a way to make the pop-up list of available predecessors limit itself to the tasks within the same project?Thank you!------------------------------Amber Gartner------------------------------
Is it possible to move the legend in a pie chart from the bottom, where it looks very messy, the right, where it would be better balance and left-justified?Thanks!------------------------------Amber Gartner------------------------------
Been going round and round to maintain this format. I cannot pass the AM or PM of the time and would like it to be in 24 hour format but that doesn't hold either. So created formula to take date field and Time of Day field to create the format I need. This works fine except I either lose the leading zero for single digit hours or lose the format if format time ie12:00. This is my formula: ToText([Date Scheduled])&" "&Left("0"&ToText([Appointment Time]),5) This works fine when it is 1:00 because of the added Zero in formula but when I go to 10:00, 11:00, 12:00 its get out of whack. 05-12-2018 01:00 - perfect with above formula but if time change to 10:00 I get this 05-12-2018 010:0 Basically I need the leading Zero for 1-9 hours but not when 10-12 hours in time of day. Any help is appreciated!
I am very new to the system. For my company, I am trying to figure out how to add a new project for a builder using the new site address, without having to create multiple customer entries with new addresses.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.