Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
The most common Quickbase table relationship is a one-to-many relationship as I explained in my previous blog. (Example: One customer can have Many orders) But what if we were in a situation where two tables related as a many-to-many? Example, you have two tables (Students and Classes) where students can have many classes and classes can have many students. You wouldn’t want to solve with a one-to-many format making them both parent and child tables to one another because you would essentially be entering data twice, and it wouldn’t be the most efficient manner in entering information. The best solution would be to create a many-to-many relationship.A Many to Many relationship is a method for connecting two tables that both need to be the parent table, through a third intermediary (or “join”) table. Example: My “AHA” moment: The key to creating the many to many relationships and understanding their flow is the join table. The join table houses any combination of data between the two
I'm struggling to accomplish something that I expected to be somewhat simple, but I can't seem to figure out on my own.I have a table of "Deals" that I am trying to associate with another table of "Spaces" (think parking spaces in a parking lot).Essentially I want the form on the deals form to allow me to add multiple unassigned spaces to a given deal. Almost like assigned seating on an airplane.When I create a one to many relationship, it adds an 'Add Space' button and after changing the linked report to display the records of associated spaces I can add 'new spaces' but I can't figure out how to, instead of showing me blank data entry form, instead show me a list of Spaces to choose from.I feel like I've been able to do this fairly simply in the past but just can't figure out what I am doing wrong.Anyone have any ideas or be able to give me some guidance?Thanks,PhilD------------------------------Phil Dupont------------------------------
I would like to create a custom formula field in a report so the user only has to select one option and not three.Right now I have a report that looks at three fields. The assigned to field, the transferred to field and the reopened by field. All of these are users fields. The user running the report has to select the user they want to see records for three times, once for each field.I would like to be able for them to select the user one time and it look at all three fields for that user.Can this be done and how would the formula look?Thanks------------------------------Carol Mcconnell------------------------------
I have a many to many table that includes a distance value between 2 related parent table records. When either a Parent 1 or Parent 2 record is added I want to create a record in the many to many table ... result being that for each Parent 2 there will be distance for Parent 1. Currently there are 300 records in Parent 1 and 60 records in Parent 2. I have manually imported from a csv 18000 records in to the many to many table. What does the pipeline look like that creates additonal records automatically when either a Parent 1 or Parent 2 record is added.------------------------------George Bramhall------------------------------
I have created a formula text field in a table that defines an error for data entered within a record. Can I abort the save of a grid edit report if this error appears in one or more of the grid edit report records?------------------------------George Bramhall------------------------------
Go to our help center to read an updated version of this post and learn more about Quickbase accessibility. Quickbase is a mature platform, having been developed and iterated on for 20+ years. The platform currently receives over 2 billion requests per month and has hundreds of thousands of active users. We are committed to ensuring Quickbase is an accessible platform for all of these users, a value you’ll see reflected in the product areas we modernize. As we continue to invest in adding features and making it more usable and delightful, it is important Quickbase is accessible and inclusive to everyone. This may include users with physical disabilities, motor or vision impairments. This is often referred to as “Accessibility”. As the head of the User Experience team here at Quickbase, my team of designers and I work closely with a dedicated team of developers that are trained in WCAG 2.1 AA standards. Collectively, we support all our development teams and continue to drive p
Hi all!We have a timeline report designed using the new style with color customization and all. We think the new timeline report style is a big improvement on the old one.We'd like to print the whole report to PDF so we can share it with a client, but when we use the Quickbase print dialog the report that appears is the old style with none of the color customization we use. We also tried making the report full screen and printing the page with the browser dialog but it only prints what is visible on the page as its scrolled, not the contents of the viewport containing the whole report.How do I print the entire timeline report as it appears to me on the webpage?Thanks!Chrisattached: what I see on the webpage vs what I see when I use the print dialog------------------------------Christopher Knieste------------------------------
Hi everyone,This feels like it ought to be a simple question, but I can't figure it out.I have built a Parent table of Communities and Regions (Region A = Communities 1, 2, and 3; Region B = Communities 4, 5, and 6; etc).This is connected to a Child Table of attendees to online events. I want to relate to two fields within this single Child Table: To both the Community the Event was intended For; AND to the Community the attendee Lives in. I can only seem to get it to relate to One of the two fields; not both. Is it possible? Or do I need a secondary table of communities to make this happen? Thank you for any suggestions you have!Jen------------------------------Jennifer Juhasz------------------------------
I've done formula queries before (still new, but can successfully make them work). I am banging my head against the wall trying to make something work. The actual goal is simpler than what I post below, but if I can get below to work, then I can achieve my ultimate goal.This for me works:Size(GetRecord(1))Simply, get the count of record ID 1 in current table. The value of '1' is returned. This does not workSize(GetRecord(1,"dbid")I assumed this would look in the table with the dbid id that matched for record ID 1, and return '1'. But it does not. I double checked that Record ID 1 exists and double checked the dbid ID. So i am assuming it is my syntax?UPDATE: Disregard, as soon as i posted this I realized I was trying to query a table in a different app which doesn't work at this time.What do I have wrong in this very basic formula? ------------------------------Mike Tamoush------------------------------
I have added a new field EXT.PT SENTNO is the default value.However, it is not populating.See attached, pleasethank you------------------------------BuildPro------------------------------
There is a requirement to capture Street3 and District level information as well in the Address Subfields.. Would it be possible to add Street3 and District columns as well in the Subfields.. ------------------------------vijay singh------------------------------
I've seen a post similar to mine but the thread was old.I am looking to see if there is a way for me to make a Formula - URL or a Formula Rich Text button that will basically mimic the Save & Keep Working button. The roadblock I'm coming across is that I have report link table (from another table, of course) in my form in which a user can select options, put notes in, etc etc. Any time i try to use something like: URLRoot() & "db/" & Dbid() & "?a=dr&dfid=2&rid=" & URLEncode([Record ID#])& "&rdr="&URLEncode(URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl())it's asking me if i'm sure if i want to leave as the changes will be unsaved. Is there any way for me to make a Save & Keep Working button that will save the changes in the report link? Basically, i want to press it and refresh the page as once changes happen on the report link table, i have a pipeline running. The users have to refresh the page itself to
On a Sales Page I have two sales reports that show the "previous month" and the "month before" sales individually in two different reports and I'd like a text section above each report to read December 2021 Sales and November 2021 Sales respectively. Kicker is Id like it to change when the month changes as the reports auto change themselves.If January 2022 display December 2021andIf January 2022 display November 2021Any help is much appreciated.------------------------------Michael Knecht------------------------------
Report displayed as below -(Field 1) Stage Field 2) Type (Field 3) SubtotalTemp Services Material $500Temp Services Labour $100Power Material $200Power Labour Cable
I'm wondering if anyone has figured a way to use the Quick Books Online (QBO) "based on location" sales tax rates in Quick Base (QB)?I created a sales order entry (Estimate) form for our company, but one of the things is needs to do is calculate the sales tax rates as "based on location" so it matches when exported to QBO. For years I have been successfully exporting sales orders from QB to QBO using Workato, using just a state table of current tax rates I have setup in QB. However, with things changing I need to make the switch to the "based on location" method of figuring the sales tax rates.I'm hoping it is possible to just query QBO to populate the tax info in the QB Estimate. Once it becomes an order, I can then export to QBO like I have been doing, and the sales tax amounts will match.Has anyone else tacked this issue? if so, any guidance would be appreciated.------------------------------Mark Corcoran------------------------------
When will the Workday Pipeline be implemented?Do you know anything about this?Thanks------------------------------Jaime Fonseca------------------------------
99% of the time, if I am importing from clipboard and my column headings match exactly the field names in QuickBase, QB lines everything up correctly.However, every so often, it does not. In once case, I have copy/pasted my column heading as my field name to be sure it's spelled the same with the same amount of spaces. Yet every time QB guesses wrong. Anyone ever run into this? It's easy to import incorrectly if you glance over the columns to fast. In my case I have many columns. QB gets them all correct except 2: Earned Revenue and Billed Revenue. It always switches these around. Any idea why?------------------------------Mike Tamoush------------------------------
I have a table called "Orders" which has child records in a "Raw Goods" table. Recently, when a user manually creates a child record, approximately 30 blank child records will show up. See below. Any idea why that would happen? ------------------------------Kiel Berry------------------------------
Hello, I have locked down the majority of my fields for editing by non-admin users. However, I would still like to allow all users to create new entries. Is there a way to set up a dynamic rule for this? Right now when a user goes to add a new profile they can not edit anything. I'm thinking the answer is no, since the problem I am running into is that QB does not recognize the fields for this rule until a profile is created and the users can't create a profile because the fields are locked.------------------------------Jessica Stevens------------------------------
I am confused about parent to child relationships within a singular table. In my app "Competencies" I have a table for each type of staff. In my table for nurses, I track all competencies for nurses, however, I want to make it that each nurse competency type has many of the same types. Would I be able to make a parent to child relationship for the fields within this one table. If so how would I be able to do this ?------------------------------Campbell------------------------------
Hello, I've tried report links, URL's, Formulas etc...and I can't seem to get it to communicate.I have a customers table, where I input all their information for their "account" (Email, Phone, Address)and I have a service call table, this table is something I fill out when they request work to be done. When work is requested by calling me, I have on their account page a "add service call" button in their account, it directs me to my "service call table"How can I get it, so when I press "add service call" it auto populates their specific information into the service call? (Name, Phone Number, Address, E-Mail) while still allowing me to modify the details of the work they want done? Is this possible? I know how to get two fields to speak to each other when within the same table, but can't seem to get separate table fields to talk.------------------------------Newman, Savi------------------------------
Hello:I am just trying to create a date stamp on an Exact Forms Plus document. Simply the date that document was created.Trying to determine the right format. I know there is the [EF PDF Date] field, but that is created as the document is generated and does not appear/post on the new Exact Forms PDF.I've tried ~Now ()~, but that is incorrect.What am I doing wrong?Dirk------------------------------Dirk Ruana------------------------------
I am having an issue with a Logo in my Exact Form Template.I was able to make it work last week. I went back to the Template to makechanges and since then it keeps telling me the file I'm trying to insert (Logo File)does not exist.I have tried uploading it to the Document Library application I downloaded. I also triedsaving it as a File Attachment directly in my application.Any thoughts?Thanks,Chad KragnessTimber Technologies, LLCUser since August 2021------------------------------Chad Kragness------------------------------
I'm a little rusty as it's been a few months since I changed anything. I'm struggling with this issue.I have a "job" form with a pick list of contact names from the customer "contacts table"I want to have 2 pick lists on the form, one is to pick the customer's project manager, the other is to pick the billing contact.my problem is that when I change one of the selections, the other details from the other picklist is changed.how can I have 2 of these? what am I doing wrong?screenshot attached of form & relationship diagram------------------------------Johnny------------------------------
Good day,Please assist, I changed the username and email and now all information that we had on the WL report has disappeared.------------------------------Abigail Mathobo------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.