Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello, Trying to pass the app builder exam and having a hard time. Is there a practice exam that tells you the right and wrong answers? This exam only tells you your score and not the answers....???------------------------------Samira Shubash------------------------------
Hi The date cell formatting is exported to the CSV file. When I hit "download report as CSV" the formatting for date cell is saved into the CSV file showing this:<span style="white-space: nowrap; "><span style="color: blue; font-weight: bold; white-space: nowrap;">06-17-2022</span></span>How this can be prevented or resolved?Thank you,------------------------------Karwan Fendi------------------------------
I have a look-up field: I would like to be able to enter the Job Number I need vs. scrolling through the entire list.Please advise. thank you------------------------------BuildPro------------------------------
Hi, I have a form in a table "Documents". It has some fields that pull from a parent table "Tasks". In the Document form, the Associated Task field is multiple choice, with other Task lookup fields auto-populating when Associated Task is selected.I also setup an Add Document link in the Task form - when link is used, it opens Add Document form, and the Associated Task field in Document form auto-populates along with the other Task lookup fields.We have several other roles where we need to limit edit ability in both Documents and Tasks forms. We don't want these roles to edit the Associated Task field in the Document form.Our goal is for Administrator role to make Tasks for the other roles - those roles would select Add Document from within their assigned Task, upload a file to the Document record, then mark their Task as complete.We need the Task info to auto-populate in Document records so related task info is associated with each Document record, and we don't want the other role
Hello,I created a dynamic form rule so that when I check one box, it changes several other checkboxes to checked. This works great when you go into the individual form and edit one by one, however, when you choose the awesome feature to "edit all the reports below" and you check that 'apply to all' checkbox, it does not engage the dynamic form rule. I am familiar with the ability to highlight the column, and select 'fill down', however, many rows will be skipped on-purpose during this editing process. Is there a work around for this?------------------------------Shane Miller------------------------------
Is there a way to create a legend for a calendar report? QuickBase newbie so still figuring out the basics and not super fluent in it all yet :)------------------------------Annalise Sansouci------------------------------
I have a summary field that counts the number of records in a child report (grid edit) that are checked. I would like the user to be warned if there are no child records checked but in a parent field I have a value that indicates that child records should be checked. The user then has the option in edit mode to either change the parent field value or check one of the child records (in an embedded grid edit report on the form) The problem is that the summary field for the checked records in the child table do not calculate until the form is saved and then it is too late to notifiy the user that they have a descrepancy between the Parent value and the summary field. Is there a way to catch this descrepancy real time (before or as the record is being saved). I have tried having the embedded report and parent fields load at the same time but that does not catch the descrepancy.------------------------------George Bramhall------------------------------
Hi Everyone,I'm unable to find option to change column name on the summary report. It default shows the field name. Thank you!------------------------------Mrunali Kadam------------------------------
Hi,I have an app to record requests for access and some of them require a spreadsheet to be filled out and sent.Is there a way to add an excel spreadsheet to the home page? I want users to be able to click on the spreadsheet and fill it out.------------------------------Fatima Khan------------------------------
We have many affiliate companies as clients where each affiliate has it's own "Inventory" record, and have a Group Name field that establishes the affiliated companies and a field to identify Parent versus Child for those that are part of a group. Based on that, is there a way to populate a field (Affiliates) in the parent record with the names of all the affiliate companies associated? In the current database, they're manually updating a field to show the names of all affiliates.Even better, can we set up a way to link from parent to affiliate records and vice versa, allowing someone to easily jump back and forth between the records, using those Group Name and Affiliates? I think I know how to do that to get to the parent from a child, but not how to get to multiple children from the parent.------------------------------Lessa Kennedy------------------------------
Hello all! I have a report that I want used in a search bar on my dashboard. For this case, it is a list of resources and one of the columns is tags/key words. I want this field to be searched for in the search, so that it will pull up records with that tag. However, I don't want to the tag field to be shown in the report that comes up after the search. Any ideas?------------------------------Annalise Sansouci------------------------------
Hello,I'm trying to write a code that allows me to edit only the current record I'm on in Quickbase. For example, when I click the button I want only to be able to edit information for that particular resource instead of having to select the information again.Is that possible?Example------------------------------Ariel Combs------------------------------
I have created a summary report that summarizes on # of items with the same name.It's based on a huge table so I would like to filter out any with just a count of 1.and i can't create a relationship, because it's not based on the record Id, etc.So, i need to be able to either "filter out" any results with a count of 1...OR sort it by the count from high to low. I can do that by clicking the header but OR by changing to a custom sort that is not the default, but when I do either then it shows "zero" results in the report I set it to go to. that report works every time when I don't sort the results by either method, which doesn't make sense to me.Is there a solution? ------------------------------Jeff Elliott------------------------------
Hi Everyone,Looking for ideas how can we create a chart/graph/report if we've to put multiple fields in one chart ?I've to create a report for a change type section(see below) which has 5 checkboxes on the form and each checkbox is an individual field. I'm not sure how to do this since these are not a part of same field/category. I need to show the count/subtotal of each checkbox field so that admin can see the comparison and daily request turnaround quickly. Also for each record, user might select 1 checkbox or all so report needs to calculate totals accordingly. Thank you in advance! ------------------------------Mrunali Kadam------------------------------
Hi Everyone,Looking for ideas.. how can I archive records in QuickBase? Not sure if archive is the correct term. Per requirement, need to make record non editable for all users except admin when it's archived.I'm thinking to add 1 checkbox field on the form called "Archive". Admin will have access to select/un-select it. Once admin selects this checkbox, record will be locked and no user will be able to edit it except admin. Not sure if I need to write a formula for this checkbox field or need to add any custom rule for admin and other users roles. Please advise. Thanks In advance!------------------------------Mrunali Kadam------------------------------
Hello All,I've managed to get to this point Case(true, ToDays(Today()-[Class Start Date])<35, "In Training",ToDays(Today()-[Class Start Date])>=35 and ToDays(Today()-[Class Start Date])<77, "Supervised",ToDays(Today()-[Class Start Date])>=77, "Production", "Hasn't Started")The complete logic that I need isIf [Program Assignment] = "Brokerage" thenCase(true, ToDays(Today()-[Class Start Date])<35, "In Training",ToDays(Today()-[Class Start Date])>=35 and ToDays(Today()-[Class Start Date])<77, "Supervised",ToDays(Today()-[Class Start Date])>=77, "Production", "Hasn't Started")If[Program Assignment] = "Acquisition" thenCase(true, ToDays(Today()-[Class Start Date])<35, "In Training",ToDays(Today()-[Class Start Date])>=35, "Production", "Hasn't Started")Is it something possible to achieve?Thank You------------------------------Alexander Kouzmine------------------------------
Hello! I am trying to create a field that essentially looks at a [static date] (which will always be in the past), and have it add on 3 months incrementally until the MM/YYYY eventually is greater than or equal to MM/YYYY of [date created]. Once the above has been marked as true, I would like that manipulated static date displayed in the field type on the form.Example: [static date = 1/1/2021], [date created = 8/1/22]April 2021 >= August 2022 , FALSE ..... July 2021 >= August 2022 , FALSE ...... eventually getting to ...October 2022 >= August 2022, TRUEPosted in the field would be 10/1/22Thank you in advance to the highly intelligent being that figures this out------------------------------Shane Miller------------------------------
I figured out how to build an employee churn report using a metrics table that's a parent of my employee table and formula queries (thanks quickbasejunkie!) but am stumped on how do grouping or filters based on a multi-select list on the employee table. For additional context, the churn report currently shows me the whole company's churn result by month, but I need to group it by team. My team leaders just see their team's results because I have their access to the employee table tuned - but I don't have an overview. thanks in advance!------------------------------Malcolm McDonald------------------------------
Hi,I am building a meeting table and one of the items I need is to approve previous minutes. I would like a link to the minutes so the attendees can review them. Is this possible?------------------------------Sandralee Oster------------------------------
Building an employee churn summary report - and am within sight of the finish line.I only really have [Employee Start Date] and [Employee End Date] in the employee table - so am grouping on the rows by [Team] and on the columns by [Employee Start Date] combined on the month.Using a report formula, I'm counting every employee who either doesn't have an [Employee End Date] or has an [Employee End Date] after the first day of the [Employee Start Date] month. Because of the grouping, the employees without that end date get counted only if their start date is on or after the first day of the start date month too.Is there a way to step out of the grouping context? I can do it using a Parent stats table, but with the stats table, I can't figure out a way to group on the [Team] .Thanks!M------------------------------Malcolm McDonald------------------------------
So I may have caused myself issues with my setup. But my problem is doing If statements with conditions which have an Inch (") in the name.Ceil(If(="Per Piece",IF ([Material Description]="WEEP AID",[Plan/Trade Product Line - Plan - Bid Set Weep Aid]/,[Material description]="4" DIAMOND LATH STRIPS",0),0))I stopped because I have numerous Material Descriptions which include (") identifier in the name such as the Diamond Lath Strips. I guess I could go through and change all the names to read inch but there's a lot of them. Is there a ' function which allows me to bypass the problem?------------------------------Paul Elliott------------------------------
Did Quickbase remove the option to copy forms? Was this intentional? I only see a delete and preview now, for my forms.------------------------------Mike Tamoush------------------------------
Hi everyone, I have a list of records that I need to rank, first by the expected start date, then by the final date required, then by the build priority, and last using the record ID. One thing to note is that the expected start date field is usually blank.This is the formula I am using currently, and it is working with the exception that if a record has the expected start date populated then it numbers those and then starts the numbering over again on the records that do not have a date entered in the expected start date. For example if 2 of my records have an expected start date they would be ranked 1 & 2, then the next record (without an expected start date but with the earliest final date required) would again be ranked 1. I have referenced Quickbase Junkies videos which is how I got this far. Any help/suggestions would be appreciated. var text QZER = "{289.EX.'true'}AND{58.EX.'"&[Region]&"'}AND{45.EX.'"&[Data Center Name]&"'}AND{148.
Hello. I have a button to add a new record and then redirect to a code page.I am trying to show the new record on the code page return(Page id 179) . much appreciated the support on my code page that I am not sure what I'm missing to show the record after redirect.url field var text urlToExecute = URLRoot() & "db/" & Dbid() & "?a=API_AddRecord"& "&_fid_11=" // Field to Popuplate with the user prompted input;var text redirect = URLRoot() & "db/" & AppID() & "?a=dbpage&pageid=179" // Open code page 4& "&url="& URLEncode($urlToExecute) // Pass in the URL to executePAGE ID 179<!DOCTYPE HTML><html lang="en"><head><meta charset="UTF-8"><title>School Meals Track System</title><script src= 'https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js'></script><link rel='stylesheet' href= 'https://www.w3schools.com/w3css/4/w3.css'><link rel='stylesheet' href= 'https://fonts.googlea
Hi! Is there a way to reorder fields (columns) in a table? I've seen the drag and move feature (dragging a column and moving it to the right spot) but somehow it doesn't work on my end....I tried changing the order of fields in the form but then the new order only shows in the form and not in the table. Right now I've just been deleting fields and re-entering them in the right order, please tell me there is another way!! Thank you!
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.