Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
When I print a form from QuickBase the font size is tiny to the point where it is almost unreadable. How can I make the font size larger when printing? I have already changed my profile to the relaxed mode it did not work. ------------------------------Denise Keck------------------------------
I use a calendar to enter my trucking dispatches. Payroll needs the load and unload dates to be correct, but in situations where the driver takes a load home with them and delivers two days later, it's best for dispatch to see the load listed on the day prior to delivery date. I'm very unfamiliar with how to set up Quickbase, so any guidance on how best to resolve this would be great. Should i just add another date field and base the calendar on a dispatch view? Or should I make my own calendar? What makes the most sense? Thanks! Jess ------------------------------Jess Hill------------------------------
I created an App Users table to manage permissions throughout several apps. The table uses a User type field which is the table's key field. In another table, Assessments, I added a multi-select text field, TC Name, which gets its input values from the App Users: User field. When I go to the Assessments table form to add a user(s) from that multi-select text field, TC Name, I get a list of negative numeric values. Any idea why this is happening?------------------------------AR------------------------------
I have a table of costs, and a table of revenue. At this point I have a summary table of months, with a 'key' in both revenue and costs tables, to look at everything on a monthly basis. With the introduction of dashboards, summary formulas in reports, formula queries, etc, is there a better way to do this now? I still think i need a summary table to accomplish this, but am wondering if this is still true?Ultimately, I am trying to look at gross margin and other items which involve formulas between costs and revenue.------------------------------Mike Tamoush------------------------------
I am trying to auto import data from a CSV. I tried syncing to Box/Dropbox. The problem is, the csv I get is saved as UTF-16 and to sync it must be UTF-8.So in order for me to sync I would need to open up the file, and save-as a different format. I am trying to automate the entire process, so once a human has to open a file and save as, it blows that process.Is there a way using Pipelines? Can I grab the file from email, or some other spot and parse through it?------------------------------Mike Tamoush------------------------------
Is there a way to make the dynamic filter default to 'current user'? I have individual users and they are also part of a team, but I want the dashboard view to default to the current user unless they change it. I cannot see a way to do this currently. Right now every time you load the dashboard, it defaults to *clear* so they have to select themselves each time they load it.Am I missing something?------------------------------Jeff Peterson------------------------------
Hello everyone,I followed Kirk's Magic Buttons application tutorial regarding adding a button that allows you to add multiple attachments. The functionality seems to work overall well for what I am using it for except one odd mishap. If I use the custom multi-attachment button on a new record, it does not save the record ID along with any other related record information to the "Pictures" table I've created; however, if I use the native "Add Picture" button that was automatically created by the relationship between the two tables, it works as intended... The oddest part is, after I use the native "Add Picture" button, the custom multi-attachment button starts to work as it should if I use it AFTER using the native Add Picture button.I hope this makes sense, I am newer to QuickBase so my terminology may be a bit off. Let me know if I can provide better information. Thanks everyone.------------------------------Michael Martin------------------------------
I am new to Pipelines and also new to Master Tables and would like community guidance:Use Case: We have a complex Project Management Tracking System built in QuickBase. (400 projects, 150 users, 40 of which are Project Managers) The Project Table has 1:many relationship to the Tasks Table. The Task Master Table also has a 1:many relationship to the Tasks Table. There are 50 tasks located in the Task Master Table that need to be populated to the Tasks Table each time a new Project record is changed to confirm that the Project Requestor has completed their preliminary scoping documentation. We currently do not permit the Project Managers to add / delete tasks since these 50 tasks are required (and sufficient for tracking purposes). What is the best method to automatically create the 50 new task records in the Tasks table each time a New Project Request has been completed? In QuickBase documentation, there is an article on Master Tables, but before I go that rout
I'm trying to create a rich text button which will open a report where certain dates are null. I've verified by running the report manually that the report does find results however when I use the rich text button I get no results. I've tested in both the button and in the developer.quickbase.com site and have confirmed no results in both places - thus I'm positive it's something to do with my query structure.The query I've passed is:"{94.EX.8}and({24.XEX.''}or{25.XEX.''}or{70.XEX.''}or{71.XEX.''})"Fields 24, 25, 70 and 71 are all Date fields and 94 is the related record. What I'm trying to achieve is "Show me all results where any of the 4 date fields are not null". TIA!------------------------------Jeremy LahnersLeadBaller------------------------------
@Quick Base Junkie gives an amazing tutorial on Formula Queries. Also, previously in the community explained HAS vs CT (contains). The difference being, HAS looks at a multi select text and must match an entire part.For example: Monday; Tuesday ; WednesdayIf you use contains Day, it will yield a result, if you use HAS day, it will not. You would need HAS Monday, or something like that.Makes sense, but I can't seem to get it to work in practice.I have a 'Classifications' multi select text field, which often only has one item select. In a good example, in one instance only the selection "Engineer" is selected in the multi select text field. My search query:{14.CT.'Engineer'} returns a result as expected.{14.HAS.'Engineer'} returns no result. I expected both to return the same result in this particular case. What am I misunderstanding?------------------------------Mike Tamoush------------------------------
Current Setup as follows:Employees have Many Audits.Employee Table with fields: Name (text field), and User Name (User field).Audit table with lookup fields: Employee Name (Text, Proxy)Goal is to set the Related Employee to the current user, if the Related Employee is blank (essentially, set the default for Related Employee to be Current User). I can't just set the default to 'Current User' because related fields are numeric. I could potentially make my key field on my employees table be the user name, but I don't want to do that for some other reasons that will get me in trouble.Current almost working solution: I have a formula query on my Audit table that goes and finds the record ID in the Employee table, of the Current user (I match up emails from the current user to the email in the employee table). Now that I have the record ID, I have a simple dynamic form rule that says, if the related employee is blank, set the related employee to the number in the formula query. Works p
I have a requirement to prevent users from accessing records in bulk. The user must lookup the record by an identifier they receive from another system. This is required due to an obligation to purge the Personally Identifiable information contained in those records from all of our systems once the person associated with the record has terminated service. Our plan is to use quickbase to store the Personally Identifiable information that could be looked up using an identifier. All other systems would only store the identifier where if a user needed the Personally Identifiable Information they would use the identifier to look it up in quickbase. To do this I added a search widget to the default dashboard restricting it to exact match. I also hid all tables, reports, customize report options and modified the default "All Items" report to return no results. The issue I'm having is hiding these features does not deny those features. By copying shortcuts to these features then testing under
Hello I am rather new to Quickbase.I anticipate developing a table where users enter our customer company information into. I plan on having a field to designate if the customer company is a parent or a child company. This will be a True False field. True indicates a child company and False indicates a parent company. To designate what parent/company the child/company rolls up to I am thinking of a drop down field which pulls the distinct values of this table (where the roll up designation is false(Parents)) Thus I plan on using one table for parent and the child and designate between parent and child by this field. Reason for not using classic parent child relationship(two tables)If I use the classic parent child relationship I would have two tables and in most cases the parent information would be exactly the same as the child. Fully 95% of our customers do not rollup into another company. I am thinking in this situation the users
We have several child tables to a single parent table. When it shows the related parent table, it lists it as a numerical value (Record ID). For example, the related location to a specific permit is 14. I would like it to list the name of the related location. I have tried using the record picker option, but it still shows as a number on the default report.Any help on how to do that? ------------------------------Kandice Bailey------------------------------
Hello, I have set up a series of automations and imports and have it working perfectly for my needs. The only thing I can not figure out is how to add a link to a profile from one table using import to another table. The way i have it all set up the table to table relationships aren't working. I will explain further:I have agencies in table A that get submitted for approval from table A. Through a series of automations and imports they will then appear on table B where they are approved or declined. I would like to be able to include a link on table B to the agency profile on table A. So when the person is reviewing the agency for approval they can easily click a link to the profile instead of having to search for it on table A. I know how to do this using relationship and I don't know if this is possible with out a relationship, but when i set up the table to table relationship, all the fields appear blank. Here is a screen shot of table B if it helps:My thought pr
I have an app where somehow I disabled the Reports & Charts Panel for everyone except administrators (the dropdown does not even appear for users). Now I want to go back and undo this but cannot figure out where the setting is. Been trying to find it for hours now....does anyone know where this might be?Thanks!!------------------------------Brian Petzold------------------------------
I am very new to this so let me see if I can explain what I'm trying to accomplish. I have built multiple tables, the main table will be a work order with the customers info and all that. I have multiple other tables that will be separate task that make up the entire work order. I have included a check box on each task table to indicate that task of the work order is done. What I need to figure out is once all the task are checked complete I need a check box to be ticked on my main table that the entire order is complete. I don't know how to write a formula for it.------------------------------preston mcdonald------------------------------
Hello,I have a percentage variance that appears as a formula derived from 2 other fields.I would love to see a number change color when it's higher than 100% or less than 100% in a given situation, and in green when it's the opposite.Is this something that I place in the formula beneath it? I've been searching where I change and edit aspects of the field, but all I see is display it in Bold.Thank you very much for your support!------------------------------Anthony Wong------------------------------
I am migrating some data from another system that already had a UniqueID and the records started at 10,000 originally because I don't think the data set was going to get big I just did this so if it was 0, just default to the Record ID, but I think it will be good to start off where they left off so I was wondering how to use this formula but have it start an auto number at 11,000?If(Nz([NF Owner Number])=0,[Record ID#],[NF Owner Number])------------------------------Ryan Locke------------------------------
I'm creating a record in QB on receipt of an email in Outlook but whenever I get reply to the email I would like to update the email body in QB instead of creating a new record.ID is not same for the new email and reply for it, I believe we can't use ID.Appreciate help on this.------------------------------Avinash Hiremath------------------------------
Hello, can anyone please help me with this logic?Formula for field type: Date(forumla) If([Match]="Y",ToDate("GetFieldValues(GetRecords("{12.EX.'" & [NUM1] & "'}",[_DBID_UPLOAD]),15)"),ToDate("Jan 30, 2000"))Error: Expecting Datetime/workdate but found textlist I am trying to say, if field Match="Y", then use date from UPLOAD table by matching NUM1 in details with NUM1 in Overrides.Field ID 15 in table: UPLOAD is date.------------------------------Siva------------------------------
Hi all! First time poster here. I have been working on this problem for a few days now, plus religiously combing through all these wonderful discussion posts; but still can't find my answer.Here's my problem: I work for a real estate company and am tasked with designing our database. Right now I have two tables, one is Transactions and the other is Agents. Every transaction has at least one agent, but sometimes it has two. I want to be able to assign each transaction to two different agents, so that when I pull an agent, it will show each transaction they were involved with. Each agent has a different split commission percentage. This means the total from the transaction is split differently for each agent in the transaction. I only want the split commission to be linked to each respective agent. So if Agent 1 is Jane Doe and Agent 2 is John Deer, I don't want Jane's commission to be linked to John and vice versa. I got through the first step, but the second one really stumpe
Good AfternoonCan i create a cascading drop-down for the following set-up and if so, how:Parent: StateChild (Multi-Select): Medicaid ContractsThanks,Lashell------------------------------Lashell Thomas------------------------------
Hi! Date formulas always get me. Here's what I'm trying to do: If ([Paid Date] + Days(15)) is on or before the 15th of the month, set the date to that month/day 15/year. If ([Paid Date] + Days(15)) is after the 15th of the month, set the date to the upcoming month/day 1/year.Really just looking to add 15 days to the paid date and then set to the next pay date either the next 1st or 15th.Any help would be amazing!Thank You!------------------------------Chris------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.