Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Looking at trying to restrict access to a QuickBase (whether whole database or specific table) between a specific time frame. Is this possible? We're using the API DoQuery via another application and running into issues which may be related to the traffic/work being done within the QB at the same time even though users have been asked to stop processing.I don't see anything at the QB level settings. Would I need to build some sort of time validation field within a table, or a Pipeline?------------------------------Robin Mcintosh------------------------------
Hello, is there a way to remove the app name, table name, and record number above the table as well as the information of who created/last edited the records?------------------------------frnmj------------------------------
Hi Everyone,Is there a way to change summary report column name/header? I don't see any option when I customize the report. I'm using the same field to show the number of records in 1st column and running total in the 2nd column. This report shows the field name which is apparently same for both columns. ------------------------------Mrunali Kadam------------------------------
I am trying to make a report that color codes the individual fields based on a given specification range. For example, the one I'm starting with I want to highlight the field in red when the number is greater than 1.50. I tried looking through the community tab to see where in the coding I went wrong but I wasn't having any luck. For some reason, the code is functioning properly in terms of the highlighting, but isn't pulling the number over correctly. Here is the code that I have set up in the Formula Rich Field (I've also attached an image):If([Lot Sensory Score:] > 1.5, "<div style=\"background-color:red;\">[Lot Sensory Score:]\n</div>", ToText([Lot Sensory Score:]))For some reason the second "[Lot Sensory Score]" isn't pulling correctly and isn't turning green in the code window.Eventually, I want to get more complicated with the color coding fields (i.e. if this field is A, color based on 80-100; if this field is B...), but I was trying to start simple.-------------
I have a question on backing up a form. I have a form that has 32 fields. I am about to make some changes, and will be removing several fields from the form & replacing them with a more meaningful description. So instead of saying Hardware Serial No. 12345, it will say something like:Microsoft CorporationModel Surface Pro 7+Computer Name AHL-SURF-1850Operating System Win 11 Pro x64But if I decide I don't like what I have done, I want to be able to go back to previous form and start over. Is there a way to backup and restore? Alternatively I will copy & paste into a Word document and print out and put in a file, so that if I need to go back I know for sure what the fields and form looked like.This seems like an inefficient way to do this, but from my experience in some Website builders I used for a former client, that is what I did because there was no backup when you made changes. Any ideas?------------------------------Bob T.---------------------------
I'm not sure how to start with my question. I have a large set of tasks to be used by a technician in the field. To show the completion of each task the technician of the equipment in the field. An example would be to photograph the serial number of a component. Once back in the office the photo is then processed (watermark added, etc.). The next step is to add the photo to the task by uploading to QuickBase.A large number of photographs need to be added at once. The process of adding a photograph to a record in QB is a bit tedious. One must edit the record, select the photo saved locally, save the edited record, then proceed to the next record. A way to do something like "Grid Edit" the photo link would greatly speed up the process. Would appreciate any insights into solving this problem. Several thousand photos are involved.------------------------------John Hancock------------------------------
I have created a pipeline using in built Quickbase search to get the Analysts and Project Managers. These two fields are multi-select user fields. I am using these fields in other steps. It is working fine, if these fields has user values but it is populating "[]" when field is blank. I have used {{CLEAR}} but it is not working.Thanks in advance!
Help needed:I need to create custom summary reports. I need to have the same information that a summary report is producing, but I need it in a table report format so I can use it with Juiced Docs. Juiced lets me control other things on the doc - but the subtable can only pull in table formatted reports.I have a Locations Table and a Locations Sales Table. I need to be able to preset a date range on the locations table and have it return sales from the locations sales table as summary.Ive been told - The answer lies in a "Stats table" - but I havent been able to get it setup properlyExample:Jonies Pit Stop - Frosted Flakes - 10/2/22 - 3.19Jonies Pit Stop - Frosted Flakes - 10/8/22 - 3.19Jonies Pit Stop - Frosted Flakes - 10/28/22 - 3.19Jonies Pit Stop - Lucky Charms - 10/5/22 - 3.09I need the results to be Jonies Pit Stop 10/1/22 thru 10/08/22Frosted Flakes - 2 - 6.38Lucky Charms - 1 - 3.09Totals  
So I'm using the following formula as a Copy Content button:var text CB= URLEncode([SFY PO Number] & " - " & [HO Last Name] & " - " & [HO Street Address] & " - " & [Client Company Name]);var text Alert= URLEncode("Current Job Info" & " was Copied to the Clipboard");"<a class='Vibrant Success' style=\"border:0px solid green; background-color:green; text-align: center;-box-shadow: 0px 10px 13px -7px #000000, 9px 7px 12px 6px #000000; \nbox-shadow: 0px 10px 13px -7px #000000, 9px 7px 12px 6px #000000;\"href=" & "javascript:{" &"navigator.clipboard.writeText('" & $CB & "').then(function(){" &"},function(){" &"});" & //"alert('" & $Alert & "');" & "$.jGrowl('" & $Alert & "');" &"};" & ">Copy to the Clipboard</a>" So here's the issue: Anytime that there is an apostrophe in one of the fields (For example, [HO Street Address]= 2300 Henry's Drive) then the button refuses to work. Are there any edit
Hi!I am trying to make a formula with DateTime fields that says if Date A plus 14 days is less than or equal to Date B then return "Overnight Shipping else return "Normal Shipping"I am using a text formula field and this is what I have so farIF(ToTEXT(WeekdayAdd(ToDate([Date A]),+14) <= [Date B], "Overnight Shipping","Normal Shipping"))It is giving me the error on the <= saying "The operator '<=' can't be applied on types date, datetime. Does anyone know how to get past this?------------------------------NOEL HODGES------------------------------
Hello,Can you please tell me what is the lowest level of access that someone needs to create a connected table from one database to another? ie - Admin, Participant, View?Thank you------------------------------Kathy Benjamin------------------------------
Hello,I am trying to change my User field to another name. Event though I have selected a new person for the field as a default, the name has does not change on the table field.thank you.------------------------------Reza Khosrowabadi------------------------------
For those who have a good amount of experience utilizing the Sandbox feature to make changes to applications, is there any general rule of thumb to how many changes should be made before publishing? Fore instance, I currently have roughly 1900 change lines in the current Sandbox I am working in that have not yet been published. Granted, the live app is not currently being used by the client anyway, but, I feel like that is a lot of changes to be sitting on. Has anyone had issues with changes not transferring correctly for one reason or another? We are currently at a lull between development work, I feel like it is the right time to publish what has been done so far and then start new work with a clean Sandbox so to speak. Any thoughts?------------------------------Chris Swirtz------------------------------
Hi,Is there a setting that will prevent the ability to drag and drop Kanban board cards from one column to another?Thanks,Matt------------------------------Mathew Crist------------------------------
Hi everyone,I have an expense app for employees to enter expenses and get reimbursement. It references another table with a field on it for "Has Company Credit Card". If that box is unchecked when a user starts a new expense I want the field "Reimbursable" to default to checked. However, I do want the user to be able to override it and uncheck it in case they should not reimburse.So how can I conditionally set the "starting point" for a checkbox but allow the user to override it?------------------------------Ivan Weiss------------------------------
Hi Everyone,I have a client that sends multiple invoices daily, then some weekly, and I'm trying to figure out how to make a pipeline do that? They were using Workato previously, but wanted all automations through pipelines. How it worked in Workato was it would get all the attachments needed for that day, put in an email, and then send them to clients. I've tried making a concat field of the attachments, and I still end up with an error.Any help would be appreciated!------------------------------Angel Newbern------------------------------
I am using a webhook to trigger a Pipeline, and I don't want it to start a new window. I just want it to send its payload and not get in the user's way. How do I "launch" a URL and not have it show up anywhere?------------------------------Edward Hefter www.Sutubra.com------------------------------
This can be disregarded - I found a solution.Thanks,------------------------------
Quickbase lets save a form with required fields in blank.Why happens that?------------------------------Maria Del Carmen Ortiz Garcia------------------------------
Hi Quickbase Team,Our programs team came to me with a request today that I don't know if it's possible to fulfill.Quick backstory to help explain the need: Our staff completes a form for each interaction with a 'client', one key metric I measure is the 'Community' the 'client' is based in. I have a list of 32 communities + "other." (we're a non-profit, and are funded based on #'s we provide per community)We have one team of staff who fulfill support requests when community-based-staff are not available. This team supports all communities, even those beyond the ones we are contracted to serve (separate and unique contract).They do NOT report "PER" interaction; but instead need to report aggregate #'s per Community.- where Communities are their own table- where Interactions are their own table and connected by a relationshipMy programs team wants to have a simple form that contains a list of the communities and a blank field for the team to rapidly input the number serv
I am creating a pipeline that creates a record in QuickBase after another record is created in another table.I can set it up fine, but I am mapping it so 3 fields from the first field feed 1 field in the other.I drag and drop and i know how to add text. but can I add line breaks or paragraph breaks between/after each field? Let's say it's {{Name}}{{Address}} but I want the text field to read:{{Name}}{{Address}}Jeff------------------------------Jeff Elliott------------------------------
Hi Everyone,I'm trying to create the below chart in QuickBase. I selected line & bar chart type so that count of "Approved" proposals per month can be shown on bar and area (Approved YTD field with light green in the below chart) can be shown in the form of line chart. As I don't see bar-area chart type option in QBI'm not sure how to calculate count of approved YTD (year to date value with light green in the above chart) values here? Furthermore, can I replace bar by stacked bar chart? There are 2 subcategories within "Approved" field so if possible would like to show that as well. I'm not sure if there is a way to combine different types of charts in 1 chart or we can select chart only from this list.Thank you in advance! ------------------------------Mrunali Kadam------------------------------
Hello all,Have a multiple condition form rule set up to change a certain field and make it read-only when certain options are selected from a drop-down menu further up the form. No form rule warning here, so not sure why the multiple condition rule is not triggering on the specified field. When "RV Site", or "Tent Camping" is selected from the uppermost drop-down menu, the "location field" is meant to change to "spring creek park" (as per the rules shown in the first image), and become read-only. Beating my head against the wall trying to figure out why this isn't working. Thank you. ------------------------------Coleman DuCharme------------------------------
I need to identify the number of unique inpatient admissions from claims data. Each inpatient stay can generate multiple claims each with a unique claim identifier. The claims would all share the same admit start date. the claim also has the member id of the member who had the inpatient stay.I want to count the number of inpatient visits visit for each member regardless of how many claims were submitted for the inpatient visit.I have attempted to do combine the claim ID with the admit date and want to do a distinct count of that....------------------------------Lashell Thomas------------------------------
I've been trying to run a Pipeline that is triggered based on formula field changes but the triggers don't seem to fire the Pipeline.For instance, I have a numeric formula field that changes daily based on a recommended frequency value - the days since last activity, e.g. [Recommended Frequency] - [Days Since Last Activity] = 1, tomorrow will equal 0 so the field changes but the Pipeline does not trigger. My advanced query is looking for this change. Field ID 181 is the formula field: {'181'.EX.'0'}.I also have a checkbox formula field that is super simple where it looks to see if the next preventative maintenance date is equal to today, e.g. [Next PM Date] = Today(), then true, else false.Now I've tried triggering based on either condition once they change, but the Pipeline doesn't seem to pick up on either change. Is it that Pipelines just don't trigger on formula field changes?------------------------------AR------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.