Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hi, I am currently trying to build a pipeline that automatically updates a file attachment field in one of my records. However, it des not seem to let me choose the file attachment field in the "add fields" portion of the "update record" block in the pipeline builder. Is this not available in QuickBase?Thank you------------------------------Tom Leick------------------------------
I'm in the process of reorganizing data to make better use of Quickbase and trying to copy file attachments from one record to another using pipelines. This morning I set one up and used it successfully to copy 100+ files. In my infinite wisdom, I deleted the pipeline before creating a new one for another set of data and now I can't for the life of me figure out how.Here's my pipeline setup: Search for records in "Projects" where [Invoice #] is set. [Invoice] is also selected as a field for use later in the pipeline. For each, search for records in "PO" where [Invoice #] matches [Invoice #] from step A. [Invoice] is selected for use later in the pipeline. This is where I'm stuck. I thought my working setup was configured like this, with the next step being Update Record. But when I do that, [Invoice] does not show up as a field to update. Can anyone suggest where I might be going wrong here? I wish I saved the working pipeline...
Hello, I created an action link notification, the email goes out when a user clicks on the "Approve" button in the email, they get directed to a page that states: The XML file does not appear to have any style information associated with it. (Adding screen shot in attachment). My Approve button is setup with the following formula: URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=cx2edttcfbymmycpifybmdri7nce&_fid_17=Approved&rid=" & [Record ID#] & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?act=dr&rid=" & [Record ID#])If I am logged into QB already the button works, but if I am not logged in I get this error. Instead of getting the error shouldn't it direct me to a login page so that the action will complete?------------------------------Neal Mathews------------------------------
Although you posted the JavaScript code, that is simply calling a code page------------------------------BuildPro------------------------------
This might be a long shot. Is there a way to show the actual child records in a report instead of a report link? I have a detailed report I need to create but need to have all the related "Grant contracts" listed within an embedded report so the entire thing can be printed in one report. ------------------------------Bethany Hudson------------------------------
I know we can create connected tables to csv files stored in SFTP server. Is there a way to send or export QuickBase data in a table as csv file to an SFTP folder location?------------------------------Karthik Sekhar------------------------------
How can I accomplish this in a Pipeline?A- Search a table. Include a text field that is a list of items (semicolon deliminator). This search yields a handful of results. For each A:B. Search a different table with this condition: is contained within .Obviously that isn't a filter that exists. What ways can this concept be accomplished?------------------------------Mike Tamoush------------------------------
Trying to filter a report where one User formula, User(), must match another user formula, If([Are you entering for another Team Member?]="Yes",[Team Member],[Are you entering for another Team Member?]="No",[Record Owner])Currently this filter is not filtering as expected.------------------------------George Bramhall------------------------------
I had added this rich text formula field at the bottom of my form to left align: "<img src onerror='$(\"table.LabelsLeft td.label,table.LabelsLeft label\").css(\"text-align\",\"left\");'>"As an alternative just put this Now Java Script is no longer allowed in rich text. How can I left justify my form------------------------------Sarah Burres------------------------------
Hi everyone,I have an app called Team Elite which is our central hub for our company. It is essentially an ERP system that does everything from task management to project management, invoicing, purchasing, etc.We have come up with the need to add a HR app into our portfolio.... I want to create the HR "module" as a separate app (I believe) for security reasons. There is information that will be highly confidential and although we can control access in Team Elite I think it would be beneficial to have the safety so there is no oops of being a separate app.We have a table in our Team Elite app called "Team Members." This table has all of our employee in it, their address, phone number, etc. So things you would typically see in a HR app. I went and made a sync table so that this table would appear in my HR app, works great.However, there is one issue I am running across now and I am looking for advice on how to strategically best do this.... The t
Support Ticket App - I need a ticket age field to show the duration of the ticket until it is closed.
Hello, I have a field called Topic where the user provides the topic of a case study they would like to create with a customer.That text is inserted directly into this sentence: XYZ Company, Inc., and its affiliates ("XYZ") would like to create a story about Topic describing ACME's ("Participant") experiences with XYZ's technologies and services (the "Story"). Right now, the text above isn't anywhere on the form, so when the user fills in the topic, 99% of the time it doesn't make sense in the context of the sentence it is being inserted to. For example, someone might type "ACME started using our laptops and they are happy with them" which translates to: XYZ Company, Inc., and its affiliates ("XYZ") would like to create a story about ACME started using our laptops and they are happy with them describing ACME's ("Participant") experiences with XYZ's technologies and services (the "Story"). To help with this, I've created a field that provides a preview of what the sentence wi
Haven't really touched pipelines yet for our other apps and projects since all developers cannot see them. Still do not understand this design choice...Any word from QB on fixing this to work like Automation so our development teams can work together?------------------------------John Ross------------------------------
We have created a form that needs number fields to be right aligned to make it easily readable, however the fields are all left aligning - can we get them to right align?
As the title says. For companies like us who deal with ICCID's, Serials, MAC's, etc., the 12 digit limit just does not work. Though I am curious to find out if this will effect something like an ICCID if we have it in a text field vs. a numerical field?------------------------------John Ross------------------------------
In a field on my report I would like to show a finite number of entries (more than one) from an append field.I have created a formula text field that uses a formula from QuickBase help Part([appendfieldname],2,"[") to grab content from my prepending append field.This half works, because it gets me only the last (one) entry.Is there a way to edit this formula and get the TWO or THREE latest entries instead? Or do I need use an entirely different approach?------------------------------GV------------------------------
Hi,Is it possible to have a successive distinct count summary field such as No. Consecutive Wins (or losses) for a Salesperson?ThanksTim------------------------------Tim Egerton------------------------------
I'm trying to set up an automated way to avoid manually QCing records. I have parent Table A (matters) with child records in Table B (timecards). Lots of related timecards get created in the Timecard all the time, but once/month, we generate a specific type of timecard record (as in certain fields have specific values in them) for each matter, and I want to compare them to the previous month's version of that specific timecard. How would I go about doing that? Essentially I want to write a formula field that looks at the previous month's child record, determines if Field 1's value has increased or decreased by X%, and alert me if the value has changed by a certain threshold, either by setting the formula field's value to some phrase, or possibly triggering a subscription being sent to me with all of the parent matters that had children with values surpass a given threshold compared to the previous month.------------------------------Harrison Smith------------------------------
Can anyone see anything wrong with this formula? Im trying to run a table import with a button push, and not having any luck. URLRoot() & "db/" & [_DBID_SUBCONTRACTORS_ON_ECAC] & "?act=API_RunImport&ID=10"& "&apptoken=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"Not sure if I need the app token, I tried it with and without. Do I have a typo?UPDATE: Nevermind, user error. Always see it as soon as I post. (For those wondering, further down in my formula that I didn't post I was testing something and that caused the failure)------------------------------Mike Tamoush------------------------------
I am trying to calculate an employee's owed vacation days. I want to make sure I capture all of the days they might be owed, so I want to include the total used this fiscal year plus the total consumed the previous fiscal year (in case there is any carry over).Fiscal years go 1 Jan to 31 Dec, so I want to calculate a sum from TODAY to 1 Jan of the previous year.------------------------------Sid Fontoura------------------------------
The table I'm building allows the user to create a product offer for an order. So in this table they create a product offer, write the details of the product and then save it and now the table shows all the details for "product A" that the user created for this product offer. I currently have it set so that the product offer# = the record ID#. However, sometimes the product offers contain more than one product but the user can only enter one product at a time. So when the user enters product A, B, C, the table will show record ID# 1, 2, 3, and if left at that, the "product offer#" field will match that. But I need to be able to show that the product offer# is the same for all those products. So my solution was to create a check box field called "order related to last product" that the user can select while they are creating that product offer. Then I'd create a formula for the product offer# saying:"if 'order related to last product' is not checked off, then product offer# = record I
I'm sure I'm missing something simple, but have not found a solution yet. I have a checkbox to indicate the active/archived projects. I am trying to track the active projects over time. What is the best way to track the number of active projects each day?------------------------------Paul Peterson------------------------------
I have an Accounts Payable app that maps Invoices to Purchase Orders. A purchase order may be referenced by several invoices so I have a relationship between Purchase Orders as parent and Invoices as child. On the Invoices form, I want to display a report showing any other invoices that reference this invoice's purchase order. To achieve this, I created a report link that relates invoices by the purchase order. So far so good. Now I'd like to filter the current invoice -- where the report is displayed -- from the report.For example: Invoices 123, 456, and 789 all reference PO ABC. On the form displaying Invoice 123, I'd like the report link to display only invoices 456 and 789.Thanks in advance for your assistance with this.------------------------------Rick Putnam------------------------------
Hello,I am having trouble figuring out why my formula doesn't work. I have tried several versions and none have worked so I need help.I have a field that is a % that could be negative or positive. I need to create a formula that says if that % is -3% or higher that is exceeding, if it is below -4 that is bad. So, -1% good, -18% bad, 25 % good, etc.This is where I ended up but still not working, it makes everything good or bad, there is no separation. I even tried separation, -1, -2, -3 out in the formula but still no luck.If([%]>=-3, "Exceeded",If([%]<=-4, "BAD"))or If([%]>=-3, "Exceeded", "Bad")Any help is greatly appreciated. ------------------------------Jennifer Silberstein------------------------------
Can someone tell me what's wrong with my URL Formula button code: (fid 21 is a date field)Here is my URL Code URLRoot() & "db/" & [_DBID_RECEIPTS] & "?act=API_EditRecord" &"&rid=" & [Maximum Unsent Receipt Record ID#]& "&apptoken=cz33dcb8h2qfbp4evmdpbw2hd &_fid_21=" & Today()&"&rdr=" & "&z=" & Rurl())And here is my error: This XML file does not appear to have any style information associated with it. The document tree is shown below. <qdbapi> <action>API_EditRecord</action> <errcode>0</errcode> <errtext>No error</errtext> <rid>44</rid> <num_fields_changed>0</num_fields_changed> <update_id>1643228728393</update_id> </qdbapi> ------------------------------George Bramhall------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.