Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Good afternoon everyone! I hope anyone located in the southeast is staying safe and sound following the impact of Helene and Milton. I'm writing today to update the Qrew on our event for October:We are not hosting the Women's Qrew meetup that is planned for 10/17. Instead, we are in the process of planning an exciting panel discussion around Building Your Personal Brand with some prominent female Quickbase leaders, targeting the morning of 10/30. Instead of hosting an internal-only discussion like we have in previous years, the WLG is delighted to extend invitations to this free, virtual panel discussion to members of the Women's Qrew!! :) Stay tuned for more details and the panel invite once we confirm final details, but as always, please feel free to reach out to me directly at tluccio@quickbase.com if you have any questions.
Hello Construction Qrew! Just a friendly reminder that the Construction Qrew is meeting up tomorrow 10/22 at 12pm EST to talk about what folks learned and had questions about from last week's Empower Pro and how that could impact your current workflow in the construction industry. Missed some Empower Pro sessions? Here's the link to watch Empower Pro on-demand Click here to register for tomorrow's meeting. Thanks and see you there!
QuickBaseHowever, the new gauge charts are NOT gauge charts and they don't show the categories like the current gauge charts show. There has to be an option to use "whichever" graphs desired (new and old) without forcing the user to pick from the old or the new.
Happy Post-Empower Pro Mobile Qrew! We hope everyone enjoyed last week's sessions. If you attended the Mobile Empower Pro session, and are ready to streamline your field and office workflows, the Mobile Product team is launching a special trial and discount you don't want to miss out on! If you attended the EmpowerPro session on "Bridging the gap: Seamless field and office integration with Quickbase and FastField", you qualify for a 30-day trialof FastField, one of the leading platforms for mobile data collection. Plus, after the trial, you’ll unlock 20%off on both annual and monthly contracts—with no minimum user requirement. This offer is only available until October 31, 2024, so take advantage while you can! For more information, be sure to check out the attached one-pager and FAQ document about this mobile discount below. Got more questions? Feel free to reach out to me or your account team and we can get you started.
I'm trying to customize a report where the results are based on teh current user and the locations in the current user's region. We have the following infrastructure already:table of employees > within the table of employees are the current user's and they do have a user account field that links them to their profile with a "user" type field although i'm not sure that is relevant for solving this. On each employee profile is their Location (Multiple Choice)On each manager's profile is a "Region" field (Multi-Select text field) inclusive of the same options in the location field- caveat being a manager can be responsible for multiple locations hence the region.Now- we're struggling with how to lookup the options in teh Region field to call up all teh records for the employees in their region. We also have a projects table where multiple manager resources are linked and based on the project those assigned managers on each employee record through a table to table relationship
I have a request to update choices in a multi-select field and delete or make it an option where certain user roles can't select an option in the field...I don't really want to delete the previous option and red line several records, is there anyway to have a user not be able to select certain options in a field?Or is there a better way to deal with making the data changes that displays the previous option as red?
Hi all,Is it possible to do joins (like SQL) with Pipelines? Can anyone point me to a training or discussion that fleshes this out? Thank you!
I have a table with a input form containing a embedded report. I tested a few yesterday and all worked just fine. In the midst of adding/updating a column at setting changed I can't wrap my head around. When I few a 'purchase order' - the associated embedded purchase order report defaults to a purchase order #1, not a corresponding one. For example if I view Purchase Order #19, it used to embed a report for PO 19, now it just shows blank. But if I goto Purchase order #1, it show the correct embedded report of PO#1.I attached some examples hoping it helps explain my situation, but I found a setting on the embedded reports where it has a filter, it's set to Purchase Order#1, but the options in the dropdown are just the current test POs that have been entered. I don't see a way to "auto associate" it based on what I am viewing so if I am viewing PO 19, embedded Purchase Order #19's details.
Hello, I am experiencing an issue in the Quick Base mobil app that differs from Quick Base within a browser.I have a Projects Table and a Tasks table.Within each Project record is a project schedule, which is a calendar report of all Tasks associated with the project. When I click a task on the calendar to edit, the Task opens (in the Task table.) When I save the edits, the Task saves and the Task page refreshes in "View" mode.I need the page to redirect back to the Project record.In a browser, the normal behavior is that the Task redirects back to the Project record when the task is saved, but on the mobile app the Task record refreshed in "View" mode.Is there a setting that would take care of this?Thanks!------------------------------Josh Collins------------------------------
Hi, I have a table and existing fields with data. I need to add few more fields in my existing QuickBase table . When I tried importing new fields and saw it imported in tables but with new records . But , I needed it to be based on existing unique fields, new fields should get imported. Later, I downloaded the data in excel and added new fields in it and tried but it did not work as expected. During import, Merge field by default shows record ID , but this is not changing as per unique records based on our table. Please help to get rid of this issue . Thanks, BR
Hello,This is a very general question, but I would like to integrate QuickBase with our maintenance program Upkeep. Specifically, I would like to create work order requests in QuickBase that can automatically create one in Upkeep. Is this possible? I do not have much experience with webhooks but would love to learn if this is even possible before I go down that path.Thank you, and any help would be greatly appreciated.
How can we suggest new groups? I'd love to see a Project Management group for PM professionals.Also, whatever happened to the Philly group? We met a few times, and then it blinked out of existence. I loved the group meet-ups! Can we re-boot it?
You may have missed my blog a ways back on The Discord Qrew...you can learn about ways people are helping each other out clicking the above link. If you're looking to engage in a real time chat experience, with other Quickbase professionals, the community-led Discord Qrew is a great spot to do this. Come connect with RossonLong1 and others as they tackle challenges in real time! Click here to access!
Hi Team, I am using an app where I have two forms. I want to switch from form a to b and b to a using button while staying on the same record. I tried creating field using formula URL but this is not working as expected. Any help would be appreciated. Thanks, BR
Hello all,I am working on building a formula that will extract everything left of the 3rd underscore from the right. Sample date: 139_EDWARDS_DR_NW_VIENNA_VA_20176Desired result: 139_EDWARDS_DR_NWI have tried variations of Part, Left, NotLeft, Right, NotRight, Find and just can't seem to figure it out. Anyone have a solution?
For almost 2 years we have been sending emails without a problem and are using the Outlook channel in Quickbase Pipelines for this purposes. Since last week we have started to experience issues receiving following errors:Remote API returned authentication error: (invalid_request) AADSTS900144: The request body must contain the following parameter: 'refresh_token'. Trace ID: 6f796e19-28f3-430c-8938-3a9274901800 Correlation ID: 3d7633a0-df23-404b-9b5a-d7df2400e3b6 Timestamp: 2024-09-30 18:38:43ZWe have not changed our Microsoft Azure AD account / application settings, this has just come out of nowhere. Using different email domains we experience the same issue. Is there anyone experiencing the same that can give us some guidance ? we have been looking to activate offline_access on the application in Azure AD, been review MFA settings, trying to use application passwords, etc. but to no good end result yet. And for almost a week now the Quickbase helpdesk is also not providing any active
I have two fields:CT APPROVED APPROVER ROLE = list of roles if they have approved a vacation requestCT REJECTED APPROVER ROLE = list if they rejected requestCurrently, those fields only have data added when a decision record is created and status is changed to either Approved or Rejected.I need to create a reminder email that sends after 2 days to those approver users that haven't approved or rejected a request (basically have request pending approval). Do I have to use a pipeline I previously created to automatically create decision records for each role to be able to create the email group for the reminder or can I do it without the pipeline? And how would I script the formula?Hope this makes sense.Kim
I am helping create a table for a 'materials requests'In this table, it references a master materials list that contains the types of materials a work-job may need (example: paint brushes, mixing cups, spray bottles, sharpies, gloves, painter's tape, etc.). It pulls in the material, cost , and allows the form to calculate a total ie: 3 paint brushes x $2= $6 in materials Some jobs may just need 1 material from this list, some may need multiple materials depending on scope. On my request table, I have the form with relationship functional where it pulls in the material, cost and does a calculation based on the user input on the qty and saves with no issues. However, we need it to function where if a request needs more items there can be a button/option to 'add more materials' and reveal another set of fields for more materials as they are added.Now once the record/form is saved, it saves the material as one line item or one individual record. Now since there is a job name fiel
Hello, Is there a way to consolidate multiple rows into one row? I have Table A right now. The Site ID column is the key column for the table since it’s a numeric field with unique values. I know about creating a relationship and then creating a summary field but I don't think it would work in this case because I want to use the Account ID column to summarize instead of the Site ID column.The only columns I'm interested in are the ones in the red square. Basically, I want to extract that data and consolidate it using the Account ID field and then have all the different Account codes related to the Account ID in one cell (like Table B). I don't mind if it has to be in a separate table. Is there a way to do this?Table ATable ATable BTable B
Hello and Happy Empower Pro day! For those with an Outlook Qrew invite on their calendar for today at 1 PM EST, please note that meeting series has expired, and the meetup is not happening today. We are targeting for the morning of 10/30 for October's meetup . See Tori's note below for more details.
Hi, I would like to create a search field inside a form using a text field. I found a video with the exact action that I want to do (https://www.youtube.com/watch?v=XgkfTpXTYBc). It's basically scanning a QR code and it will automatically get the exact data from another table. Could you please help me on this? Thank you so much in advance.
I have a pipeline I'd like to trigger based on conditions from multiple fields.These conditions work separately but I'm not able to get them to work together.I used the syntax provided on this page: Quickbase Help I need to use a query instead of the built in conditions because the first condition requires 2 date fields to match each other.{35.ex.'_fid_7'}AND{36.ex.'true'}------------------------------Anne Martin------------------------------
There are three relevant tables in this scenario, Projects, Groups, and a summary table called Project Groups. There is a one to many relationship from Projects and from Groups to the Project Groups table. This is to allow a project to be a member of multiple groups, and a group can contain multiple projects. I would like to show an embedded report in the projects form that shows all of the other projects (with some other relevant fields) that share a group with the project I am viewing, and I plan to group that report by Group. Is there a way to accomplish this?
I have a Text (reference proxy) field that displays the values of a table via a relationship. The table has two fields "Brand" and "Percent". I have successfully created the table relationship and the dropdown is showing the values as expected.The issue I am having is when I select a Brand name the Percent value goes away from the dropdown after selecting it. Is there a way to display both the "Brand" and the "Percent" after value selection?
Okay I have a user field a date field, time mobilized field, and a end time field. I need a message to pop up letting the user know if they put overlapping times in, that they need to adjust their times or have another user take care of the issue. How can I do this? Thank you all who take the time to help!
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.