Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
When editing a formula in the new formula builder, for example in a rich text field, where you position the cursor and where the edit takes places is not correct. For example I can position my cursor after a field name such as [fieldname] and start typing, but the text I type appears about 4 - 5 characters to the right in the middle of another part of my formula.Is anyone else having this problem? It's the same in both Safari and Chrome
I have a number of Formula fields in my database which are searches of my database based on the contents of another field. The general form is this:URLRoot() & "db/" & Dbid() & "?a=QuickSearch2&srchtxt=" & ToText([<SOME FIELD>]) &"&exact=false"(This approach may be out of date now, but it was current when I built the original database in 2017). Here is the problem: The fields that get displayed are determined by which fields are designated as "This field may be used in reports." However, what I want is way to differentially control which fields are displayed, depending on which fields are being searched, whether this is done as part of the formula, or through some other mechanism.For example: Assume I have 4 content fieldsCategory, Manufacturer, Salesperson, Location.And two "search fields" using the approach above:Search_Category: URLRoot() & "db/" & Dbid() & "?a=QuickSearch2&srchtxt
I tried to utilize the following formula to change the background color of my multi-select text field in the event that the new value changes from the old value: If([Value - Old]<>[Value - New], "<div style=\"background-color:#ABD4CD;\" >"&[Value - New]&"</div>",[Value - New])I used THIS video to create a change log, but I am unable to use the formula above to change the background color of newly modified multi-select text fields. Does anyone have a workaround for this?------------------------------S S------------------------------
Are all QB notifications No-Reply no matter the sender?
I've searched through the QB discussions and couldn't find a good example of creating a many to many relationship where I can select records from the same table. I have the relationship working from one table to another and visa versa but I'm stuck now when trying to pull a record from the same table (see attached).Here's an example of what I'm trying to do...I have one table named Guests and a second table called NonGuests. Both have a relationship setup to a third table called, "Related Guests". The Guests will have either family members, friends, etc... who are NonGuests. But, there are Guests who have family, friends, etc... that are also Guests.The issue I'm having is, when I create a Related Guest I need to pull a record from the same table because there are Guests who are related to other Guests. Am I overlooking the obvious?Any suggestions would be great as from what I've read you shouldn't create relationships with "Guests with many Guests".Thanks!
Hello!I am trying to figure out a way to capture the URL of an open form when a record is opened in Edit Mode. I need to run numeric calculations differently when a record is in Edit Mode vs. View Mode and thus need a signal to verify which state the form is in. My idea was to capture the URL and use Text functions to identify if the URL contained the "er" vs. "dr" as a signifier of which mode the form was in. Most of what I could find uses JavaScript. Is there a way to do it without JavaScript? I suppose all I need is the URL displayed in a text format, like pictured below.Thank you!
Hi,I started migrating automations to pipelines. Yesterday, I could easily access the timestamp indicating the last triggering of a pipeline directly on the table. However, as of today, I am not able to see on this table anymore. The only method to view the last triggered time is by clicking on the three dots and navigating to "View Activity." Is this a potential problem for our pipelines?
I would like to create an APP to manage my field teams in the construction of fiber optic networks, also the entire project such as allocation of maps for teams, production information, finance, control of tools and expenses such as fuel.Este é o meu primeiro contato com quickbase, gostaria de saber se existe uma maneira de encontrar um freelancer que possa fazer isso por mim.Para o relatório diário das equipes que já utilizo o FastField, uma integração entre as plataformas seria interessante também Obrigado
Hello -Is there a way to limit the number of cards displayed on the Quickbase Kanban board? Currently, I believe the limit is set to show 100 records. I know filters can be used to bring that number down, but we do not have a common filter. Is there a way to set an exact limit on how many cards are shown in each swim lane?Thank you!
Hello,I'm attempting to setup a Pipeline which checks to see if a record has two Numeric Summary Fields which equal each other, and if they do, it updates a multi-text status field from "Assigned" to "Delivered."When attempting to create the Pipeline, I've been struggling to get it to run. When attempting to set the filter so that it checks if Field A equals Field B, it seems like I can't check Field A against another field specifically, only enter a value of my own. I thought about getting around this by using a checkbox formula on the record which says if Field A = Field B, true and then having the Pipeline filter be setup such that it runs when the Checkbox field is true. However, the Pipeline never seemed to trigger off that Checkbox, even when it was changed from unchecked to checked.Is the issue that I'm not actually updating the record, but instead Summary fields which are being updated? If so, is there any way around that? Thank you in advance.
Hello. I'm looking for some assistance/guidance with reporting for our QA team. We have multiple apps built for different review types. We would like to have a separate report or maybe dashboard that could show how a specific Line of Business is doing as a whole across all different types of reviews being completed.For example, we have an app for Review X, Review Y, and Review Z. Each of those separate review processes provide great reports for that specific review. We want to pull data from Review X, Review Y, and Review Z to show how a specific Line of Business is performing across all reviews. Kind of shooting for an end result overall QA score for each LOB.Would this be a time to utilize the table to table relationships or what would be the best/easiest way to create this type of report or dashboard? Our team is new to the QuickBase world and have been using since March 2024. Thanks
Hi Everyone,I'm looking to automate via pipeline a way to email a form just like the new option when viewing a form (see attached pic). I'm not sure it's possible and I tried searching for a solution in the discussions.I know this feature is relatively new and thought I'd reach out to see if anyone has the same interest. I'm more interested in using the native "email" function like below than using GMail but if there's no other way, I'll pursue that route instead.Thanks!
Trying to add a span rich text field in the new form style. I have added a new rich text field, clicked "code" which made the background grey, but when I type in span, it still says span. I have tried adding <> around it but that does not seem to work either. ------------------------------Ryan Doble------------------------------
How to Force Index of File Attachment Field for Advanced Search? Can't See <Some Attached File> OptionHi Folks,The availability of the advanced search option <Some Attached File> seems random. Has anyone pinpointed how this works?I need to search within file attachments stored in a single QB table and have tried without success:Loading a single ocr pdf, setting the "Include this field when searching/filtering this table" option, then waiting 24 hours for indexing. No search option for "<Some Attached File>".Creating the file attachment field and setting the "Include this field when searching/filtering this table" BEFORE adding files. Then adding files and waiting 24 hours+ for indexing, but no search option for "<Some Attached File>".Removing other file attachment fields in the table. No change.One table has the search option for some reason, but I can't get the option to appear on any other table. Thanks!
Is there any functionality in Pipelines or the QB API that allows for fuzzy matching? I've been reading that there some APIs that have built-in fuzzy matching (Reltio, Search - Get Search Fuzzy - REST API (Azure Maps), Fuzzy matching | Dialogflow ES | Google Cloud), but could not find any such mention in the QB API documentation. I have a table of Vendors (about 4,000 records) that is being updated from our ERP using the key field, Internal ID. We often have to manually add "prospective" vendors to the QB application that haven't yet been added to the ERP. For those, an Internal ID well beyond the range of actual Internal IDs is used. A fraction of those "prospective" vendors get added as actual vendors to the ERP, which end up being duplicates in QB since their Internal IDs won't match. Yes, one option is to create the prospective vendors to the ERP first, but that's just not an option with our company's established controls. So, I was hoping I could build a pipe
Hi, I'm looking for help with a formula to display a field that is a Multi Select Test field and if blank display another Multi Select Text field.Example:If [LG Audit] is blank display [Out of Scope]. Is this possible?Thank you in advance.
Hey all,Have a client who's trying to kick off a reporting process and wants to make sure their data in the necessary connected tables is fully present by the time the EFPs are built. Part of that process is having multiple connected tables refresh, but they don't want to have to do this on the hour or go through each table and hit the button before starting the rest.Is it possible to have one custom button trigger those refreshes as part of its arguments?Thanks!
I have a formula rich text field called Last Opened Date with the following formula to trim a logged field so it only pulls out the date: Trim(Right([*Vista Last Opened Date (Log)],10)) In my report, I want to color code a field called Report Name if the date in the Last Opened Date field is more than 120 days before today. Can you please tell me what formula to use for this? I've tried several and nothing has worked. Thank You, Rachel Miller------------------------------Rachel Miller------------------------------
When I press this URL button it just hangs. Any ideas? I am getting this code from Magic ButtonsThe button:URLRoot()&"db/"&AppID()&"?a=dbpage&pagename=createchildsaveandedit.html&targetdbid="&[_DBID_Estimator]&"&referencefield=11"&"&rid="&[Record ID#]&"&apptoken=xxx"The code page:<!DOCTYPE HTML><html> <body><script>const urlParams = new URLSearchParams(window.location.search);const rid = urlParams.get('rid');const apptoken = urlParams.get('apptoken');const targetdbid = urlParams.get('targetdbid'); const referencefield = urlParams.get('referencefield');const xhttp = new XMLHttpRequest();xhttp.onreadystatechange = function() {if(this.readyState == 4 && this.status == 200) {const response = this.responseXML;const redirectUrl = "https://" + window.location.hostname + "/db/" + targetdbid + "?a=er&rid=" + response.getElementsByTagName("rid")[0].textContent + "&rl=bbv";l
I'm working on a Formula - Rich Text field ([Reject]) that creates a clickable "Reject" button as part of an Expense Report app. The goal is for a user to be able to type notes into a form and then click Reject to trigger other actions via API calls. It's pretty much a variation on the (awesome) Magic Buttons app's "20A. Edit record then add record then display record" field.The first issue I encountered was that the button wouldn't "know" the latest value of the [Notes] Text field that's being edited since it hasn't been saved/persisted to QB yet. A workaround for that was a [Current Notes] Formula-Text field with a formula of just [Notes]. Since it's a formula, it gets updated every time the user updates the [Notes] field.With that problem solved, the button almost works... Except there's a catch: If the user enters notes and -immediately- clicks the Reject button, then the formulas don't get refreshed before [Reject]'s current <a> link gets followed. This means the API ca
I have a field that utilizes Javascript to create pdf documents using an external server. This was setup back in 2019 before the ability to utlize Javascript was eliminated. It has been working fine for 5 years now but all of a sudden today it is no longer working. The page just spins and never creates the PDF document. Does anyone know if Qbase has implemented something where the old fields that utilized Javascript are no longer working?
Not sure if anyone would be able to help with this due to not much info. I have a connected table from another Quickbase app and keep having a refresh error. The history says, "The error was: Error parsing record. Tracker ID: [565bjjqqr2a2]" which I can not figure out why. When I search this error I just see "Error parsing csv.". Could anyone explain what the parsing record is and what is the Tracker ID?
Hello! I am attempting to create a color coding for a multi-list field pulled from another application. But am having difficulty with creating the formula. Utilizing this article: Color-coding fields – Quickbase Help. I created this formula: However the"=" is saying that can not be used for textlist, text. I have tried "contains" with multiple errors. Any help is appreciated. Thank you!
Hello,I created a new app which helps give a high view of the entire realm (all apps, tables, fields, reports, requests, etc). On this app, I have a user's table, which is populated by the admin console connection. I have added to this table to include department, user contact phone number, state of residence, etc. I am trying to figure out a way to "force" them into filling their information out on this single table. My idea is to (if possible) show them a dashboard with just a single button for them to edit their user information, or hide all other tables until they edit their user information on the user table.Hopefully I am just overthinking it and it's a simple fix.Any ideas?
I would like to know is it possible to have a value populated for the drop down field in the grid edit in the embedded report on the form. My try is to use the same table for multiple section to capture the child record. So i was trying to have multiple embedded report for each section and I was trying to populate the different values for each section in the grid edit in the parent form for the same field. any suggestions would be much appreciated.------------------------------Murali Lokesh raja------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.