Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I have an app tracking our department's flight delays. Depending on origin/destination of the flight, it's assigned to a group at a specific base. I currently have my app set up to "assign" the delay to a specific user with a table to table relationship based on airport code. On the dashboard, reports pull data based on the current user being in the "assigned" field. More than one person in each base may be responsible for following up with these delays. Is there a way to designate a user group, or multiple users (without making separate fields for each position) instead of one user to a record?If I can offer any other information to advise on this, let me know! Thank you!
Came across this today. Putting it here in case someone else also finds this and doesn't want to spend 45 minutes to track it down.If a User is in the App via Group and not an Individual User, the User appears as red text in List-User fields. The text is not red for User type fields. Not certain if this is related but the User does not receive notifications in the List-User field and does in the User type field.
Hi QuickBase Community,I'm trying to create a formula field that checks if any of several renewal dates (in various fields) are in the next month (from the current date). I want this formula to dynamically calculate the next month without hardcoding specific months.I have several date fields, including:TMB RenewalBLS RenewalACLS RenewalPALS RenewalI want the formula to check if any of these fields have a renewal date that falls in the next month. For example:If today is December, the formula should check for renewal dates in January.If today is August, it should check for renewal dates in September, and so on.I am not great at the code part of Quickbase and all my attempts so far have failed. Thank you for your help!
I have been quite vocal about the dismal state of Quickbase Mobile. QB has said they are commited to the new mobile forms (which I have had a preview and look quite cool), but they are a long way from being available (they claim not so long, but if anyone has been with QB long enough, we know it actually means years, and months of new bugs until they get it right). In the mean time, they have also been VERY vocal to me that they will, under no circustances, fix any bug on mobille. So we are stuck using a mobile system that seems to break more and more by the day. I wanted to list the biggest bugs I have found, so people don't waste their time trying to figure out what they are doing wrong. Please feel free to add to the list. You cannot remove the green plus mark on report links (unless you restrict permissions where the user cannot add to a table). So if you have any custom add button, the mobile user may easily circumvent that by hitting the green plus mark. On add record, tab
Forgive me if I missed something about this elsewhere, but for the life of me, i'm manually converting some forms and running into the issue with form/dynamic rules - the BLANK tests that used to work on old forms don't seem to be working in new forms. Now I have a work around to create a "dummy_null_field" for data types i need to test, using the null field in a "value in field" test, but that seems a bit over the top. Is there some way to test fields for NULL that works in New Forms rules creation? ------------------------------joe vandervest------------------------------
Hi, I have a table with physicians and the advanced privileges they may have. There are 9 advanced privileges (there could be a few more down the line), and each physician may have a unique combination of these privileges.I’m trying to decide whether to store each privilege in its own checkbox field or use a multi-select field where you can choose the privileges that apply.I like the multi-select approach because it’s more compact, but my concern is that I need to be able to select a single privilege from the list of 9 and see all the physicians who have that privilege. I'm not sure how to do that with a multi-select field.Can anyone advise on the best way to set this up?Thanks!
Hello, I'm trying to find a way to color the text that is in a multi line text field based on another field (Multiple choice). If ([Mulitple Choice]="No",[Multi Line],color yellow)Any suggestions would be greatly appreciated. Thank you
I might just not be seeing it, but is there a way to duplicate tables or save a template for a table? I need to make 51 tables that are all identical, except for the name and data that will be stored in it. I figured it would be easier to make one and then create duplicates than have to manually build all of them.
So my company is experimenting with switching from OneNote and Excel spreadsheets to QuickBase for tracking all of our data. So far, I am loving the potential this has to streamline our workflow! But I have hit a small snag in coming up with a solution that I was hoping the community could help out with. We have a huge list of contacts for each state, and depending on the "event" or job, we will need to contact certain people on that list and note who/when we contacted them. Previously this was accomplished on excel by just creating a few columns for "Contacted", "Status", etc. This got very messy on a sheet primarily just meant for contact info. So my question is this: If I have a table of these contacts in QB, can I somehow build something to duplicate that table of contact info, but also add some of those tracking metrics? I would love to attach it somehow to when I make a new "event" in that state, which I have a form for events as well. 
I hide many of my tables from most user roles. However, when I add a new table it defaults to be visible, and I have to manually go through each role and hide the table. Is it possible to default to hide, or to go to the table itself and choose that option?In the table settings, I know I can set access per role, but only permissions, I don't see user interface. Can the user interface per role be set from the table settings?------------------------------Mike Tamoush------------------------------
I want to allow my clients to create a Purchase order and then pick items from inventory to be line items of Purchase Order. The normal way to do this would be to display a report of available inventory on the Purchase Order record and then let the user pick which of the items he would like to be part of the purchase order. Is there an intuitive way to do this in Quick Base?
I have a table that holds shipment data, Ship to, Reference #, Due Date, Ship Date, and then a formula field that returns "Yes" if the the the Ship Date is less than or equal to the Due Date and "No" if not.I now want to show an over all Percentage of how often we are On Time. Any suggestions on how to set up a report that would portray this information? I was looking for a formula that would count how many records where the On Time field = Yes so that I could maybe summarize that. Any thought on how to set this up would be greatly appreciated.
I have the following formula that checks a date field to see if it is null: If(not IsNull([Coaching_Pipline_Date]), "You have been counseled prior to this conversation on", null)I would like to do this same thing, but change the field to be checked to a text field as when I try to change the field in the formula I get the error :How would I write this to check a text field type?Thanks Brian
Hello.I have been added as a user to QuickBase but I do not have anything showing up in my Company. "No Records Found" is all I see in every report: my company, my company contacts, my company contracts, my company pending bids. So pretty much I can login but I do not have access to anything.How can I view everything to import and export documents?Any help is greatly appreciated.
How can I link child table records to a parent table record in Quickbase using a pipeline? Each record in the parent table has multiple associated records in the child table. I want to automate this linking process within a Quickbase pipeline. Is this achievable, and if so, how?
Hello,I am trying to play around with the Outlook channel in Pipelines. I am creating a record in QB anytime an email is received in a particular folder. Everything seems to work great, I just can't seem to figure out how to rid the email body of the html tags?i put the email.body on to a rich text field. When the form is viewed on EDIT mode, the rich text field is showing without the tags, however, when it comes to viewing the form, the tags appear.this is what shows up:<html><head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="Generator" content="Microsoft Word 15 (filtered medium)"><style> <!-- @font-face {font-family:"Cambria Math"} @font-face {font-family:Calibri} p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; font-size:11.0pt; font-family:"Calibri",sans-serif} span.EmailStyle18 {font-family:"Calibri",sans-serif; color:windowtext} .MsoChpDefault {font-size:10.0pt} @page WordSection1 {margin:1.0in 1.0in 1.0in
I thought this would be relatively straightforward but I am running into multiple roadblocks. I have a table set up in a relationship with another table with a pipeline between the two, where the parent table has a list of all employees in the plant with a field for department they are in. The child field is set up to trigger a pipeline when the corresponding department is selected from a dropdown to check off that those employees were present that day in the other table. My question with this is I would like to display the people that will be checked off in the child table when that department is selected, so they can see who they will be marking as present that day without blindly telling them everyone is present. Is this possible? I played around with embedding reports (which doesn't show the entries until the form is saved, I would like it to appear while completing the form) and formulas that I couldn't get to work quite right. Any help would be greatly appreciated!
We have created a service account to manage pipelines (as suggested by QB), which seems to be good way to handle multiple developers working on our account. However, we have dozens of pipelines that I need to change ownership of in order to take advantage. I'm really hoping someone has a better solution than what QB is suggesting because this is wild for changing ownership of an existing pipeline.https://helpv2.quickbase.com/hc/en-us/articles/10943861915284-Transferring-ownership-of-a-pipeline
I am simply trying to add a report widget to the home page and it is not allowing me to select or even view any reports. There are well over 50 reports in the app, and I am an administrator with full access to all reports. Please see attached. Any help would be greatly appreciated!
Hello, I need help with writing a formula to add a day to a date formula.If([RX Trigger]<[RX Ready Date] add 1 day to the RX Trigger date to be the new RX Ready date.Ex: RX Trigger 10/30/2024 and RX Date 10/29/2024. Result needs to be RX Ready Date 10/31/2024.Thank youKathy Benjamin
Hello:Is there a way to get details about a specific record, such as who worked on the record, edits made, etc.?The Admin Console Audit Logs are not giving me what I need.Thank you,Roula
Hello all,I have an app with three tables:Faculty Records - Contains the various credentialing programs available for physicians.Physician Info - Stores static information like name, title, and person number.Physician Credentials - A join table that shows the relationship between physicians, credentials, and the dates those credentials were approved.The relationships between these tables are as follows:Here’s the issue I’m facing:One specific credentialing program from the Faculty Records table includes advanced privileges (checkboxes) unique to individual physicians. These privileges:Are only relevant to this one credentialing program.Differ from person to person.Ideally, should appear in the Physician Credentials table alongside the credentialing program, approval dates, and physician name.While I could add the advanced privileges to the Physician Info table, how could I then see them in the Physician Credentials table? Would queries be a solution for this? (I’ve never used thos
Hello Mobile Qrew! Thank you to all who were able to attend Wednesday’s Mobile Qrew Meet up. It’s our last Mobile Qrew Meet up of 2024. Here’s what we discussed: 1) We went over two mobile updates that were released in November. The first one was FastField's new integration with Quickbase allows customers to connect using a user token instead of full SSO, making it ideal for testing and users not ready for complete integration. Access is limited to specific tables, ensuring permissions are respected. Launched last Monday, the Enhanced FastField Integration enables users to create forms from Quickbase tables, automate dispatches through Pipelines, and sync data effortlessly between the two platforms.To learn more, check out November’s release notes. 2) Next, Chris Snow walked through where to access these new features mentioned above, and showcased the offline experience of how customers can collect da
Hello all, I have two tables:Physician Info: Contains columns for the physician's name, person number, and other static info about that physician.Credentialing: Contains the physician's name along with approval and renewal dates for various credentials.The reason I’m not combining everything into one table is that the Credentialing table is extensive, and I plan to add other tables in the future as well and if it is all in one table it becomes massive to edit.I know I need a Join Table to link these two tables. In the Join Table, I want to click on a physician's name and see all the information from both the Physician Info table (name, person number, and static info) and the Credentialing table (approval and renewal dates).I’ve watched the online many-to-many video multiple times and even have a simpler app that uses a many-to-many relationship, but I can’t seem to wrap my head around how to apply it to this project.How do I properly set up the Join Table to link these two tables,
I have have app that my team can monitor Quickbooks activity without letting the entire user team into our accounting.I have a connected table to Bill payments. When I try to set up a report link In by Bills table I have to mine a record in the Quickbooks table that has the Bill ref # and applied amount. Once Record looks like this:[(null,null,null,'978.00',{('162021','Bill',null)},null)]978 is the applied amount 162021 is the Quickbooks bill IDMultiple records look like this:[(null,null,null,'97199.28',{('163251','Bill',null)},null), (null,null,null,'37784.30',{('163351','Bill',null)},null), (null,null,null,'8100.00',{('163364','Bill',null)},null), (null,null,null,'12658.44',{('163352','Bill',null)},null), (null,null,null,'1092.00',{('163432','Bill',null)},null), (null,null,null,'1103.00',{('163433','Bill',null)},null), (null,null,null,'130.00',{('163439','Bill',null)},null)]How do I parse this into a Useable Form?I need [DATE],[Bill ID],[And Applied amount]. in a tabl
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.