Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello! Is there a way to add an Embeded Report from a form to a MailTo email? I have a button on a form to create an email based on the current record. The form has an Embeded report for each record. Is there any way to pull the embeded report for the specific record into the email generated by the button? Example: "mailto:"&""&[Email 1]&"\n"&"?subject="&"\n"&[Record]&""&"&body="&"Location Name: "& [Location Name] "%0D"&"field2"&"%0D"&"field3"&--- NEED TO ADD EMBEDED REPORT --- ""------------------------------Meagan N------------------------------
Hello, I have a button that generates an email with fields from a specific record. If a field contains any contents with an &, anything below the & will not populate in the email. How can I ensure the Mailto Link allows & characters?Example: "mailto:"&""&[Email 1]&"\n"&"?subject="&"\n"&[Record]&""&"&body="&"Location Name: "& [Location Name] "%0D"&"field2"&"%0D"&"field3"&"" --- If Location Name for the records is AT&T, then the body of the email will be "AT" and nothing after... --- How can I ensure the mailto link copies the exact field contents without stopping at the & character? Thanks!------------------------------Meagan------------------------------
Hello,Does anybody know how to add B. C. dates in the date field (for example 1/1/500 B.C.)? Is there any way to this using date field or should I create a formula instead?Thank you------------------------------Aleksandra Rakita------------------------------
Given the new QuickBase dashboards and the direction QuickBase is heading towards with dashboarding (i.e., a more state of the art dashboard tool), do you think it's still worthwhile to use Power BI for dashboarding? I've been using the quickbase pages/buttons workaround for a while, which has been pretty effective, but felt limiting and clunky compared to Power BI and other dashboarding systems. And, while QuickBase's new modern dashboards seem very promising, they run very slow, only have up to 4 filters per page, and don't have nearly as many data visualizations as Power BI.I'd love your thoughts because I'm stumped. It'd be nice to have everything in house, but I also think (from what I've seen) Power BI dashboards just have much more capabilities. Thank you for any support,Hagos
We run a 3PL company and use Quickbase for our warehouse/shipping software and I'm looking to set up an alert email notifications to my Client's each individual customers when their products are shipped that includes Tracking Number and shipping method. Thank you------------------------------Reza Khazraei------------------------------
As you can tell from my recent posts, I'm going down the formula query rabbit hole. I would like a suggestion for getting a unique count for customers who subscribe to a specific service. I have the total count of sites calculated in this post: Formula Query - Size ? I know I will need the Size function and can get the total sites. I'm just not sure how to only return the unique customers.------------------------------Paul Peterson------------------------------
Hi,Is there a way to build a query that follows this function, but for quarters, not year?var text QUERY = "{7.OAF.'" & FirstDayOfYear([Month]) & "'} AND {7.OBF.'" & LastDayOfMonth([Month]) & "'}";Size(GetRecords($QUERY,"bru6bq226"))Essentially, I want exactly what this current query does, but with the quarter specified. I do have a 'Quarter' field that's calculated like this:If(Month([Month])<=3,"Q4",Month([Month])<=6,"Q1",Month([Month])<=9,"Q2",Month([Month])<=12,"Q3","")But I'm not sure how to utilize it in my query to specify the date range.I think I need this formula function:LastDayOfPeriod([Payment Date], [Quarter Length in Days], [Fiscal Year Start Date]) returns the last day of the quarter in which the Payment Date falls.But I keep getting Syntax errors when I try to input Quarter Length in Days. I tried to specify the # of weeks instead, but again, I couldn't quite get past the Duration p, Date r without generating errors.Can you help p
How to change button label? Like if the Lock status is locked change the button label to Unlock and vice versa.Please helpvar text lockStatus=If([Lock Status]="LOCKED","UNLOCKED","LOCKED");var text URLONE=URLRoot()&"/db/"&Dbid()&"?act=API_EditRecord&rid=" &[Record ID#] & "&_fid_9="&$lockStatus;var text URLTWO=URLRoot() & "db/" & Dbid()&"?a=dr&rid="&[Record ID#];$URLONE& "&rdr=" & URLEncode($URLTWO)------------------------------Ronali Panigrahy------------------------------
Does anyone know how to trigger a URL to fire based on the property of a separate field in a Form instead of needing to click a URL button? Background: My company uses a generic Form (dfid=11) for engineering support requests. If an Engineer from Group D is selected then the user gets redirected at that moment to a similar but separate Form (dfid=12). IOL Redirect that utilizes a QB Code Page was used to accomplish this but will no longer work with QuickBase's updates. The URL is this Code Page:https://[companyname].quickbase.com/db/brym9juux?a=pageedit&pageID=4The Field to trigger the URL:[EngGroup] = "Group D"------------------------------Christopher Job------------------------------
Hi everyone,I am relatively new to formula queries and love the power of them but am finding them super complicated to use.... I am trying to create a rich text field that will display employees that are on PTO the same day when I am entering PO for another user.So lets say I have Bob Smith and Mike Watts. I put in PTO for Bob Smith into my PTO calendar for 12/31. If Mike is already on PTO that day once I fill in the dates I want to have a rich text field that shows a table showing the name of the person, start of PTO, and end of PTO. This is the code I have so far based on a lot of googling and searching for videos but I am struggling here//Get a copy of all records in which the start date of PTO is on or BEFORE the new request AND the end date of PTO is on or AFTER the new request"<table>" &"<tr><td>Record ID</th><th>PTO Start Date</th><th>PTO End Date</th></tr>" &SearchAndReplace(ToText(GetCellValu
I am using the new formula queries to sum the total days billed in an unrelated table like thisSumValues(GetRecords("{96.EX.'" & [Record ID#] & "'}",[_DBID_BILLINGS]),120)I want to add another field like this just with one more query within it to just return the total days billed in the last 7 days and not sure the best approach.Thank you!------------------------------Ryan Locke------------------------------
Hello,Is there a way to check if an automated email notification has been sent out?We have several notifications set up that go out to a variety of recipients. Some say they are not receiving them, while others in the group are getting them.We may have a few that say they aren't getting them, but really are. So I'd like to see if we can look at a log or report to verify.Thank you!------------------------------Clarice Dennison------------------------------
I might make a formula text field, where say it checks a date and either returns 'Current Month', 'Previous Month', or else left blank.If I use that formula as a dynamic filter, the 3 choices are exactly that: Current Month, Previous Month, Blank.Any sneaky way to get rid of the 'blank' option? So they can choose only current month or previous month to filter? I could do an 'ask the user' filter on the date, but I really want it dynamic. I could make my formula text have else be 'all other months'. But would love a sneaky trick to get rid of the blank option.------------------------------Mike Tamoush------------------------------
Hello,I have not used query formula's much but am just starting to. One idea I have is for our purchasing portion of our app....We have one table "Inventory" to contain records for anything returned or that was not used at a project site that is available for future projects.We have another table "Order Details" that is used for line items to populate on our Purchase Orders when we are placing orders for product.I want to create a formula query field that will check to see if something exists in inventory and if it does display in big red text on the form that the product is inventory and to check their first. I know this can be done via rich text.Long story to my question but the question is how do I strip out misc characters? I know that my team will enter the model's differently. For example 2RSS is the same as 2R-SS is the same as 2R SSJust knowing human nature, those formatting issues will occur. So how do I take what is in the [Model] field and first
Hi All,Is it possible to use a field from the current record (I'm on a form) in a formula on a linked report? In this case, I've got a record with the length of a recording. The linked report is the schedules of people available to work on that recording. In that report is their start time, end time and their daily capacity. With that info I can calculate their speed per recording minute on that schedule table. Combining their speed from the schedule table and the length of the recording from the recordings table will tell me when to expect the work on that recording (generally) to be completed. Is there a way to do this?Thanks,------------------------------Daniel Johnson------------------------------
I have a daily automation that I would like to get a notification if it encounters an error. I do not see that option anywhere in the Automation configuration. Is that possible elsewhere?------------------------------Chris Sipes------------------------------
I build kind of a makeshift ERP system almost 10 years ago for a company I used to work for that ended up consisting of 4 different applications, each with multiple tables, and they are all connected via table and cross-application relationships. It was built that way because A) I was just teaching myself QuickBase at the time so I didn't really know any better, and B) I started out with just one small piece and my managers loved it so much they kept asking for new pieces, so I continued to add new branches and tying back into what was already built while the parts that were complete were being utilized on a daily bases. Recently I started working on a streamlined version of what I built back then as a new, single application, cutting all the unnecessary tables and changing up many of the fields that were in use to better options available now.My question is this, what is the best way to copy the data from the old version to the new version, and keeping the parent/child links on the ta
Auto number If statement
I am trying to set up an Automation where when the MCD PO: field in the Child Purchasing Record is no longer blank, it changes the Vendor Checkbox field in the related Parent Record to Checked. I have it set the way I think it should work but when I try it, it doesn't work. Mind you I am new to Automations so I probably have something obvious set up wrong. Can someone tell me what that is?------------------------------Chris Swirtz------------------------------
We have an app tracking locations. They'd like to be able to have a map show on the form and be able to click a location in google maps and add it to the address field. I already have lat/long fields linked to the address field (street1 and street2) but they want to be able to click on the map and add it automatically.
Hi,Two questions, which are probably a very new-user questions, but I'm stumped. I'm trying to build a summary table that uses formula queries to refer to data in other tables.Question 1: I want to count the number replies in a given field - the value returned is irrelevant, I just want to count the number of non-null values in this field:var text QUERY = "{7.OAF.'" & [Month] & "'} AND {7.OBF.'" & LastDayOfMonth([Month]) & "'}";Count(GetRecords($QUERY,"bru6bq226"),72)There should be around be a range month-to-month from 50 to 150.. with any text in the field, but the system just gives me '2' for each month. Why? Which leads to my second question:I thought perhaps maybe it was counting the number options available in that field, in this case, the response 2 would be the correct; so I tried to use it in another field where I need to actually count the number of communities represented at our events (between 20 and 40 each month), and it also on
Background When we took on the challenge of boosting our formula language, we knew we had to juggle three different and competing goals: Make things simple for builders trying to solve difficult business problems. Ensure end users have a delightful experience consuming what their builders create. Protect the platform – as we are a SaaS (Software-as-a-Service), we need to balance the traffic on the highway to ensure everyone has a great experience. To recap 2021, Quickbase formulas were taken to the next level with two major features: Formula queries: simplifying and expanding the class of problems Quickbase can solve. Summary report formulas: allowing you to perform advanced calculations on aggregate data. These are investments we made in our core engine, a special part of Quickbase that offers unparalleled flexibility and speed. As you know, all platforms have limits. Some more than others. We usually try and favor allowing creativity, with modest limits compared to other platfo
Is there a solution to integrating Quickbase to Outlook/Exchange for multiple users? I am looking for a way to send emails and calendar invites to customers through Quickbase but have the messages come from each individual user vs a single email address (it would be a bonus if we can track replies as well). I am open to all possible options. ------------------------------Chris Curtischcurtis@amerisave.com------------------------------
I have a new app I am building and trying to decide whether or not to use home page reports and just do the new Dashboards completely because I wasn't sure when they might retire the home page. I do like the new Dashboards for their functionality but they do load somewhat slow and if you are displaying a summary report they take up so much real estate versus the way they are displayed on the home page. Any suggestions to display like the home page?------------------------------Ryan Locke------------------------------
When i select an option from a multi-choice text field and i go to save the file, the "field ??? is required" error appears. I have combed through each field and rule and removed all requirements by either disabling the rule or removing the requirement. The error still occurs. It doesn't do this for all the selections in the multi-choice field, only certain ones. However, if i save it under a selection that doesn't give me the error, edit the file, and then select the option that gives me the error previously, i am able to save it no problems. i did check the forum for this and only found one post and tried what it said that it could be a possible hidden field or rule that is required. Hence why i removed or disabled anything that had a requirement. Any help will be appreciated as i am completely out of ideas at this point. At this point i think it is a corruption within this field or form.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.