Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
The responsibilities and permissions of the admin roles in Quickbase Within the Quickbase platform there are several admin roles that you may come across. Each has their own set of permissions and entitlements. Knowing which role (or roles) you are in, and what the capabilities of each role are can make a big difference in how you use the platform. We’d like to start with explaining the three most common admin roles that we have: Application Managers, Account Admins, and Realm Admins. Intro Bobby – Application Manager with Full Administrator Permissions River – Account Admin with Full Management Permissions Joyce – Realm Admin/Account Admin with Full Management Permissions Intro The first step to understanding each of the roles is knowing that the roles are additive. You can be one of the three, or all three, or any combination in between. For most accounts, it is common for your Realm Admins to also be Account Admins, and quite often Account Admins are Application Managers as well, an
I am trying to use a formula url button to mark a task complete, but in doing do, i also want to update the parent record of the task based on a user input from a codepage. Both functions work independently, but I cannot get them to work together. I think the issue is either somewhere in my nested url's, or it isnt possible to do this with a codepage for user input.Is what I am trying to do possible?Here is what I have:var text URLONE = URLRoot() & "db/" & [_DBID_SO_TASKS]& "?act=API_EditRecord&rid=" & [Record ID#]& "&_fid_12=" & URLEncode("Complete")& "&apptoken=dg3xmifbwc8n9adx8a9hfkdqq7u&rid=";var text URLTWO = URLRoot() & "db/" & [_DBID_OPPORTUNITY] & "?a=API_EditRecord&apptoken=dg3xmifbwc8n9adx8a9hfkdqq7u"& "&rid=" & [Related Opportunity]& "&_fid_14="; var text urlprompt = URLRoot() & "db/" & AppID() & "?a=dbpage&pageid=8"& "&url=" & URLEncode($urltwo);var text U
Hi,I have a table called Projects with a file attachment field called Design. When a file is added to that field, I would like to create a new record in my Tracker table. Where should I start?------------------------------Mike Sanders------------------------------
Hello,May I ask for a simple way to include a file in every line of my table.I want to import data with a file attached to every line.Thank you,------------------------------Hamza GHALLABI------------------------------
Hi,I have a field [Control Number] that has multiple controls listed and separated by a comma. I'm looking for a formula that will capture the control number without the comma.Ex[Control Number] = [187461, 187462, 187463, 187464, 187465, 187466]I need to break out by the following into 6 different fields:[Control 1] = 187461[Control 2] = 187462[Control 3] = 187463[Control 4] = 187464[Control 5] = 187465[Control 6] = 187466Any ideas? Thank you in advance!------------------------------Kathy Benjamin------------------------------
I'm trying to add one more field into this rich text formula. It's a checkbox field that I'd like to be checked as true. When I try to add it and set the value as '1' I get syntax errors. How can I add a checkbox field to be set as true?If([Check],"<a " & $addstyle & " \" href='" & [_DBID_TASKS] & "?act=API_GenAddRecordForm&_fid_34=" & URLEncode ([PropertyAddress: Street 1])&"_fid_35=" & URLEncode([PropertyAddress: Street 2])&"_fid_36=" & URLEncode([PropertyAddress: City])&"_fid_37=" & URLEncode([PropertyAddress: State/Region])&"_fid_38=" & URLEncode([PropertyAddress: Postal Code])&"_fid_32=" & URLEncode([PropertyAddress: Postal Code])&"&z=" & Rurl()& "'>Add Task</a>", "")"<a " & $addstyle & " \" href='" & [_DBID_KNOCKS] & "?act=API_GenAddRecordForm&_fid_9=" & URLEncode ([Related Property Assignment])& "&z=" & Rurl()& "'>Add Outreach</a>")-----
I am working on an App that will be used by people in the US as well as in South Africa. The date format for the two countries is different and I'd like each group of people to be able to use their own format. I know how to change the formatting for the entire realm and for each individual app, but is there a way to set the localization to where the person is? I'd like the US people to have commas for thousands and the date in the MM-DD-YYYY format, and the people in South Africa to have periods for thousands and the date in the right format 😁.Any suggestions?------------------------------Edward Hefter www.Sutubra.com------------------------------
I'm setting up an application for a team with several restrictions. Looking for a method or examples to achieve the following Import records/rows from a csv file into an existing table WITHOUT using pipelines or 3rd party tools. The csv file sits on a network share internal to the company Would it be possible to create a button that automates the steps used when performing a manual import? Working API examples would be helpful. The QB help site examples are not very intuitive.Thank You------------------------------Michael Mahon------------------------------
I basically have 2 apps that are libraries for standard operating procedures (SOP) and control documents (CD). Each SOP can have multiple related CDs; each CD can be related to many SOPs. I have created an app-to-app relationship where SOPs can have many CDs and you select the related SOP via lookup in each CD form. On the SOP table I have a summary number of related CDs.Now, I'm having trouble getting the second part of this- each CD can be related to many SOPs.the lookup only allows to pick 1 value. Is there a way to multi-select text lookup? ------------------------------Yasmin Boyrati------------------------------
Hello -We have several apps on our account. One app uses a pipeline to send data to another. Some drop downs have "&", commas, "#" in the options and the pipeline fails anytime one of those options is selected. Is there an easy workaround for this? I was thinking the other app owner could create a formula field on their side and use the URLEncode(ToText()) where needed and then use those fields to pass the data to my app...would that work? Is there an easier solution?Is there anything in the works to fix this issue?------------------------------Thanks in advance,Jennifer Paschal------------------------------
Hello,I am scheduling "visits" for our technicians and showing them on a calendar report. As many of our techs have appointments on the same day, I would like for technician A to only see the "visits" scheduled for technician A and not all of the other techs visits. How can I do this?Thank you,Hunter------------------------------Hunter Daniel------------------------------
New to Quickbase. I've already imported my CSV files and disconnected. Then I've set up my relationships and forms. When I got to my address fields, I noticed there is no option for me to change the "type" to address. I've now created Address Fields (with it's subfields) that will become a map and want to transfer the data from my original fields of:Service Address L1Service Address L2Service Address CityService Address StateService Address ZipIs there a way to do this? ------------------------------Jillian Perry------------------------------
I have 3 tables in an app- purchase orders, items, and inventory. Currently I have it set up so that when a order arrives, the related fields for the purchase order and the item are added into an inventory entry. Usually when we order a box of items, we get for example 4 packs in the box, so after adding one item to the inventory table, we select the "copy item" to add the remaining 3 packs to inventory table. The issue I'm facing is that the Purchase order info from the first item does not copy over for the remaining items. Is there anyway to make this work? Thanks in advance!------------------------------Yasmin Boyrati------------------------------
Hello everyone, I have managed to get reports from Quickbase to JasperReports.In case that seems like a good option to you, I am available to help you.------------------------------Marcelo Benavides Torresmarbentor@gmail.com------------------------------
I'm trying to create target serviceability dates, with multiple conditions, and it's seeming to only want to acknowledge the first portion of the logic. I am using relationship date fields, maybe that's where this is going left? I'm also going to need to change this for my actual serviceability dates, which uses similar logic. Your help is appreciated! If the DIA Due Date is after the Splicing Target Completion AND the DIA Received/Completed date is before the Splicing Target Completion - use Splicing Target completionIf the DIA Due date is after the Splicing Target Completion AND the DIA Received/Complete date is Empty - use the DIA Due DateOtherwise - use the Splicing Target CompletionIf(ToText([Hut - DIA Due Date])>ToText([Splicing Target Completion Date]) and ToText([Hut - DIA Received/Complete])<ToText([Splicing Target Completion Date]),[Splicing Target Completion Date],If(ToText([Hut - DIA Due Date])>ToText([Splicing Target Completion Date]) and IsNull([Hut - DIA Re
The Quickbase Junkie has a nice help page on Query Syntax, which have many uses including to be used on Formula Queries.How to write Queries in QuickbaseWhat is the difference between the operator .EX. and .TV. ?thxMark------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------
I have several code snippets which work fine in desktop mode to make my own save button. One is URL formula and the other two are formula Rich Text.Does anyone have code to make a save button which will work in Mobile web mode?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------
I have a Multi-Select field [Badge:Patient Type] that is calculated through a relationship in a separate table. The resulting field could contain one or more of 30 different bubbles (terms).I need a formula that could look at that field and translate each term to a point value or number and add those numbers up. Example:[Badge:Patient Type] field contains the value ED; Clinic; OP[Specialty Points] field would contain a formula that said IF [Badge:Patient Type] contains "ED" then 3 PLUS if if contains Clinic, then 3 points, PLUS if it contains OP 1 point, etc.RESULT would equal 7Is this possible or am I thinking of this all wrong.This is the formula I have so far:Sum(If( Contains( [Badge: Patient Type], "Inpatient"), 5)+If( Contains( [Badge: Patient Type], "PF-Hospitalist"), 2)+If( Contains( [Badge: Patient Type], "PF-Surgery"), 2)+If( Contains( [Badge: Patient Type], "PF-Anesthesia"), 2)+If( Contains( [Badge: Patient Type], "OPS"), 3)+If( Contains( [Badge: Patient Type], "GI"), 1)+If(
I have an app for project managers. When they create an activity, they can assign that activity to a project team member or other resource. The Assigned To field in the Activities table is a multi-select text field. The Assigned To field is pulling from the Resource Name field in the Resources table. As project managers identify new resources, they can add those resources to the Resources table. The problem now is the Resources table has 118 resources. The Assigned To field, being a multi-select text field, can only handle 100 maximum entries (I didn't know that when I set up the field. Argh!). So, now I can't edit that field, because when I do, I get this error: Choices too long. 118 choices specified. Field may not have more than 100 choices. And over time, we're going to have more than that.My research shows I should have created a one-to-many relationship between the Activities and Resources tables and use the reference field as the source for the dropdown.
Hello, Below is a YouTube of something I want to do so badly for one of my tables, and I cannot figure out how to configure it to my tables. The examples he provided are tailored to his table.Please help! I have reached out to QuickBase support as well, and they've been trying to do something for over a month, it is something I need sooner than later, and this is exactly the way I want it, I just can't read the code well enough. SOS?https://www.youtube.com/watch?v=OtE_j7kPJK0Update* I still haven't received any kind of help. SOS?------------------------------Savi Newman------------------------------
In a summary chart over time we want to be able to find or 'flag' days that show an increased change in 'Encounters', up or down. Example if on a normal business day, say a Monday there are 75 encounters but then next Monday only 40, that's a decrease by 47%. The Encounter App lists various locations and the number of encounters that happen from Monday through Friday and 900 for all locations is the goal line, with about half (450) on Friday's as some of the clinics are only open a partial part of the day. I have been looking for a good tutorial or three on this as I have ideas, but sometimes it helps to see some similar examples.------------------------------Bob T.------------------------------
...annoyingWhen I copy a tab, it moves the new tab to the end. When I try to move the tab to the front of the line-up, there is serious lag time. I have 10 tabs on the dashboard.Thoughts? Suggestions?thank you------------------------------BuildPro------------------------------
Having trouble getting a formula to do what i want.I want to add up the following items, but one of the items is already a formula and I when i out it in the formula to get a total unless that one has a number no total shows. How can I get the formula to say if nothing is in that spot to just assume its zero.example: Hotel expenses + Flat rate + Mileage Cost total = TotalMileage cost total is a numeric formula that is If([Mileage] >15, [Mileage Cost]). Hotel expenses and flat rate are both just numbers type into the field. Hoept his makes sense. Any duggestions are welcome------------------------------Rebecca Knecht, MS, ACSM-CEP------------------------------
Hello, I need to find a way to automatically uncheck a box if the record is updated and the box is checked on the record that should be current and used. An example would be when a new record is entered and the most recent POC box is checked it would uncheck that box in other records related to that member. ------------------------------Lorrie B------------------------------
I have a child record that includes a URL button to make a checkbox true. The button fine; however I am clicking on the button from a related report and when I save it, it displays the child record, and I want it to display the parent record. Here is the syntax that I have...URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &"&rid=" & [Record ID#] &//"&apptoken=bw9qkxbcsg3avvqpucu5drussvk" &"&_fid_24=1" &"&_fid_8=" & Today() &"&rdr=" & URLRoot() & "db/" & [_DBID_RECORDS] & "?a=dr&rid=" & [Related Build][Related Build" is the parent record.thank you for any help.------------------------------Jason Beaver------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.