Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Is this the correct format for this query?: {1459.EX.'1'}AND{757.EX.""}AND({25.EX.'New'}OR{25.EX.'Assigned'}OR{25.EX.'Scheduled'})Is that the correct syntax to check if a field is empty? 757 is a URL type field.------------------------------Jeff Peterson------------------------------
Hello,I'm using a Text as a Key Field - [Charge Code]The issue I'm running into is that whenever i change the [Charge Code], it disconnects the child records associated with it. How can i make it so that the Related Charge Code for the child record updates when the Parent's Charge Code is changed?
Hey all! We've developed a codepage that our users land on and, for the most part, it works wonderfully. However a small subset of our users are encountering a situation where the background image doesn't display (shows a broken image icon). We haven't identified any obvious similarities between the subset of users (browser, extensions / plugins, etc) that help us identify what is causing the issue.We have a table inside our app called "Images" and we've copied the full path to the image into the code page. Again, for most users, it works perfectly. Does anyone have a better suggestion for how to path that image file so it more consistently shows for our users?Sample code: <img class="my-image" src="https://myrealm.quickbase.com/up/111222333/g/rb/eh/va/myGreatImage.png" /> For clarity, I do have the correct realm in our actual code. Also, the '111222333' is the table ID of the Images table within the app.Suggestions appreciated!--------
Trying to figure out if this is a bug or what is happening.Sequence of events:Adding a parent using the native a=nwr type add, then while in add mode (before saving) add a child with add record API while setting an additional field. Parent autosaves when adding child (due to checkbox in advanced settings). All works great. Additional field is filled in.Now, repeat but instead of adding the parent using native a=nwr, add parent using Add Record API while setting an additional field on the a parent. Repeat same steps as above. This time, when adding the child, the additional field does NOT fill in correctly. Instead, it fills in the record ID of the parent. Even the URL when you click the add child button is really bizarre looking.ADD child URL in scenario 1: https://mycompany.quickbase.com/db/bsqfqqnke?a=API_GenAddRecordForm&_fid_24=16&_fid_10=test&z=ch7vAdd child URL in Scenario 2https://mycompany.quickbase.com/db/bsqfqqnke?a=API_GenAddRecordForm&_fid_24=16&masterRi
Hello,I have a master table of all the parking passes for a company. In it, I have the following fields:- Tag #- Lot Location- StatusI'd like to create a form that will allow the user to enter the action; whether it's a new issuance or return of a parking pass, or a reassignment. If it is a reassignment, they will need to enter in the tag # for the newly issued tag, as well as the returned tag #.Where I'm tripping up, is I need to create a relationship from the form to the table against the tag # twice (once for returned pass and another time for issued passes). Right now, I was able to have the field in the form twice, but it references to one another where I cannot enter two different parking pass #'s independently. Is this possible?Thank you! ------------------------------V W------------------------------
Hi everyone, I have a table of contacts that I am using for a spec credit registration app. The nature of the app is it is a new app connected to my main ERP app called Team Elite. In this spec credit app I have a table called Spec Credit Program. It has a relation to the Companies table in my ERP app (Team Elite). In the Companies Table I added a new relationship to my contacts table so that I can select the contact I need to send the spec credit registration too.The issue is I need to get the email addresses (field in the contacts app) UP to the Companies table and DOWN to the Spec Credit Program table in the other app. I cannot figure out how to create a combined text list of email addresses up on the companies table. How do I summarize email addresses in the relationship?The app structure is:Companies (Team Elite) < Contacts (Team Elite)Companies (Team Elite) < Spec Credit Programs (Elite Spec)Table Name (App) <=one to many relationship
Hi Everyone,I've 2 fields need to be used in formula field - Meeting attended (field type checkbox) and vote (field type text). If not attended the meeting and still registered vote then new formula field should show text "not attended but still saved vote" else can keep this formula field blank.I'm writing like this but getting error, please advise what is missing. If([Meeting Attended?]=false and not IsNull([Vote]),"Not attended meeting but voted", " ")------------------------------Mrunali Kadam------------------------------
Hello,I have 3 tables within the same App:1. Claims2. Report Summary3. Report Summary CopyThousands of claims will be funneled into the Claims table with many different company names and plan years each day. (The same company may have several plan years, which means the same company may have several different report summary records)I currently have a numeric-formula field named [field 1] within the Report Summary table that is a query which searches for specific details within the Claims table and sums the dollar amounts. This works perfectly.I would like to completely wipe out the Claims table at the end of each day, however, that will delete the summed values within each record housed under the Report Summary table. My thought process was to create a Report Summary Copy table, delete the query code within the numeric-formula [field 1] of the Report Summary Copy table and then create a pipeline that runs daily and essentially does the following:SUM([Field 1]+[Field 1 (copy)])When this
Hello,I need a formula for date on or before last Friday....If([PAYROLL START DATES] on or before last Friday,"RED", "#FFFFE0")thank you------------------------------BuildPro------------------------------
Hello, Our company is about to spin off a portion of our business. The new company will be creating a new realm for them to take their applications and data with them. There are some vendors and contractors who will continue to support the legacy company as well as the new company.Having said that, do those "shared" vendors/contractors need to have separate login ids for each realm or can they use their same login (assuming they are invited to the new realm) on the new realm as well as the legacy realm? Thanks in advance,Andrew------------------------------Andrew Rowe------------------------------
I have a Pipeline that is supposed to trigger when a record is created in the Instances table of my Inspection Gadget app. See below for a photo in GUI and YAML export snippet. Anyway, the Pipeline last worked on Monday, and has not been changed or updated since then. Today, when I try to create a new Instance, the Pipeline doesn't trigger. In the live Activity Log, it just gives me an infinite spinning wheel while "Waiting for a Record Created event in Quickbase…" Any ideas why it's not picking up the trigger?- TRIGGER quickbase[qDOL53p] record on_create -> a:inputs-meta:export_fields: 32, 33, 35, 36, 34, 22, 49, 21, 19, 52, 50, 53, 51, 12, 55, 56,54, 57, 58, 59, 60, 61, 62, 65, 66, 64, 63table: brckh5whk- a<>ACTION quickbase record update -> b:inputs:[redacted]------------------------------Aaron Alpert------------------------------
I was wondering if it was possible in the customRedirectURL to add a different field (and it's value) at the end of the URL. For example, in my code below, the record ID is what is populated at the end of the URL: (xxxxxxxxx is just a placeholder)console.log(req1);//******ADD YOUR DBID$.ajax({url: "xxxxxxxxx?act=API_AddRecord",type: 'POST',data: req1,contentType: "text/xml",dataType: "xml",processData: false,success: function(data, status, xhr) {var _rid = $(data).find('rid');var rid = _rid[0].innerHTML; var customRedirectURL = "https://xxxxxxx-xxxxxxx.quickbase.com/db/xxxxxxxxx?a=dbpage&pageID=2" + "&rid=" + rid;console.log(customRedirectURL); window.location.href = customRedirectURL; }});}instead of +rid can i use another field from the table there (field that is set by a variable)? This does have to be in a code page and not in a URL formula field or form button, etc. Thanks so much!------------------------------Lija Harris------------------------------
Does anyone know how to make the background color of form field white instead of grey when you open the form in view mode?------------------------------Charlene Dougall------------------------------
A little bit of background, Currently, we're trying to connect to an endpoint to retrieve some critical data from ADP, as well as have a Pipeline that ADP can connect to in order to retrieve data the other way. In addition to using OAuth, these endpoints require a signed SSL certificate when attempting to connect. However, it doesn't seem like there's any way to make a pipeline "point" to a signed certificate before connecting. Has anyone else had this problem before, and if so, how did you solve it?------------------------------Kyle------------------------------
Is there a way to create a field/column that is a required field, user input and formula field at the same time (without using automations or pipelines)? The scenario is I have 2 columns:Column 1 is a required & user input field.Column 2 is a formula field. If column 2 has value then column 1 can be left emptyORIf column 2 has value, copy value to column 1 only if it is empty (since it is a required field) Or do I not have choice but to manually input a value in Column 1?
I have a use case where someone will call in and give us an address and we are to instruct them to the nearest location based on the address that they give us. I have a csv file with the locations that I need to map and they have full addresses as well as the geolocation of the addresses. I am having trouble doing this inside of the form. Is there anyone who has done this?------------------------------Jeff Brooks------------------------------
Harder Mechanical has learned this week that use of URL query parameters when calling a report (such as in a formula rich text button) is not supported by the new style timeline reports, and is not planned to be supported. The current solution to see the correctly filtered report is to slide the 'New style' toggle to the off position.We have also learned from QB that while use of query parameters in a URL string in a formula rich text button is currently functional with new style table reports, this use case will not be supported once the old style table report is retired and the toggle switch removed.Reference QB Ticket 692460api guide - Components of a queryQB has not yet provided a timeframe for when URL query parameters will go end-of-life. The application engineer is working on finding more information.From a security perspective, we can understand not wanting to allow the use of app or user tokens in a URL that can be seen from a formula rich text button. Howeve
Does the Audit log show something when a record has been deleted?------------------------------BuildPro------------------------------
I am trying to display the last pay date for each month. The formula querya returns a list of the pay dates in that month, but I am stuck on how to find the highest date in the list.//FID 8 = pay datevar text myquery= "{8.GTE.'"&[First of Month]&"'} AND {8.LTE.'"&[Last of Month]&"'}";var text querya= "{GetFieldValues(GetRecords($myquery),8)}";Max(ToDate(Part(ToText($querya),1,";")),ToDate(Part(ToText($querya),2,";")),ToDate(Part(ToText($querya),3,";")),ToDate(Part(ToText($querya),4,";")))------------------------------Anne Martin------------------------------
I saw this solution somewhere but don't remember. How do I use an old value of a field in the record that is triggering a pipeline? I want to put the old value in a new field sort of the way a snap shot works but I am don't want to use a look up field as the source of the old data.------------------------------George Bramhall------------------------------
How would i set up a form rule to display a window prompt if a field contains the word "Solder"? My options are limited to Equals, does not equal, >, <, is between, etc. ------------------------------Michelle Coslet------------------------------
I need to generate a record for each day in the month for the next month. (there are several child tables that will be associate with each day so I need the base days for the month). I have a miscellaneous table that has the first and last day on the next month, but using a search step performs one iteration. I thought about incrementing and then doing an on event step. I have not been able to figure out a way to make a pipeline iterate through to create the records. Any suggestions would be appreciated.------------------------------Julie Meeker------------------------------
Hi,Have a common calculation which is being used multiple time (formulas) with a Form. Is it possible to move this formula to a function within a code page and call as required from within the Form.This will future proof my application, as any updated to the formula at the code page level will be automatically utilized within the From, removing the risk of having to update multiple instances of the formula.RgdsPatrick------------------------------Patrick O'Neill------------------------------
Is there any way to find any user fields where I have a certain default user?I tried searching in the App Mgmt and it didnt work, unless maybe there is a trick to the syntax when looking for a default user?Essentially, someone is leaving the company and I need to make sure they arent the default in any user fields.------------------------------Mike Tamoush------------------------------
Hello,Are you able to send automated emails that specific who the email should be addressed TO and would should be on the CC line?Thank you------------------------------V W------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.