Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I'm trying to connect to outlook for a pipeline I would like to set up, but when I expand outlook (or any channel) there is no connect button on the page. Is this an account limitation I need to have fixed?------------------------------Dante Tognoli------------------------------
*Subject should read ^to go to...This URL formula in the parent record, where the query formula field ([Get Suplicate Values] a multi-select formula field) is built, is giving me a result "Blocked". Can anyone identify why this formula is resulting in a Blocked result?var text recid = Left(ToText([Get Duplicate Values]),4);URLEncode(URLRoot() & "db/" & [_DBID_PROPERTIES] & "?a=dr&rid=" & URLEncode("$recid"))------------------------------George Bramhall------------------------------
I have a table named Projects. There are two child tables named Options and PO's. From the Add PO form I'd like to be able to "Add Options" to the options table by clicking on an "Add Option" button. The trouble I'm having is that when I click "Add Option" from the Add PO form, the "Add Option" form doesn't relate (auto-populate) the Project that the PO is related to, the related project field is blank and I have to manually type it in. I can't figure out how to relate the tables and fields so that the "Add Option" form knows which Project it's creating records for.Any suggestions are appreciated.------------------------------Aaron Lavender------------------------------
Hello:I have a pipeline that's submitting to Salesforce and I'd like to return the Salesforce ID after we posted, or grab the error, but we cannot, since the response is a serialized payload that cannot be changed from the Salesforce end - so it's coming over as an escaped string. It looks something like: {\"statusCode\":500,\"orderId\":null,\"message\":\"Internal Error Has Occured - Insert failed. First exception on row 0; first error: DUPLICATE_VALUE, duplicate value found: DTC_Order_Number__c duplicates value on record with id: 8014N000007z3Tb: []\"}"" Typically the first thing you do is destringify the payload so you can use normal JSON notation to navigate it. Is it possible to destringify before applying the regex in Quickbase?I tried using the following regex to extract the value I needed, which seemed to work on https://regex101.com, but Pipelines didn't like it:(?<=orderId\\":)(?=[^a-z]*[a-z])I'd like to grab the values for orderId and for message.Any help is appreciat
Here it goes. Trying to figure out why one table relationship works one way for a report link and another another table relationship doesn't. Tables we will look at: JOBS, SUB PAYROLL, ORDERS. Background info:1. Using COPY JOB button. This was created many many years ago. I have no memory of where I got it. I am attaching a document because when I try to paste here, I get kicked out.2. JOBS to SUB PAYROLL -3. SUB PAYROLL to JOBS -RESULT: NEW JOB NUMBERS (after copied from "template) "connect" automatically and shows this report on the JOBS form -NOW for ORDERS -JOBS to ORDERS -ORDERS to JOBS -RESULT: NEW JOB NUMBERS (after copied from "template) "DO NOT connect" automatically and shows this report on the JOBS form -------------------------------BuildPro------------------------------
I am trying to change the default home page for my application....so that I can delete this one. Please advise. thx------------------------------BuildPro------------------------------
Please fix this so that the text is smaller and centered on the button. I have tried so many different ways...nothing is working. thank youths// Begin button stylevar text bgcolor = $ButtonColor;var text txtcolor = $WordsColor;var text style = "style=\"text-decoration: none; text-align: center; background:" & $bgcolor & "; width: 20px; height: 20px; border-radius: 20px; padding:5px 5px 5px 5px; color: " & $txtcolor & "; display: inline-block; font: normal 10 6px/1 \"Calibri\", sans-serif; text-shadow: none;";// End button style------------------------------BuildPro------------------------------
I'm building a pipeline where I pull a csv file from AWS S3 ( got access to this channel ) and load into a Quick Base table as an intermediate step to pushing that table's content into a csv file in SharePoint. I begin by clearing the QB table, then query the AWS bucket for the object I want, then use import with CSV into Quick Base. The challenge is pushing that table's content into a csv or xlsx file to publish into SharePoint. Any guidance is appreciated.Chris------------------------------Chris------------------------------
I am currently importing information from two apps into a third app - this third app has a number of related fields from tables within this app. I am currently having to manually populate fields for the records that came in from the two other apps. Is it possible for the app owners to re-create these fields in their apps - so they are already populate in the daily automated imports/syncs? I am an admin in their apps but they are not in mind. Would I have to create the new fields in their apps for them?Thanks,Lashell------------------------------Lashell Thomas------------------------------
Does anyone know why this doesnt display correctly on mobile? It works on desktop. On mobile, it shows the score and audit date, then stops. If i comment out the audit date line, then it shows score and domicile, then stops. Shows nothing else. It will only show one line after score."<b>TO: field will include:<br></b>" & [UP Default To Email List Ver 1] &"<br><br><b>CC: field will include:<br></b>" & [CC Email List] &"<br><br><b>Score:</b> " & [Score Formula] &"<br><b>Audit Date:</b> " & [Audit Date] & //nothing displays after this. If I comment out this line, then the next line displays"<br><b>Domicile:</b> " & [Domicile - City and State] &"<br><b>Location:</b> " & [Location - Name] &"<br><b>Auditor:</b> " & [Employee - Preferred Name] &"<br><b>Vendor:</b> " & [Activ
This is what I am trying to do in a field called PRIME PT/UP DATE.COLORIf [PRIME PT/UP DATE] contains Monday, (red button with M)If [PRIME PT/UP DATE] contains Tuesday, (yellow button with T)...and so onI am using this formula in another field...but, I do not know how to include the "If Contains":var text ButtonColor = Case([Customer Initials],"SM","#808000", // olive green"KB20","#ffc966", // golden orange"NVR","#ede7d3", // cream"PUL","#003366", // navy blue"TRU","#ff884d", // peach orange"DWH","#004d99","GRH","#00cccc");var text WordsColor = Case([Customer Initials],"NVR","black","white");// Begin button stylevar text bgcolor = $ButtonColor;var text txtcolor = $WordsColor;var text style = "style=\"text-decoration: none; text-align: center; background:" & $bgcolor & "; width: 45px; border-radius: 50px; padding: 3px 5px; color: " & $txtcolor & "; display: inline-block; font: normal 500 16px/1 \"Calibri\", sans-serif; text-shadow: none;";// End button style var text URL
Hi everyone,I am trying to create a central simplified mobile home page that all users default to. I have noticed that the new dashboards do not support mobile. I created a new "Home Page" labeled Mobile Home Page.How do I default all users and roles to this new Home Page from the mobile app? This way I can create a better mobile experience....Thanks!------------------------------Ivan Weiss------------------------------
Mears Group is seeking a Systems Administrator will be responsible for the performance, integrity and security of the Mears Group PMO database. Mears Group provides utility construction services across the United States. Mears Group provides innovative solutions and dynamic approaches to aid our Operations team succeed throughout the country. Mears Group develops and implements scalable systems and tools, tailored to meet operational goals specifically through its cloud-based system/database. The system is seen as a full cycle PMO Work Order Management System. The Systems Administrator will be involved in the planning, development and implementation of applications, as well as in troubleshooting any issues on behalf of the company. The Systems Administrator will ensure that: Data remains consistent across the system Data is clearly defined Users access data concurrently, in a form that suits their needs Reports are produced to meet the needs of staff and clients Qual
Hi - I posted this 13 days ago, but onto an older thread that seemed relevant - but never received a reply, so I'm thinking it just got lost in the shuffle...I'm trying this code below to count the Number of unique communities that attend an event, but I'm struggling to get the query correct. So - as an example, say we hold an event, and have 50 attendees, representing 10 different communities - how can I get that unique count of 10? My code keeps returning a syntax error and I'm completely puzzled as to why. My Formula Query is: var text QUERY = "{7.OAF.'" & [Month] & "'} AND {7.OBF.'" & LastDayOfMonth([Month]) & "'}"; GetFieldValues(GetRecords($QUERY,"dbID") & ("14.EX." & [What community do you live in?] & "),12) & ToNumber(Trim(Left([Record IDs for this NPI],";"))) = [Record ID#] But, the field value [What community do you live in?] is generating a syntax error.Oddly, it goes away when I have a repeat line below like this:
Does anyone know if there is a listing of what charts are currently compatible with the new dashboard.So far, I don't think line and bar charts are compatible (the combo chart - I think individually, a line or a bar chart may work), pie seems to work. I'm still testing the others but wondering if anyone knows if this is listed somewhere. I tried googling but having no luck.------------------------------Mike Tamoush------------------------------
When users are looking at reports, I think it looks nice and clean to list months in the following way:December 2020January 2021February 2021I have a formula field which displays in this format, and in table reports I can display this field, but then sort by a date field so my order looks like above.However, Summary Reports you need to sort on your summary field. All I can think of is to make the name something like:2020 (12)December2021 (1)January2021 (2)FebruaryTo sort in the correct order. I don't think that looks very good. Anyone else run into this and come up with a nicer solution?------------------------------Mike Tamoush------------------------------
Hello,I currently have a text box to show the request number. I would like to make this automatic. How can I do this? Right now, each user has to look at the report which shows how many have been entered, and they have to fill in the next sequential number. Thanks for the help.Brandy------------------------------Brandy Nunes------------------------------
Please bear with me as I try to explain the scenario. I'm looking for a couple things out of this:1- Is the method I'm trying to implement the best way to do this, or is there a better one2- I'm trying to correct the behavior of my current method. I'm almost there.The goal is this:- our provisioning team would edit a record (with the information that needs to change). - They push a button (Send for Approval), and check the "Staging" button. This button has the following code: //Since [old.field] doesn't work here, we will remember the old values within the formulavar text OLDFIRSTNAME = [First Name];var text OLDLASTNAME = [Last Name];var number OLDRELATEDCOMPANYENROLLMENTFORM = [Related Company Enrollment Form];var textlist OLDPRODUCTERP = [Product ERP];var textlist OLDPRODUCTADDONAPP = [Product Add-On Apps];var textlist OLDPRODUCTACCESSORYAPP = [Product Accessory Apps];var text OLDPLATFORM = [Platform]; var text OLDEMAIL = [Email Address];var text OLDPHONE = [Office Phone];//Edit (and
Hello! I am generating a CSV file 6x day (i.e. every 4 hours) and uploading it to a SharePoint folder. Everything works great overalI; I am currently attaching the record_id to the beginning of each file (to solve for the latest file overwriting the last one), however I am being asked if we can begin each file with a date/time stamp instead if possible.I successfully used {{time.now|date_ymd}} to create a date but nothing is working for time; not {{time.now}} nor {{time.today}}. Error messages are embedded for context. Has anyone succeeded doing this? ------------------------------Nelson Arce------------------------------
Hi, I was wondering if there was a way to remove file attachments from a form using a button?------------------------------GMacri------------------------------
Has anyone heard any news on when the bugs might be fixed on bar charts to fix the color issue? I keep having issues where it will override my color choices and one choice always ends up black and it does not look very pleasant on a home page.------------------------------Ryan Locke------------------------------
Hello,I am trying to build an "assessment" application that takes different grades and calculates overall scores. The issue I am currently having is that lets say I have three numeric fields that are 1-10, and a score field that takes the aforementioned three fields and sums them and then averages. How would I go about creating a calculation where if one of the grades were not applicable, it would average the other two without needing the N/A field to complete the calculation?------------------------------Michael Martin------------------------------
I have two multi-select text lookup fields on a form. I want to create a third formula field that will provide a "yes" or "no" for whether [Multi-select field A] has any of the items that are in the other multi-select field (Multi-select field B]. How should I proceed? Thanks in advance for your help.I've tried the below formula, but it does not seem to work.If(Contains(ToText([Multi-select field A]), ToText([Multi-select field B])), "Yes", "No")------------------------------Luke Furuto------------------------------
Hello, I'm wanting to create a button with an embedded formula to generate child records while pulling field values from parent into child. I have most of it figured out except the pulling and pushing of values.URLRoot() & "db/" & [_DBID_TRACKING_PARTICIPANTS] & "?a=API_GenAddRecordForm&_fid_57=" & URLEncode ([Record ID#])& "&z=" & Rurl() Want to drag employee ID from parent into child and place in correct field in addition to the above.------------------------------Daniel R------------------------------
Can anyone tell me why this URL add button formula is not bringing over the Record ID to reference field in the new child record AND it's not bringing other desired info: (I have triple checked the fid's.)URLRoot() & "db/" & [_DBID_PROPERTIES] & "?a=API_GenAddRecordForm&_fid_755=" & URLEncode ([FMLS#])&"_fid_28="&URLEncode([Full Street Address])& "_fid_30="&URLEncode([City])& "_fid_31="&URLEncode([State])& "_fid_32="&URLEncode([Zip Code])& "_fid_71="&URLEncode()& "_fid_34="&URLEncode([County])& "_fid_35="&URLEncode([Lot])& "_fid_237="&URLEncode("Manual MLS Research")& "_fid_798="&URLEncode([Status])& "_fid_51="&URLEncode([Year Built])&"_fid_47="&URLEncode([Square Footage])&"_fid_105="&URLEncode([Unit Number])&"_fid_40="&URLEncode([Parcel Number])&"_fid_52="&URLEncode([Total Bedrooms])& "_fid_39="&URLEncode([Subdivision/Complex])&"_fid_36="&
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.