Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Here's what I am attempting to do in a very specific way:We have kids in classes [class] that correspond to their academic grade [grade]. Rather than using a hard-coded CASE formula that would read:case([grade],"6","Jr. High",[grade],"9","Sr. High") ...we'd like for Case to look up that grade in another table and return "Jr. High"The parallel "Classes" table is in our data app so that the people using it (Church Secretary) can easily add to this list without having to edit the field attributes.What would be the best way to approach this type of lookup?------------------------------Ryan Buschmeyer------------------------------
We have a Portfolio Project Governance Application that has ~400 projects. We have three types of governance meetings and have developed our Agendas in a "Review" table. Users can see and pre-review projects on Agenda from within their dashboards. We also need the option to embed the agenda within our Outlook meeting request. Some users will want to link from there and other attendees will not be users. Senior execs attend these meetings so the agenda needs to look crisp, yet interactive. Please note: these are NOT calendar items, but rather agenda items that need to be embedded easily into an Outlook agenda.Problem: I can highlight the agenda report and paste into an Outlook meeting invite agenda space. The project IDs on the agenda properly take a user to the right project, but the visual aesthetics are so crude that it is unusable in current form. (pic attached) Is there a better way to embed this report rather than cut/paste? Is there a way to remove / improve the column and heade
We have a Portfolio Project Governance Application that has ~400 projects. We have three types of governance meetings and have developed our Agendas in a "Review" table. Users can see and pre-review projects on Agenda from within their dashboards. I would like to keep last / current / next agendas in this grouped agenda report. I would then migrate the agendas to a separate grouped Archive report for the YTD governance meetings. Problem: How do I set these grouped reports to auto-collapse. Opening up in detail is unwieildy.Thanks in advance for your help!------------------------------Annetta Coleman------------------------------
Hello, We have a table with several multiple choice fields. Each multiple choice field is either left blank, is marked "complete", or "incomplete". Somehow me need to count up all the "complete" and "incompletes" in the entire table (not just a single field). I don't know where to start with this? Could someone give me some direction? Thanks! Meagan ------------------------------Meagan McOlin------------------------------
HelloCan you please help me write the QB formula for below region derivation?Say there are two tables 1. Sales table:Customer Region Sales1001 NA $1001002 SA $2001003 EU $3001004 AS $400How can derive Region from customer table. if it is Excel, I would have written as If(VLOOKUP(Customer,Customertable(Customer:Country),2,false)="US", "NA"If(VLOOKUP(Customer,Customertable(Customer:Country),2,false)="MX", "SA"etc2. Customer tableCustomer Country 1001 US 1002 BR 1003 FR 1004 IN-----
I couldn't find a reference to this. So, I want to make sure it is not just me. In the Quickbase iOS app the abort message does not display even though it is set properly in a dynamic form rule. There is an indication that something is processing, but you are returned to the form with no message. The abort action works in the sense that the record is not saved, but there is no message. I can get the "Display Message" action to display a message from another form rule I have. Also, testing in the same role I am logged into the app as there is no issue with the abort message displaying. Have people encountered this? I can create a banner that shows in the app with the same message, but it is weird.------------------------------Tate Forgey------------------------------
The Journey of a New Quickbase Builder: Tables and Relationships My first attempt at app planning and building my first data model was not as successful as I would have liked. It took me 5-10 tries to create and relate my tables correctly, and with each failed attempt I was getting increasingly frustrated... “Why is this not working?!” Finally, it clicked. It took my many failures in trying to connect my data for me to begin understanding when to create tables and how Quickbase relationships work. Tables and relationships can cause so much overthinking when in fact they can be very simple to understand. Why Relationships? Creating relationships is the foundation of app building. Relationships are built in a one-to-many matter meaning one record in the Master table can relate to many records in the Details table. This will reduce database sizes, data entry, errors, and it enables workflow automation. Figuring out the desired workflow will help you decide how relationships
Hi,Please, I have a form with 15 pipelines, all of them are triggered when the user creates a new record. Depending on the user's inputs some of them are used and the others are not, sometimes 4 or 6 or 9 or 10 pipelines were completed executed depending on the user's input. Kindly, I would like to know how could I inform the user that the background process (pipelines 4, or 7 or n out of 15 are already finished)? It would be great if there is an option to order the pipelines to run so you could know when the last one was executed.BR.------------------------------Ivan Gallegos------------------------------
I've had success creating emails using a rich text button. However, I've noticed if I have NO body in the email, my outlook signature is placed in the email. As soon as I add body to the email, my signature does not appear. Does anyone know how to keep the signature?My assumption is that any body I include is overwriting anything there (ie the signature), so perhaps this is just how it will work on Outlook?My sample code is below:var text Subject = "Subject Line Text:"; var text Body = URLEncode("Body Text here") & "%0A%0A" //Line break with extra line break (skips a line) & URLEncode("More body text here " & [Field]); var text cc = "?cc=fake@email.com";var text Email = "mailto:emailfortoline@email.com"& $cc& "&subject=" & URLEncode($Subject)& "&body=" & $Body; //If I comment this line out, the signature w
I have a Project Table and a Tasks Table that are related. I would like to either check a box or count the number of specific tasks that are marked Completed. I tried doing it this way but it doesn't work:So if 3 Specific Tasks are marked "Complete" (which is a checkbox based on a date field) then I can mark the Cabinet as having been Installed. I also tried the beginning of a formula query using just one field and it didn't work either:Size(GetRecords("{6.EX'Set Cabinet'}and{19.EX'true'}",[_DBID_TASKS]))Any help would be appreciated------------------------------Thomas Ringkamp------------------------------
I just made a query and interchanged both HAS and CT and both worked just fine. Which leads me to the question, what is the difference? When do I use each one?Also, a huge thanks to QuickBase Junkie for her videos on formula queries!@Quick Base Junkie------------------------------Mike Tamoush------------------------------
Q&A: The Future of Automations Webinar (Q3 2021) We had a great webinar earlier this fall about the future of workflow automation in Quickbase. Below we've collected answers to your questions we were not able to get to during the webinar. Automations Migration Tool Q: What happens if you migrate an Automation that has already been migrated? Will it create a new Pipeline, or can you only migrate an automation once? A: An Automation may be migrated multiple times. Each time the migration process runs, it will create a new Pipeline, which can then be modified, activated, or deleted as necessary. Q: When an Automation is migrated to Pipelines, who owns the resulting Pipeline? A: The user who initiated the migration will subsequently name, configure, and own the resulting Pipeline that is created by the migration tool. Q: Does the migration tool allow me to test a migration, without committing to deactivate an Automation or running directly on my production data? A: Migration can
Hi all.I did a test in an app I own. In this test I added a second role to my user to see how the app would work with two roles. Now, since I'm the app owner, I'm unable to remove myself from this second role. I understand that app owners shouldn't be able to remove themselves from admin roles, but that should be allowed if owners are assigned to two or more admin roles, until a single admin role remains. Any idea of how I could do that? Should I transfer ownership, ask the new owner to remove the role and transfer ownership back to me? Is there a simpler way, maybe with an API command?Thanks.Jose Vieira------------------------------Jose Jose------------------------------
Has anyone had success launching from a record to a grid edit report (via a button), and then returning from where you came when saved? But - on mobile?On desktop it returns no matter what I do. I can not even have a redirect and it returns. I can use &rdr or &nextUrl and it returns. Basically I can do no wrong.On mobile, on save it always goes to the app homepage. Anyone know any secrets returning from a grid edit report on mobile? So far I have tried both &rdr and &NextURL and hard coded the page, and also tried using the new:& URLEncode(URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl()) No success with any.------------------------------Mike Tamoush------------------------------
Trying to implement suggestion described here:DiscussionsThread lead to a code pasties that includes the use of iol. Trying to figure out how to implement this solution without the use of iol reference. In searching it sounds like I would place both the formula and code into separate code pages, then create a formula url field to call the formula code page which in turn would call the code page. But I'm still left with what to change the first line of the formula code to.[iol] & "moduleTimers,js" & [/iol]When I inserted the formula code into my field I get the error message "Formula error -- Unknown field...the table does not contain a field call iol..."So if iol can't be called directly from a form/report, do I still need a field called iol or would I remove that first line entirely.Thanks------------------------------Ember------------------------------
Duplicates: Defense is the best Offense! The notorious issue of duplicate records is a sure sign of a data integrity issue, which leads to bad reporting, skewed metrics, and even reflect poorly on you as the sender of this information to colleagues or customers. When the number of duplicate records in a data set grows, the ultimate effort it takes to clean up is growing along incrementally as well. The easiest way to deal with duplicate records is to establish a way to prevent them from being created in the first place. Now with Formula Queries, there is a way to do just that, by querying the table, and returning an alert window with an explanation as to why the record is unable to be created by the user. In the above example, a Formula - Multi-select Text field is querying the table and populating itself should any records meet the requirements: General Formula Queries Tip: When writing formula queries, unless absolutely necessary, turn off the searchabl
How to do I make this work?If([PROJ HANG NOTE]<>"","ALERT",If(IsNull([ORIGINAL PROJECTED START DATE]),"PENDING",If([ORIGINAL PROJECTED START DATE]<=TODAY() or within next 15 days, "STARTED?",If([ORIGINAL PROJECTED START DATE] is within 16-20 days of today, "START NOW",f([ORIGINAL PROJECTED START DATE] is within 21-30 days of today, "START SOON",If([ORIGINAL PROJECTED START DATE] is after 31 days of today, ,"ON RADAR")))))------------------------------BuildPro------------------------------
At EMPOWER2019 in Miami, Senior UX Designer Lisa Sawyer shared some awesome tips in her session Quick DIY solutions for beautiful & user friendly apps. Do yourself a favor and carve out an hour to check out this highly informative session. If you only have a few minutes to spare, check out this quick video highlighting my favorite tip: using HTML in Rich Text Formula Fields This is a great technique to quickly add some color and style app by highlighting key data points or KPI’s for your end users. Here is the code snippet that is used in the video: "<div style=\"color:#74489D;font-size:350%;font-weight:bold;\"align=\"center\">"& ADD YOUR FIELD &"</div>"& "<div style=\"color:#gray;font-size:150%;font-weight:bold;\"align=\"center\">PLACEHOLDER TEXT</div>" To learn more about which HTML Tags are allowed by Quick Base, click here ------------------------------Freddie Sabbs fsabbs@quickbase.com------------------------------
Hello. I have a PROJECTS table, DAILY REPORTS table, and a MONTHS table. daily report table is a child of the projects table.The daily reports of course have the date that we work on the project. There could be one daily report but there could also be 10 daily reports associated to the project. I have created on the MONTHS table a field to get a list of projects that we worked on each month. I have been able to get this HOWEVER, if they worked that project on 5 days that month, the project shows up 5 times on the list. the formula I am using is : var text QUERY="{38.OAF.'" & ([Month Start]) & "'}AND{38.OBF.'" & LastDayOfMonth([Month Start]) & "'}";ToText(GetFieldValues(GetRecords($QUERY,[_DBID_DAILY_REPORTS]),173))fid 38 being the date of the daily report. and fid173 being the related projectwould also be great if I could put them in alphabetical order. Any suggestions on how to get rid of the dup
Wondering if anyone has used fetch() in a code page in place of XMLHttpRequest().Success? Failure? Confused? ------------------------------Jim Harrisontransparency = knowledge + understanding : The Scrum Dudes------------------------------
Looking for assistance on how to capture some data.I have a table (Tracking Log) that will be used to log information about invoices that are being routed for approval. This table relates to a Routing Matrix table that will hold names of persons that will need to review and approve said invoices. The Routing Matrix will hold dynamic information so from month-to-month the names for a specific route might change. Since my Tracking Log is pulling in data from the Matrix should that data change then so to would my Log. However, I want to capture the names of persons that actually reviewed the invoice at the time it was sent out. Added to this is the possibility that for a given invoice we might need to override the default names from the Matrix as a one-off situation.So in my Tracking Log I have created several fields:Matrix - Approver 1 (lookup field): linked related field to Routing Matric tableOverride A1 (checkbox): to indicate if a one-off chan
Hi All,I've got a formula query like so:GetFieldValues(GetRecords("{865.EX.'"&[Name Current User Email Text]&"'}","abcdefgh9"),649))First, I couldn't figure out how to get the formula query to work with user fields, so I got it working with a text field. I think it has to do with the expression operator, i.e. "EX", but I couldn't get it to work with any others.That query, if ToText is put in front, will produce results like this:11-25-21 ; 12-06-21 ; 12-07-21 ; 12-08-21FID 649 is just a date field. What I want to know is if any of those values are less than ToText(Today()). How do I do that?Thanks,------------------------------Daniel Johnson------------------------------
Is there a way to highlight a checkbox field on a form?It does not need to be conditional, I would just need the checkbox field to always show as highlighted.------------------------------Allison Corriveau------------------------------
I've been slowly teaching myself Python for a while, and have just uploaded an early version of a library to interact with the Quickbase RESTful API. It's very rudimentary right now, but the one fully functioning thing is the ability to backup as many reports as you like in one Quickbase app to local JSON files.This would built for my own use, but I thought it'd be fun to turn it into something that others might find helpful.Download Python (tested up to Python 3.9), pip install the module, create the reports in Quickbase you want to backup (just add 'BACKUP' to report title), and then three lines of code will download and generate local JSON copies.https://pypi.org/project/my-quickbase/
I am trying to backup an app and I keep getting "File to Large" when trying to download. The table is 4,500 lines long and I have removed all the fiends not needed but still getting file to large. Any idea what I am doing wrong?------------------------------Kyle McAfee------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.