Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
HelloI remember QB asking if the field I am creating is a key field or not; but I am not able to get back that option. I can go to fields and change the key field.But I want to concatenate 2 fields and make it a key field. I saw this option too but I am not able to find it again.Region Customer SalesNA 1001 200NA 1002 300Key: Region + CustomerIf I upload a file with NA and 1001, I expect QB to not to create a new record or say duplicate but overwrite NA 1001 combination.Thanks!------------------------------Siva------------------------------
I have a field that is hidden in my form view by a Dynamic Form Rule. The rule states that if the field is blank to hide it. However, when I enter edit mode from the Form I still can't see the field. How do I make this hidden field appear when a user edits the record?I'm only hiding the field if it is null to help clean up the look of the form view.------------------------------David Semitekol------------------------------
Hello, I have created a formula that reads my multiple choice fields and converts them to numbers (there are 2 multi choices and this show how much of each were selected). Now I'd like to make ap ie chart that shows those totals. Here is what I mean. I want a pie chart for the highlighted information. ------------------------------Meagan McOlin------------------------------
There is new formatting options when making a notification, which is great. However, I noticed it auto-inserts a blank line every time you have a line break. So for example if I want this:Line1Line2Line3I can only seem to get this:Line1:Line2:Line 3:Does anyone know how to remove the blank lines? In word, you would click ' Don't add space after new paragraph'. But this isn't word...------------------------------Mike Tamoush------------------------------
Does anyone know how to get the API Response information to be able to utilize it in a redirect? I have a button where I 'replace' a part, I want to show the new part after the API_Add Record call. I can't seem to find it anywhere. If I omit the &rdr line I end up on the API response, which clearly shows the new rid. Button code belowAny thoughts would be great! Thanks in advance.var text url = URLRoot() & "db/" & [_DBID_TEST_PARTS] & "?a=API_AddRecord" &"&apptoken="&[app token] & "&_fid_73=" & URLEncode([Related SPARK Test Item]) & "&_fid_75=" & [Header - Label Header (ref)]& "&_fid_80=" & [Related SPARK]& "&_fid_205=" & [Fit Condition]& "&_fid_135=" & [Additional Info]& "&_fid_223=" & [Record ID#]& "&_fid_125=true"& "&_fid_72=" & $uselabel& "&_fid_123=" & ([Replacement Counter] + 1)& "&_fid_127=" & [Full La
HelloI'm new to quickbase. I'm working on an application for equipment records management.Workflow is... .csv file in Gdrive > Master Table (connected, exact) > User Table(parent-child relationship) with only the additional dummy record columns in display for user inputs purposeGdrive > Master Table works as intended.Master Table > User Table works too though not fully in shape as intended.But as I try to put them together in a complete flow Gdrive > Master Table >* User Table, only the blank records are filling up in the User Table as noted with *. No records populate in the lookup field after creating a relationship. So, I had to import the records and the resulting records turned out to be null.Any thoughts on where to look into? I really had no luck finding out where and how the flow gone wrong.------------------------------Jinyoung Youn------------------------------
I've been stuck on this for a bit.So I am trying to pass JSON from a quickbase webhook to Everbridge, but quickbase is separating the multi-select values by semicolons instead of commas. If I try replacing the semicolon with a comma using a formula, JSON ends up treating the list as a singular string. If I try adding double quotation marks, the backslash comes through on the webhook so the JSON still treats everything as a single value.Anyone ran into this problem before or know a way on getting the multi-select field to pass through proper JSON on the webhook?------------------------------Mark Laudon------------------------------
Hello, I'm trying to use the new dashboards for a project I'm working on, and for some reason, when I try to add a line graph or pie chart to it, it won't let me. I tried to add it by searching for the table the report is in, and then searching for the name of the report, but it's not there. Also, when I search for reports in that particular table, the dashboard only pulls back 109, whereas I can see there are roughly 220 reports on that table. I've already added summary reports and bar charts to this dashboard. Is there a setting I'm not considering? I thought almost all report types were supported for the new dashboards now, and certainly charts should be.------------------------------Harrison Smith------------------------------
Hello,I am with SERVPRO. We have just under 2000 locations in the United States. Im looking for a way to enter an address, or zip code, into a field and have Quickbase give me a list of all locations within a set parameter. Has anyone created anything like this?------------------------------Lenny Brooks------------------------------
Has Anyone used the scanner feature on a tablet and if so, how did you get it to work properly?------------------------------Ketsia Fidelia------------------------------
Two part question, thanks!1. Does each user have a unique numerical ID, and if so, where can I find it?2. Can I use the numerical ID with the ToUser function? I ask because I realized that if a user changes their email address, anywhere that I use their email address in a 'ToUser' formula, will break. I was thinking that maybe if I use the number, it would always remain the same?------------------------------Mike Tamoush------------------------------
Please bare with me as I am completely new to this. I currently have 2 tables connectedParent: Loan Child: Payments I created a custom form in the Payments table which has the id of 10. I added an "Add Payment" field to the parent table and this is the formula of the field:URLRoot() & "db/" & [_DBID_PAYMENTS] & "?a=API_GenAddRecordForm&dfid=10" & ([Record ID#]) The problem is it takes me to the default add form of the Payments table instead of the custom form I made. Can anyone help me with the correct URL formula and pass the data of the selected Loan record to the custom form?------------------------------Manuel Jeus Fernandez------------------------------
We have completed a soft launch of a large Project Portfolio Management application that will be rolled out to ~150 users on Jan.3.2022. We have a known design problem that needs to be resolved prior to full launch. Situation: Approximately 25 of the users are Project Requestors (Stakeholders) that during the 'Project Intake' will need to create a new project, complete a detailed definition, identified impacts to value chains, complete a prioritization matrix and add scoping attachments. All fields with the exception of attachments are on the PROJECTS (parent) table. The Attachments are on an ATTACHMENTS (child) table. The Requestor will need to save the project at least twice (once to create the record before the attachment files can be attached and again when they have completed their work). We have also encouraged them to Save & Keep working so as not to lose part of the detail. After the initial completion
Have a scorecard where the metric may be a total or an average. Based on that setting, trying to build formula rich text to show the appropriate data. Got half of it working for Total. How would I expand to support Measurement being an Average or another measurement type?If([Measurement] ="Total",If ([2022 Actual YTD] < [2022 Target Low],Case([Metric Type], "Currency", "<span style='color: #FF0000'>"&"$"&ToFormattedText(Round([2022 Actual YTD],0.01),"none_dot")&"M"&"</span>", "Percent", "<span style='color: #FF0000'>"&ToFormattedText(Round([2022 Actual YTD],0.01),"comma_dot")&"%"&"</span>", "Number", "<span style='color: #FF0000'>"&ToFormattedText(Round([2022 Actual YTD],0.01),"none_dot")&"</span>", ""),If ([2022 Actual YTD] >= [2022 Target High], Case([Metric Type], "Currency", "<span style='color: #228B22'>"&"$"&ToFormattedText(Round([2022 Actual YTD],0.01),"none_dot")&"M"&"</s
Hello Community,We are seeing gateway errors and wondering if anyone else is seeing too. I submitted a ticket to QB Support. Also looks like AWS is having problems https://status.aws.amazon.com/, uncertain if it is related. ------------------------------Jim Harrisontransparency = knowledge + understanding : The Scrum Dudes------------------------------
Hello All,I'm new to QB Dev and I had a question. Say you have two tables on two apps and you wanted to pull data from one app to another without copying or exporting the data to the other app. Is this possible?------------------------------Kevvin Carter------------------------------
In our app we converted 400 projects that had historical SPONSORS as a text field. Approximately half of the projects are closed so we plan to keep a Sponsor-Historical (text field) for closed projects. Approximately half of the projects are active so for these we will invite the Sponsors to become QuickBase users. As they become users we will assign the project to a Sponsor-User (user) field. Some Sponsors choose to not become users the project needs to retain the Sponsor-Historical (text) field. In our project header we want to display the Sponsor Name cleanly with a formula text field that chooses the UserToName version of the Sponsor-User field if it exists, otherwise choose the Sponsor-Historical field if it exists, otherwise display a null value for the displayed version. Note: We were struggling with the If Statement so we chose to create a separate formula text called SPONSOR-UserToName field to confirm that the UserToName con
Has anyone used the new feature that allows you to grab the record ID from a custom Rich Text button on an add record form? Ive used it once successfully, and now am completely stuck on why i cant get it to work again.In my code below I am trying to pass the new record ID to field 57 in my addcontract variable. (57 is a numeric field). But instead of the new RID it inserts 'id'. I've tried wrapping with URLEncode, no luck. Thoughts?var text AddContract = URLRoot() & "db/" & "brgdpr9fn?a=API_GenAddRecordForm" & "&_fid_12=" & URLEncode ([Related Vendor]) & "&_fid_57=" & "%%rid%%";var text EditUserFocus = URLRoot() & "db/" & "bp8yr9i5s?a=API_EditRecord" &"&key=" & UserToEmail(User()) &"&apptoken=xxxxxxxxxxxxxxxxxxxxxxxxx" &"&_fid_220=" & [Service Order - SO #] & "&_fid_224=" & [Related Service Order];"<a class='SaveBeforeNavigating' data-replaceRid=true style=\"text-decoration:none; background: #4b7097;
Do I have to submit a support ticket to add a realm admin to our realm? As of now, I am the only realm admin for our realm.
I need to update a date to the current date each morning depending on the value in two cells, then update that same field in a different app. For example If a job is a multiday site and the work is not complete I want to change a date field in the table and update a corresponding field in another app. What is the best approach for this situation?------------------------------Paul Peterson------------------------------
I have my QuickBase apps connected to Microsoft PowerBI. The issue is that when I set up PowerBI to automatically refresh the data from QuickBase, the system times out before it can be completed. I am going to upgrade to PowerBI Premium Per User which offers incremental refresh capabilities, BUT it needs to be connected to a back-end system that supports Power Query's query folding requirements. Here's a summary of what Query Folding is:Query folding - Incremental refresh is designed for data sources that support query folding, which is Power Query's ability to generate a single query expression to retrieve and transform source data. Most data sources that support SQL queries support query folding. Data sources like flat files, blobs, and some web feeds often do not.Microsoft Documentation: https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overviewThe question I have is whether QuickBase will support query folding. ------------------------------W
Hi.I have a drop down menu with Option A, B, C, D in a form.I configured Dynamic rules in the form but I am having a conflict due to the "otherwise" default option.RULE #1When Option A, Action: Hide "RAN" fieldbut there is an "otherwise" default option: Otherwise: When different to "Option A" Show "RAN" field According to the "otherwise" default option, "RAN" field will be shown when the selected field is different to "Option A" but I have a second rule where I hide the "RAN" field when "Option B" is selected.This creates a conflict between the first and second rules and it is not possible to combine both in one rule. Please, any idea about how to figure out this issue?Thanks ------------------------------Ivan Gallegos------------------------------
I am trying to incorporate a method to grab four specific fields from an AthenaHealth database. (Right now I'm using a 'sandbox' data table, with Dr names, Encounter dates, Type of visit & location. I have created a Quick Base table with the four fields and have some actual data.What I need to be able to do is on a regular basis, (ie daily or weekly) add the new encounter (the four fields of) data to a new record in QB which has just these four records.I am thinking that an App with a code page which calls the QB API create record, probably using a Pipeline. The code page I'm thinking will first have to check the AthenaHealth data table for all the new records since it was last run. I would like this to be on a regular schedule though for testing I could just create new 'sandbox' records and then run the Pipeline manually.There are several scripting languages that can be used. One of course is Python, which I have learned a bit of and the other is JavaScript, though the t
Hello I am in the process of creating a table by automatically uploading from SFTP server.Assume that I have a table with 1000 Customers X 10 Column with customer details. Say these 1000 customers are from 10 states and I want to give the user an ability to mass change customers in his/her state. Say, the user filters Texas and would like to mass change address of 20 out of 100 customers in Texas. How can one copy and past from excel into QB table that can allow updates of multiple customers at the same time.Thanks!------------------------------Sivaram Bhandaru------------------------------
I have a group of summary date fields of which I would like to select the most recent date and use that in a formula. I can't seem to find any functions that can compare a bunch of dates and choose the most recent.------------------------------Dante Tognoli------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.