Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Welcome back to my journey to Pipelines Certification blog! In the last post, you learned about my game plan to get certified before the end of the year. Now to tackle one of my biggest fears – test anxiety! Most of my test anxiety can be managed by fully understanding what to expect. To get a better picture of what I’m up against, I reached out to Kiko, Manny, and Matthew on the Customer Success team at Quickbase and recorded a 9-minute interview on their exam experience. They recently became Pipelines Certified and were happy to offer guidance on my path journey towards Pipelines certification. If you have time, I highly recommend watching the video below. If you don’t have time, don’t worry, I got you! Here are six tips I learned from the interview that’s going help with passing the Pipelines exam: Know what topics will be covered in the exam. The best way to prep for the exam is to review the Pipelines exam material in the Quickbase University and spot
I have a relationship between two tables.The Set Up We Have:Table 1= Service Calls, these calls will have an End Of Job report that include the following:What they did on the job for the customer in one field.What water samples were taken for the customer in a separate field.What parts were used for the customer on site in a separate field (something they type in manually)Table 2= Inventory, this inventory is imported from our QuickBooks account and is refreshed multiple times a day. Problem we're having: We're currently manually typing in parts we're using for each job - everyone calls parts in our industry something different, which causes issues for our billing department because they often don't know what to bill based on what was typed in by our service technicians. What We WANT To Do About It:We currently have a relationship between our two tables, service calls & inventory - we want to be able to have our service technicians type the part they want to input (we've done
I would like to create a new form for my jobs table. It is my understanding that there is a "form builder". How do I use the builder without "assigning the form to the table until it is complete?------------------------------BuildPro------------------------------
At one point we used "Recurring record wizard" to make this button so that we could easily create a bunch of reoccurring tasks. It has stopped working, it seems that tool no longer exists.Has this been replaced by something else?Or is there a way I can recreate it?Thanks,------------------------------Md Safique Ahmed------------------------------
I would like to use Kanban reports to track varies quotes and their stages in my app. I have a Multi select text field where all the status' are listed and the field type cannot be changed. Is there a way to get the status' to display in a multiple choice field so I create the reports I need? Any ideas?Thanks!------------------------------Kelly Lyons------------------------------
Good morning all!I'll start by saying if there is somewhere better to put feature requests, I will happily submit this through a formal channel!I have been building out a new system on Quickbase and hit a few pain points that I thought I would mention in case it hasn't been brought up before! Select fields being limited to 100 items. This limit seems arbitrary, as I am able to use a pipeline to fetch data, write it to a table, and use that table data as the source for a select field. What the limit does do, however, is it make it so that I cannot make changes to the field without the "only 100 items allowed" error. This forces me to delete data from the table, make changes to the field, then rerun a pipeline. I'm not sure of the practical reason for limiting to 100, but I would hope to see this removed. To give a practical use-case, we have a field where we allow our users to select which facilities their report is in reference to, allowing selection from a list of facilities. We curr
I need you help as I lost my mind already on this testing :)I want to build Formula Queries which will provide me number of previous record if its date overlap with current data range. All possible scenarios below for test below. Also add Excel file which present my needs.Now I was preparing tests for 510 in Excel and come up with such formulasIn Excel I created formulas to support this check:After this I tried to make it to look like Formula Query connected with OR. Excel Formulas are marked with Orange numbers 1, 2 and 3 and corresponds with below formulas connected later on with OR:1) ({63.GTE.'" & [AltBOM Request - Starting Date] & "'}AND{63.LTE.'" & [AltBOM Request - End Date] & "'})2) ({64.GTE.'" & [AltBOM Request - Starting Date] & "'}AND{64.LTE.'" & [AltBOM Request - End Date] & "'})3) ({64.GTE.'" & [AltBOM Request - End Date] & "'}AND{63.LTE.'" & [AltBOM Request - End Date] & "'})But after placing it in it does not show anyt
I have a pipeline that I need to run every morning and based on several conditions update a set of data. One of the data points is the Effective Date.I don't have the option to drag the value from a field and I need the condition to look at all records from the previous day (the pipeline is scheduled to run at 1:00 AM each morning). The only options I see in the highlighted field is using the calendar and I don't have an option for "today".------------------------------Paul Peterson------------------------------
Is there a way to show subtotals on a Summary Report? I want to have a subtotaled line by the field BVA Strategy. Here's my report: ------------------------------Bethany Hudson------------------------------
I've "Assignee1" field on the form and after saving any record notification needs to be sent out to this user. I did build relationship and added email lookup field. Then I created 1 new formula field which is pointing to the "Assignee1-Email" field. However, I'm still not seeing this formula field in the notification-Notify whom drop down list.Please advise. ------------------------------Mrunali Kadam------------------------------
Is there a formula that will convert the Unix epoch time like '1555079067' to April 12, 2019 2:24:27 PM (GMT)
I have an app that has an intermittent problem where:1) viewing report in table X: all records are displaying2) go to another report in a different table3) go back to report for table X: no records display and get message "No records found"4) using browser refresh does not clear it. Sometimes going into a different app and then back to this app will clear the problem, sometimes have to log out of QB and back in to clear the problem. Seems to happen in random tables (there's about 20 total in the app). Have not been able to determine what triggers it to happen. Does not happen often, maybe once per week.It's not that the records have actually been deleted, they are just not displaying for some reason. Is this a known bug or a problem with my app?I'm new to Quickbase and building apps. Thank you for your help!------------------------------Diane Sinawi------------------------------
Hello,I am currently trying to create a ranking column on one of my reports and found some documentation in past forums regarding a method for this in the Pastie Database (I will include these below for reference). While I was going through the steps to implement this I found a note on creating a creating a User Defined Page named "module.js." You would place custom code in the section under the alert statement in the User Defined Page. My problem, is that I don't seem to know what a User Defined Page is or how to make one. Would anyone be able to provide assistance?Thank you!The Image Onload Technique Used With QuickBase================================ - Pastebin.com Pastebin remove preview The Image Onload Technique Used With QuickBase================================ - Pastebin.com Not a member of Pastebin yet? Sign Up , it unlocks many cool features! The Image Onload Technique Used With QuickBase The image onload technique is a workaround that allows you to loa
I have a few questions regarding exact forms. First, I have admin access, but not app creation access. Can I copy an existing exact form and modify it to meet the needs I have for the new exact form? Next, I see that the current exact form is using JavaScript. I know we can't us JS in the apps, but is it still available in exact forms? Finally, are there any limitations regarding the use of Style tags in exact forms?Thank you in advance.------------------------------Paul Peterson------------------------------
I would like to create an automation in a table that will allow me to modify a record in a parent table if needed.Here is my scenrior:I create or edit a record in Table B, before closing the record i would like a pop up to ask if ( or anything else that can ask me to change the record in the parent table) I would like to modify a specific field in the parent table ( the field is "reminder date" in table A)Basically I create or modify a record in my "estimate" table, I would also like to be able to change my "reminder date" for the parent record (patient table)....I will eventually use pipelines to do this, but I need to set up this up quickly.Any thoughts?------------------------------Kelly Lyons------------------------------
Hello,I am grouping cards on a kanban report based on a field called Status. The field holds statuses of out records in QB. I add the statuses to the selection in the order in which I want them to display on the report (as shown in screenshot below: Solutioning, Backlog, Accepted) and when I save it rearranges them to show in ABC order (Accepted, Backlog, Solutioning). Is there a way to stop this from happening or an easy work around to force the order?------------------------------Thanks in advance,Jennifer Paschal------------------------------
Hi,I am creating an app for tracking tasks employees due dates & percentages.I am right now stuck in a situation where my data is clearly added in the system, However the reporting is sort of a havoc. There is simple duplication in the reporting manner which I wish to remove. All I want to carry out is, Let the system count only the unique values in the "Combined Week & Color" field and post them correctly in "TotalCost" ie. Add the 2 similar values of "Combined Week & Color" 2 Gunsham Lakhiani-14-RED + 2 Gunsham Lakhiani-14-RED And display the result in "TotalCost" Field as 1.I will further be calling the values in this field into another table to make a percent calculation for each employee.Please assist or let me know if there is any better way to solve this problem.------------------------------Amedha Surve------------------------------
Hi folks:I'm having an issue with the JSON Response Channel and I am told it's out of scope for support. I'm posting a JSON payload to a pipeline that has a JSON Response trigger. When I run the pipeline, there's some header info that comes across, but the body does not post. If I create a separate pipeline that uses a webhook, and change my endpoint in Postman to the webhook, it posts just fine. I need to use basic auth, so the webhook isn't an option.Any one have a similar issue with JSON Response?Thanks,Quincy------------------------------Quincy Adam------------------------------
Hello:I have Pipeline that is receiving a webhook trigger and I realized you cannot map a field to a lookup field. I must store the value in a text field. How could I update a lookup field to match the value from a text field?To elaborate, I have 2 tables: Customer + InsuranceIn my Customers table, I collect all the info including their Insurance Info. I have another table Insurance, that is a very long list of insurance companies along with an insurance code. I need to return the code to the customer based on their insurance selected. No customer would know their code, so it's not an option to pass that along the webhook.I tried setting up a Pipeline to search for the matching insurance name, but it fails with updating the record. I get the following error: invalid literal for int() with base 10: 'payor_id'There's probably a better way of doing this. Appreciate the help!------------------------------Quincy Adam------------------------------
Hi,Is there a way to add charts into exact forms without using exact forms plus? I can't find any support for charts in exact forms through vanilla QuickBase. Does anyone know if exact forms plus is the only way?Thanks!------------------------------Hank Halverson------------------------------
I'm using a rich text - formula field to compare currency amounts in two form fields within the same form. So far this is what I have:IF([Amount 1]=[Amount 2],"<font color=green><b>Values Match</font></b>","<font color=red><b>Values Do Not Match</font></b>")Currently even if the values match I'm getting the "Values Do Not Match" response. What am I missing or what have I done wrong?------------------------------Daniel ReamBuilder------------------------------
Anyone know how to widen the columns in a Kanban? I want the columns to leverage the entire screen. Any help is appreciated.------------------------------KELLY WALKER-MOSELEY------------------------------
Hello, I have set up an approval process within our CRM and part of the process is putting an "approved by" name on the request automatically when a user hits the "approved" button. The way I have this set up is an automation that puts the "last modified by" name in the approved by field. The issue I'm running into is it changes ALL records to that person instead of the individual record they are approving. I have put a date filter on this but the issue will still occur if there are multiple records with the same date. Is there a different way to accomplish this?------------------------------Jessica Stevens------------------------------
Honestly, I haven't dug deeply into this question yet. Is it possible to use a pipeline to create a new project only if that project number does not exist?------------------------------Paul Peterson------------------------------
I built relationship between tables and added "Add vote" button on the form. But this Add vote text also has been added default with this button. I'm not sure how do I remove it.Please advise. ------------------------------Mrunali Kadam------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.