Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I'm working on a patient encounter table. A physician name is populated in this field. As you can see from the form, you can put in any name as I have for Dr. Benjamin Spock. The format used is last name, first name. The Provider Full Name table (prvdrfullnmes are all capitalized) names have been set in some other table, I believe, so I can't add any there at present. BUT the I want the provider names in the Encounters table to ONLY come from the names in the prvdrfullnmes table. How do I go about this?------------------------------Bob T.------------------------------
I have a design flaw in my App that I would like to correct. Please help? Problem Statement: I have a large app with a Primary Parent Table and numerous Children Tables. I recently added ~50 fields to the Parent Table that really should have been designed to be in a new Child Table. These 50 fields are displayed on a single tab on a complicated form. This is a new design feature and is currently hidden from ~200 users.Desired State:- I would like to move the 50 fields to a new Child Table- I would like to move the form tab to a new form associated to the Child Table.What is the most efficient way to achieve desired state?------------------------------Annetta Coleman------------------------------
I have a lookup field from a parent table, where the field auto-populates based on selection in the reference field. However today it stopped working properly. The values are all still in each record, but if I add a new record, the lookup field no longer auto-populates. Also, if I take an existing record and change the reference field value, the lookup field populates with "???", although if I put the reference field value back, the lookup field re-populates with correct value.I've made no changes to the lookup field or the relationship. I have made other unrelated changes to the child table (which is a join table in a many-to-many relationship). I tried removing the lookup field and adding it back, but it did not fix it. Can anyone help? Thank you!Parent table = ControlsParent table reference field = Control IDParent table lookup field = Control Description (NOT WORKING)Child table = Evidences Mapped to ControlsAdding new record:Existing record:------------------------------Diane Sina
I would like to see some other users that have well designed forms. We have a number of what we think are good forms but would like to see some forms that are being used by other companies. The application does not matter but we use QuickBase to manage our real estate, Properties/Buildings/Leases/Projects.Rob------------------------------Rob Peterson------------------------------
So I just noticed that in the default fields like [Date Created] the system uses 'PST' for Pacific Standard Time, but in a Date/Time type field, it uses 'PDT' for Pacific Daylight Time.I was working on a project to correct some time zone related problems and just noticed this.Not a big deal, but for consistency, [Date Created] should show PDT.------------------------------Jeff Peterson------------------------------
I created a connected table with a csv file. The initial data file loaded successfully.However, any subsequent csv files uploaded to the QB connected table sync folder are not being refreshed.The connected refresh activity history states the data was refreshed successfully. however the original csv data file reappears. It seems the refresh data button is always picking up the original csv file in which the connected table was created.Any thoughts?------------------------------George Romanowski------------------------------
We have a process which copies a parent record and all children, I need to make sure some relationships are reset...Will an automation set on the child records clear out fields that I specify with a value of blank?
Is there a way to have a formula field be unique to and have different values for, each record? Each of the 40 records in our Locations table has fields that describe the location and these are unique to each record. For instance, the address field. However, the formula fields in this table are 'universal' by Quickbase design; the formula field has the same value and performs the same calculation across all records using values in fields that change with each record. Is there a way though to have the ability to put a different formula in the same field in each record so that it will use the right numbers for each individual record?We have 40 locations that have tanks for liquid storage. Every location has different size tanks. We measure the tanks with yardsticks, such that each inch of height equals a specific volume. I made a simple CASE formula that will return a volume for each tank given an inch measurement. I found that the numeric entry fields would change with each record but t
I have a formula text button in a table to check a box in one table, fire an Action to create a new record in another table. Right now the formula takes me back to the original table. I need to go to the record in the new table.
I have Utility usage (electricity, nat gas, water) for 2021 and 2022. What I would like to do is compare the two years and do a percent difference for each plant. Any ideas how to do that? The calculation is easy but how can I get Jan 2021 electricity for a plant on the record for Jan 2022? ------------------------------Sarah Burres------------------------------
In this report, multiple users will be adding a comment for each record. Last column will save the historical comment data. This column is a concatenation of first 5 columns and keep appending data whenever any new user save comment. I want to create a formula to automatically update the last column. Can this be done in QuickBase? Please advise. Comment Date Added by user Delegate ID Delegate Name Comment Summary Added new column to the DB 3/23/2022 Mrunali 123 John Added new table to the DB 3/21/2022 [Deb] 356 Priya]Added new column to the DB 3/23/2022 [Mrunali] [123 John] ------------------------------Mrunali Kadam------------------------------
I've always read, and indeed from my own experience, to keep the number of apps I have to a minimum, if possible. This is for a few reasons:1. Avoid Cross App Relationships2. Much easier to manage (more apps is more role management, security access mgmt, more dashboards, home pages, etc).I tend to only separate apps in a few circumstances:1. It is a clear and major division (perhaps 2 companies, 2 very different business goals, etc).2. I can definitely keep that app separate from any other app, thus not sharing system resources.I do have app 'clusters', that is to say I have 3 apps with cross app relationships, then a cluster of another 2 apps with cross app relationships. Those clusters are separated though and don't share system resources.Do other people have other takes on this? Many apps vs minimal apps?------------------------------Mike Tamoush------------------------------
When I try to have a pipeline get triggered by "Row updated", it doesn't work; the pipeline only works when I manually sync the pipeline. Has anyone ever ran into this issue? If so, how did you resolve it?Context: I've successfully synced google sheets to quickbase via pipelines. Now, data entered in google sheets syncs to QuickBase when I click the sync to pipelines button. My goal now is to get Google sheets to sync to QB right when a google sheets row is updated (without me clicking the button).Any help would be greatly appreciated. Thank you.------------------------------Hagos Hagos------------------------------
So I was trying out the CSV connected table functionality with Box.As I was getting a feel for how things flowed through my app and testing different fields for the 4 Refresh Key criteria, I went through a few cycles of deleting the records in the connected table, and moving the previously imported CSV files from "Done" back to the main folder for further import testing.[For additional context, this app has a secondary table which uses a Quick Base Action to automatically copy new records from the connected table to the second table based on a another set of filter criteria.]After ~2-3 rounds of the above debugging/testing the process, QB started processing the CSV files as expected - the relevant/expected records were copied from the connected table to the secondary table perfectly, and QB moved the CSV file to the Done folder when complete, BUT the connected table did not display ANY records. I did see as the page was refreshing that QB would briefly flash to the expected
Hi , I wish to check if a field(text) is empty and assign value accordinglySO in Below if First Name then take Last Name---{% if a.first_name %} {{a.last_name}} {% else %} {{a.first_name}} {% endif %} ------------------------------Prashant Maheshwari------------------------------
Need formula to include weekday count onlydate field [START - HANG] +numeric field [DW DAYS ALLOWED] =date field [TARGET SAND DATE][START - HANG] = 3/24/2022[DW DAYS ALLOWED] = 8[TARGET SAND DATE] should equal 4/4/2022thank you------------------------------BuildPro------------------------------
HelloI was trying to apply "searchandreplace" to replace line break from log enabled text field.Sample data of text field (two single line entry as log)[MAY-18-21 XXX UUU] Test[MAY-19-21 XXX UUU] Test2Was trying to remove line break and merge the two lines in single linesearchandreplace([Data Field],"\n","|")Even tried with "\\n" but no change.Any suggestion please?------------------------------Forhad Anwar------------------------------
I'm trying to Fetch JSON Weather data. I have read all the documentation I can locate and I'm close but not quite there.The API call returns JSON with what seems to be header type info and then an array of 8 days of forecast weather.This is the public API Call http://api.openweathermap.org/data/2.5/onecall?lat=45.0&lon=-79.6&exclude=current,minutely,hourly,alerts&units=metric&appid=de24bdce24cd4ee879fc18e05f27e5afHere is the sample response{"lat": 45,"lon": -79.6,"timezone": "America/Nipigon","timezone_offset": -14400,"daily": [{"dt": 1647795600,"sunrise": 1647775291,"sunset": 1647819010,"moonrise": 1647829920,"moonset": 1647779880,"moon_phase": 0.58,"temp": {"day": 2.76,"min": 0.32,"max": 5.41,"night": 1.07,"eve": 2.78,"morn": 0.8},"feels_like": {"day": -1.21,"night": -1.67,"eve": -0.94,"morn": -3.39},"pressure": 1012,"humidity": 86,"dew_point": 0.66,"wind_speed": 5.04,"wind_deg": 292,"wind_gust": 11.22,"weather": [{"id": 616,"main": "Snow","description": "rain and sno
Hello,I have a formula URL I am using as a button on a report to allow the user to add a new record. Once they save the record is there a way to redirect them back to the report they started from? Currently, when i click save and close it redirects me to the saved record view.I have tried adding & 'rdr=" & URLEncode(URLRoot() & "db/" & & "?a=q&qid =130" )and also have tried just putting the direct link for the report into the formula but neither change the behavior when the new record is saved.------------------------------Thanks in advance,Jennifer Paschal------------------------------
Hi. I need to create different user groups such as Supplier, R&D, Regulatory, etc so that when i add a user field to the form, its not just a drop down of all 100s of users in the app. Can anyone guide me where to start?------------------------------Shelly Ann Aiken------------------------------
I've noticed that when you look at the field properties under the usage tab, sometimes it shows which dynamic form rules that field is used in, and other times it does not. Does anyone know why this is? Which fields are shown and which are not?It seems arbitrary to me but I am sure there must be a consistency I just can't find.------------------------------Mike Tamoush------------------------------
PARENT TABLE: Subs/SuppliersCHILD TABLE: Sub PayrollFIELD I'm having trouble with: [Completed by:]Report Type: TableUse in grid edit mode to select [Completed by:] namePlease see attachment for more detail.------------------------------BuildPro------------------------------
There was a filter under each column in the report but not sure when/why it keeps disappearing and how to activate it back?Also., I noticed Customize page icon is not visible sometimes. user, role is same though. Please advise.------------------------------Mrunali Kadam------------------------------
I am getting the following errors when trying to update the parent record with updates in a child record. Updates in child record address sub-fields are to update address sub-fields in Parent record. What does this errors mean? ------------------------------George Bramhall------------------------------
I have two tables; Release Orders and Release Order Line Items (parent, child respectively of course). Instead of adding each RO Line item individually, selecting a conditional drop down field, adding quantities and then saving, I want the end user to be able to select the conditional drop down field from the embedded editable table in the Release Order table, enter the Qty of the and fly through the order. Unfortunately, I am unable to find a simple solution for this issue . If there is a native way to perform this, I'd like to hire a developer quickly. :)
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.