Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
We have our windows ad users synced to quickbase via Azure AD/Entra ID and it is working fine but have run into our first snag which I haven't found anything directly addressing.We had a user change her name and we have updated it in on prem AD which synced to Azure AD. Everything appears to be working normally for a week except for quickbase. She went through the sign in process in quickbase which pushed her to the identity provider sign in, the Azure sign in window comes up and she signs in successfully with her new email address and password. But then in quickbase she has no access to anything. Looking into user management it appears that Quickbase has generated a new user with her new email address, it still says "External authentication ID: <her new email>" so I assume that it's imported through provider management as usual however it did not transfer her paid quickbase seat or any of her app access or groups.My read on this is that quickbase is using the primary e
Not sure where to submit this, but I noticed an error in the Quickbase docs for the Gantt plugin. At the bottom of this page it says:"Note: If you don't create the tables, the plugin creates them for you."Which is wrong and contradicts another page on the same topic:"Note: The Gantt plugin does not create tables."
If you recently started using the new Document Templates feature in Quickbase to generate pdf or Word documents, you may have noticed that checkbox fields on embedded table reports render as text strings "true" and "false", rather than the nicely formatted blue check mark symbol when viewing the table report natively in QB.You can overcome this by using a report formula in the table report to render the check mark as a Unicode character.If([Your Checkbox Field], "✓", "")orIf([Your Checkbox Field], "☑", "☐")
Hello! I'm new to Quickbase and have been using the API to speed up operations at my company. We have a report that is generated weekly whose records need to be sent to each user. Typically, this is done by manually clicking into each record, clicking the "Email" button, and sending the record to the related email address.Is there a way to do this process in bulk? Ideally, I would like to do one of two things:Create a button in Quickbase that sends all users their records at once. I've found this guide and this guide, but neither seems to be the functionality I'm looking for. I'd like something that does exactly the same thing as the "Email" button described above, but for all users in the report.Use the API to send all these emails. I don't think the API offers email functionality, but I could take all the emails from the report and use Python to email the records. This would also require some way to carry over the formatting from a Quickbase email, which we rely on for readability.Do
Hello,I was wondering is there a way in QuickBase to customize a role's permissions based on a specific user. For example, I have a role titled "Provider User". There are many users who are assigned to this role, but there is only one user (i.e., John Doe) who has this role but needs access to create new reports and such.Is it possible to customize a role settings based on specific users? Please let me know. Thanks in advance!
ATL Qrew kickoff on September 25th! See attached for details, we'll organize a few discussions here prior to the meetup!
Good afternoon! I can't seem to figure out a way to filter the record picker based off either a Report or a field not including something. For reference, I want to hide a contact from the record picker that is retired, but I don't want to out right delete their information as they are used in records over the years. I'm using a Table to Table relationship between two apps to connect these.
When you have a date column on a report, and select the filter icon, you are forced to enter a start and end date in order to filter that column. Is there any way you can force it to just accept a single date? I know I can set a report filter for an ask the user for that field, I'm seeking a way to disable the popup calendar that appears when just normal column filtering.
I feel like I am close, but still getting an error on my jinja expression.I need the pipeline to populate a text field based on the concatenation of 2 fields, 1 of which is a date field which needs to be formatted to text.{{[b.report_asset_id + '-' + a.new_charge_date|date_mdy}}Output should be HBL-0000-08-01-2025HBL-0000 is the b.report_asset_id08-01-2025 should be the formatted a.new_charge_datePipeline shows the following error:Validation error: Incorrect template "{{[b.report_asset_id + '-' + a.new_charge_date|date_mdy}}": unexpected '}', expected ']'
Good day everyone!I'm trying to set up a way to automate a page refresh. Previously we were using an HTML code page with<script> setTimeout(function(){ parent.location.reload(1); }, 60000);</script> This worked for a little bit, but stopped working some months ago. I added the code as a web page url as instructed in previous Qcrew discussions. However now it just states "We can't find what you were looking for. Either it has been deleted, or the link that brought you here is wrong."Has anyone found a work around for this? I'm trying to use it as a workflow solution that auto updates our main page that's a Kaban Report to display on a bigger screen for the work force.
Is there a way to add a "Invite New User" button to my dashboard?I want the same button in the picture attached, but I want it on my dashboard instead of on the "users" page. Thanks
I just spent several hours trying to come up with a creative solution to a problem. We want a record where the Date Modified is on or before a specific Date to have a different color, in this case grey.Easy we thought, this should work. - It doesn't. If(ToDate([Date Modified])=ToDate(6/22/21),"#666666","")Tried to add a formula check box field to get an idea what was happening.Check box field namd [Date Formula]:Part(ToText([Date Modified]),1, " ") this works when used in the color formula.Then in the Default report in the Color formula: - kinda seems to work but not really. If([Date Formula],"#666666","")Tried this one and no luckIf(Part(ToText([Date Modified]),1, " ") < "06-22-23","#666666","")I asked ChatGPT and this came out:If([Date Modified] <= ToTimestamp(Date(2021, 6, 23)),true,false)So I was trying my best to convert Date Modified to a Date and failing. Instead by converting the static date I wanted to use as my filter to a Timestamp everything fell into place.
I have a pipeline that successfully uploads a file to Sharepoint (i.e., create a new list item in Sharepoint).I also want to place data into a field/column of that same Sharepoint record, but am failing to make this happen. I've tried a couple different approaches without any success. Any tips on making this happen will be appreciated.I can provide more detailed screenshots if necessary but here are some to start.Thanks in advance.....AaronMethod 1: Method 2:When the error says at least 1 field must be set, and to specify the field to be updated, I can't see where to do that
I use QB to keep track of thousands of articles that I schedule for the e-newsletters my company sends out. Each article is a project. I am constantly updating these projects, like from "Assigned" to "Accepted" or from "Bob" is editing to "Mary" is editing. I have an "Updated" column but I have to change it myself.What I would like is an "update" column that changed the date automatically every time I make a change. That is, no matter which field I change for a project (the title, the author, the assignment date) the update column automatically updates.Is this possible? If so, how? Thanks in advance to any help.
I need to prompt the user for a beginning date and ending date range but I need those dates to be for more than one field.So the report would be something like this. The Beginning and Ending Date would be user prompts.Date received is on or after Beginning Date and Date received is on or before Ending Date orDate Submitted is on or after Beginning Date and Date Submitted is on or before Ending Date. How can I create the custom prompt for Beginning Date and Ending Date, so the user is not prompted to put in dates for both fields.Thanks
Hi allI'm using the Gantt plugin to manage task with short durations (hours). The Gantt plugin allows me to move e resize tasks so the start and end are given as dates and times.But the start and date fields on the Tasks table are Date fields, not DateTime fields.I need to get more detailed info from my tasks, but I don't know were the fractional start ad date info is stored.Lets suppose, for example, a task starting at a given date and time, and ending at a given date and time. If I move the task by a few hours, in a way that it stays on the same dates, and go to the currespondent record on the Tasks table, I see that the "Date modified" field does not change, meaning the record was not updated. If I move (or resize) the task so the start or end date change, the "Date modified" field gets updated.So, in summary, the question is: on which table is the fractional info (time) for tasks start and end is stored on my app?Thanks!Jose
I need to create a single-table custom email that runs on a schedule (any time during the month 4 months after a date in the record). Each email needs to go to a non-user whose email address is a field in the record, and the text of the email needs to contain some other fields from the record.I'm planning to do this in two steps:1. Create a custom email (open, triggered on a record modification)2. Create a pipeline to run once a month and do the record modification for the appropriate records - once the record is modified, the email will be sent.It seems like this will work but I'm wondering if the pipeline updates would be considered "bulk" updates. Since the recipients are non-users, the email must be specified as "open" - but I know there are issues with "open" emails with "bulk" updates - recipients could receive information that doesn't relate to them.If this could happen, what is another way to approach the requirement?
Is it possible to update a quickbase application via an email? I have a checkbox that needs to be checked and would like the user that gets the email to just open their email and click on the box. thank you
Hello,Full context: We have a staff table that all employees have access to, but only to view their own information. We also have a PTO table with a calendar report that the team has access to, but because the permissions for the Staff table is set to "when user is 'User'" they are unable to see any of the related names for the PTO records (PTO table is a child table of Staff table).Is there a way, or formula, to keep the same level of privacy on the Staff table whilst allowing the team to see just the related staff name for the PTO Records?Thanks!
Hi Community,In Quickbase, we can set up subscriptions to send reports via email on a regular schedule. Is there a similar way to automatically send reports to Microsoft Teams on a schedule using Pipelines?I know it’s possible to send notifications to a Teams chat, but I’m specifically looking for a way to send reports regularly.
Good afternoon,I've created a pipeline that searches Table A for criteria and if it matches it will copy a User List field from Table B to another User List field in Table A. Both User Lists fields could have multiple Users selected when the pipeline runs. My first attempt wiped out any information already listed in Table A's field with the information copied from Table B, but it listed all Users that were selected. When trying to figure out how to keep the information in Table A's field while adding the information from Table B, I then found the community thread which is similar to what I'm trying to do: https://community.quickbase.com/discussions/getting-started/using-multi-select-field-in-pipelines/18991 However, when I enter {{table B User List field}} ; {{table A User List Field}} Table A's information remains, but the new information copied are placeholders rather than the User name. So it looks like When I've
I'm working with a rich text button. The button is on a parent record. The user clicks the button, the parent is saved, and then a popup opens to add a child record. When I add the savebeforenavigating class, the button stops opening the window in a popup and instead opens in a new tab.Is it possible to include both classes in the same formula?var number rid = [Record ID#];var text url = URLRoot() & "db/" & [_DBID_CHILDREN] & "?a=nwr" & "&_fid_10=" & URLEncode($rid) & "&ifv=1" & "&hs=1";var text color = "#228B22";var text txtcolor = "White";"<a class='SaveBeforeNavigating' & \"OpenAsPopup\" data-height=\"800\" data-width=\"1000\" data-refresh=\"true\" " & "style=\"text-decoration: none; text-align: center; background:" & $color & "; color: " & $txtcolor & "; border-radius: 5px; margin: 2px; padding: 5px 5px; width: 100px; display: inline-block; font: 14px/ 'Calibri', 'Segoe UI', sans-serif; text-shadow: none;\
Have you ever wanted to be able to create a custom numbering sequence for records in your app (see [PO Number])? Common use cases where this comes up include creating purchase orders, invoices, tasks, budgets, etc. Quickbase has had a variety of complex and multi-step solutions to create these in the past (some combination of summary fields, lookup fields, snapshot fields, and Pipelines), but with formula queries, we are able to drastically simplify the process. In the article below we talk about how you can use formula queries to implement a system of your own. Use Case: Jesse is responsible for managing inventory for a wholesaler at one of their large warehouses. Jesse does a weekly audit of the on-hand quantity of the different items they sell, and she is responsible for placing purchase orders to restock. The company has a specific numbering process for their POs; each PO should be sequential based on the number of POs for that year for that vendor. For example, Jesse has already p
I'm looking for help/suggestions on simplifying a child table. The attachment is how it currently displays on the parent table. Is there a way to display the lines that are checked Task Completed in a second table below this one? I still want to be able see all the task lines though.
We get a lot of questions about surprising behavior when numbers have digits after the decimal point. Sometimes numbers don't look right, sometimes they don't seem to behave right mathematically. Often someone thinks they've found a bug, and it's difficult to explain how the behavior is normal and that nearly all computer software shares the same behavior. As a software QA guy with a mathematics background (see my introduction in the second paragraph of my first Quickbase community post), I find this kind of question particularly interesting. Let me explain a little bit about how computers represent numbers and do math. Then I'll show a few common questions that people ask and walk through explanations - and workarounds, where possible. A quick note: most of the examples discussed are around formulas. That is just because they are usually easier to illustrate with. The same caveats and information applies to any part of Quickbase where you are comparing numbers. This includes, but is n
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.