Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello,I'm building an app for another department, which will have some information be sent externally. The subscription emails have on the very bottom. "This is an automated email from a Quickbase application. If you feel that you received this email in error, please contact the application's manager, xxx@xxx.com."Right now, my email address is listed there since I built the application. Is there a way to remove my email address from that? Since I won't be the user of the app, I don't want these external people having my contact. Is there a way to have the subscription email without any contact there? If we can't issue a license to a general email distribution address, then I have a feeling any individual would feel the same as I would.Thank you.------------------------------V W------------------------------
I am sooooo happy.After what feels like two years of silently creeping up on a formula error in a formula field, because the error help text pop-up would cover the text that needed to be fixed. Someone at Quickbase has finally moved the pop-up to below the error!!! Thank you kind Quickbase Developer!! ------------------------------Jim Harrisontransparency = knowledge + understanding : The Scrum Dudes------------------------------
Each week, I import (clipboard) a specific type of data to the same table in my app. Today I attempted to import as I always do, and was presented with this error:"The following required fields are missing from your import data: `Deliverable Cycle Month`"(it does this for different req'd fields if I add the one it mentions to the clipboard import).The app hasn't changed and the import data format hasn't changed. Has something in Quickbase changed that would cause this error?------------------------------Matt Makris------------------------------
Once you log in (connect) to an account in a pipelines channel (Say outlook or Quickbooks or any of them), if you decide you want to change that login to a different one, how do you do that? I don't see any options to log out or reconnect or anything?------------------------------Mike Tamoush------------------------------
We have a grid edit report where there are more than 100 entries, but only 100 entries show. Is there a way for a grid edit report to show all entries and not just the first 100?------------------------------Amy Gosz------------------------------
Does a pipeline still update records when it errors out for unique fields. I am having hard time to figure. I am using Json to paste the records from report in parent table to create new records in the target child table. But it was creating duplicate records every time I ran. So I decided to make an ID field in target table as unique and mapped it to record id field of parent table. I ran it the first time it was smooth but second it gives me error 51. I just want the pipeline to update exisiting records in the report and creates new ones if they show up in the report. Any ideas regarding it?------------------------------Ramesh Singh------------------------------
I am using postman to test API connections to Quickbase Post, create new record. I can post and create a new record with fields populated correctly using basic or no authentication. As soon as I try to use a JWT Token, I get an "error": "Unauthorized" in postman and no action on the Quickbase side, not even an error that an attempt was made. Does anyone have a good test setup that I can work with that was successful using postman or another API testing platform? Using RS256 Public and Privet Key. ------------------------------Brian Crowther------------------------------
I proudly built a complex Pipeline with about a dozen steps including a few "for each" loops. But then I found out that the Pipeline needs to be run every few hours at specific times of the day. While I see that there is an easy way to copy a Pipeline, I do not want to maintain 6 copies of the Pipeline if I need to make change later. So what I want is to be able to Call this complex Pipeline with a simple Pipeline who's job it is to wake up on a schedule and call my complex Pipeline. There is an incredibly helpful short video posed by Josh Weeman here of how to call a Pipeline from a pipeline. But my problem is that it will not let me drag the Pipeline Called Channel to my existing pipeline. I can easily set the first Step of a new Pipeline to be the called Pipeline Channel, but for an existing one that Channel is greyed out.How can i convert my pipeline to be able to be callable?------------------------------Mark Shnier (YQC)Quick Base Solution
Received this error which I expected when running this pipeline.Remote service reported an error: 51 : Trying to add a non-unique value to a field marked unique : Your import data has duplicate values for the following unique fields Field name: Invoice Number Duplicate values: 60401 57304 58901 59070 55231 55391 57280 60925 61027 57510 58583 60812 59400 55234 60086 60168 54736 58932 58940 58427 60088 -- Processed: 0 - Added: 0 - Updated: 0 - Unchanged: 0I am wanting anything with duplicate values to not create a new record. These items it flagged. But does this mean that the other records that were not duplicates still were updated properly? Or did the error cancel any other updates?------------------------------Davis Ward------------------------------
Hello, I'm looking for a solution that would prevent Users from using "-" or, spaces and making sure they enter 9 digits consecutively in the SSN field. 000-00-0000 = Incorrect0000000000 = Incorrect00000000 = Incorrect000000000 = Correct (9 digits in length, no spaces or dashes)Update: I added formula checkbox as a flag and used the flag inside of a custom data rule to accomplish this. Worked great! ------------------------------Todd Molino------------------------------
I have a quickbase pipeline which starts fetch json, prepare bulk upsert,iterate over json records, for each it needs to add a bulk upsert row and last step E is commit upsert. But seems like it doesn't add a bulk upsert output.My json schema is { "type": "object", "properties": { "Company Name": { "type": "string" }, "Company Id - Collection Status": { "type": "string" }, "Days Past Due": { "type": "integer" }, "BANK_ID": { "type": "string" }, "Company Id (ref)": { "type": "string" }, "Balance Past Due": { "type": "number" }, "Credit Line Amount": { "type": "number" }, "Last payment date": { "type": "string" },&
Is anyone else experiencing application performance issues? Slow-loading pages?------------------------------Brad Elmore------------------------------
Currently I have a Serial Number field which is ticked for "Must be unique". This works 98% of the time in ensuring no duplicate user errors when entering the serial number. I have the situation where that same device may be returned and re-used again elsewhere requiring the need to capture the same serial number against a different job/site. With the "Must be unique" flag this will stop you from saving. Is there a workaround where it can still check for duplicates and if found provide a warning and way to allow the duplication? Thanks.------------------------------Grant K------------------------------
Hello,I'm looking for some help using if( not is null)...I have a field called "Seat #" and another called "Verification Cleared?.""Verification Cleared?" is multiple-choice that can have the response of "N/A," "Approved," "Denied," or "Pending."I'm trying to create a formula that says if "Seat #" is not null and "Verification Cleared?" = "Pending" to be called "Incomplete". Or if "Seat #" is not null and "Verification Cleared?" = any of the other options in the M/C to be called "Complete."This is what I currently have:ToText(If(not IsNull([Seat #]), "",[Verification Cleared?] = "Pending","Incomplete","Complete"))I added the "ToText" because it was giving me the yellow highlight for "Seat #" that it was expecting a date or number. When I have it as the formula I have now, it just comes out blank. The formula will work if I just have it If(IsNull), but it will still have that yellow highlight for Seat #. What should I change to make this work? Th
Hey everyone,I've been trying around with this myself, but with no success. Does anyone know how to write a 'Formula - Checkbox' field that is only true if today = the first Tuesday of the month? ------------------------------Quickbase Admin------------------------------
Hello,I am looking for some assistance in adding some functionality to a live Pipeline (Attached picture) I am currently pulling the PO # from a pipeline tag. Here is the code {{a.subject[-6:(a.subject|length)]}} The email is a template that purchasing sends with our internal PO number as the last 6 digits of the email. I would like to be able to pull the Vendor name from the email as well but my caveat to that is that the vendor names are varying lengths. Does anyone have any suggestions on how to accomplish this? ------------------------------Carl Snodgrass------------------------------
When I have a Rich Text field as a lookup field, in a child table record, the HTML hieroglyphics appear. e.g. <p>. etc.Is there a way to either have the field show up as it does in the Parent record or strip the child record lookup field of it's HTML characters.------------------------------George Bramhall------------------------------
Hi,I have a Couple of Tables, say Table A , Table B and Table C.Table C is a Helper table with records of sequential numbers I am using as a loop counter.e.g. QTY is 5 so 5 related Part Records with a Blank serial number field are created in Table B. Table A Has a Numeric Quantity field (QTY) and a Part Number fieldI already have a Pipeline work so when you save a record in Table A it creates in Table B QTY x Records with a Part Number field and say say a Serial Number Blank serial number fieldAdding records or modifying upwards is working.What I'm struggling with is a Delete if the Table A QTY number is changed downwards.If I go back and edit that record and change QTY to 3, I want to delete two of the related records in Table B (preferably the latest created).I have a field "Difference" in Table A that records the change in QTY so I know how many times to Add/Delete on a QTY modificationI currently have a A. Search Records on Table CFor Each Do B. Sear
Is there a way to filter API_UserRoles based on Role ID?------------------------------Charlene Dougall------------------------------
Looking for ideas/help on making the following happen and have tried a few things that didn't work including actions. It seems that pipelines might be flexible enough to do this, although I just don't know enough to figure out how to setup pipelines. I'll also reference a recent discussion topic which is about the same topic I'm posting on, i.e., how to use the January 2023 Quickbase Gantt plugin with a pre-existing project management/tracking app, see: January 2023 Quickbase Gantt Plugin - automatic table setup | Quick Base Announcements Their question was about how to create the tables IN their original project app -- I don't want to do that because of the resultant complexity.Here's what I'd like to do. Given that the GANTT Template App using the Gantt plugin works great when you don't mess with tables, etc., I was trying to figure out a way to link an existing project tracking app table, i.e., an app with a table called "Projects" with a field nam
I have two tables. I added a new record to the 'New Request' table (A) using the Quickbase auto-generate API button, and then attempted to add the same record to the 'In Progress' table (B) by clicking on the API button. However, I received an error message stating that the 'rid' parameter was missing. 'In Progress' table (B) formula= "If(IsNull([Start Date]), URLRoot() & "db/" & [_DBID_INPROGRESS] & "?act=API_EditRecord&apptoken=dpvtvtrbuvtrjjd5ydp38bccn9np&rid=" & [Record ID#] & "&_fid_45=" & URLEncode("Task Started") & "&_fid_6=" & Now() & "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_INPROGRESS] & "?act=dr&rid=" & [Record ID#]) )" Note: I am receiving an error when attempting to use a formula without saving the record in the 'In Progress' table (B). However, once I save the record in the 'In Progress' table (B), the same formula works fine------------------------------manohar vankireddy---------
I want to automatically copy a record from the "CSR Pipeline" table to the "Completed CSR" table when the status field of the record in the "CSR Pipeline" table is set to "Completed". This should happen without requiring any manual intervention or button clicks.------------------------------manohar vankireddy------------------------------
I'm trying to look to set separate date and time fields on a Create Record QB Action in pipelines to be 12 hours from the time the pipeline runs. Setting the date field with {{time.now + time.delta(hours=12)}} gives me a full date and time response, which Quickbase will populate the field. However the same value in the time field gives an error. To give just the value of time it seems that it should be this {{time.now + time.delta(hours=12)|datetimeformat('%H:%M:%S %Z')}}, but QB will not let me save that.Unfortunately I cannot alter the field types to make a single date time field. Any ideas on how I can do this without just adding fields to my table?------------------------------Sean Boat-MooreManager SMB DevelopmentProject Management Office and Quality Control NCR Corporation sean.boat-moore@ncr.com | ncr.com------------------------------
Hello!I am attempting to track when our leads are converted, which happens when our [Account Status] field switches from "Lead" to "Signed Customer." When I created a date/time field using the formula below, it is literally continuously updating to show the current time. My goal is to just capture the date/time of when the [Account Status] field switched from "Lead" to "Signed Customer." Help?If([Account Status]="Signed Customer",Now(),null)Thank you!!------------------------------Rikki Ryan------------------------------
Hello, I have a table for ASP. Each of these ASP go into a child table and are going to different types of cases in the child. I added a multiple choice field which i update. I created a pipeline where if we have two similar ASP numbers it copies the value from the record i updated and matches with the same ASP in that table to update the multiple choice field. I started the pipeline with record updated, then search records and update record. It picks the record updated but in search records it doesn't get any records. I used a advanced query as well {'8'.EX.'$[ASP Number]'} but returns no value. Kindly help------------------------------XYZXYZ------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.