Qrew Discussions

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.

I have a parent table called Deliverables that pulls in the Project Name into my child table called Buy Out.In Buy Out, each project has multiple Scopes.Each Scope can have many line items over time, with a Date field that’s filled in by the user.What I want:A Table Report that groups by Project Name → then by Scope.Under each Scope, I only want to display the most recent line item (based on the Date field).So if Project A has Scopes Electrical, Mechanical, and Plumbing, I’d only see the latest record for Electrical, the latest for Mechanical, and the latest for Plumbing.What’s happening now:If I create a Summary field for Maximum Date, it only gives me the most recent record for the whole Project, not per Scope.In a Summary Report, I can see the max dates by Scope, but I can’t get all the other line item details.In a Table Report, I can group and sort so the latest is on top, but I can’t filter it to only show that one row per Scope.What I’m asking:How can I build a Table Report that

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 am leaving Notion for QB. I created an exact copy of my Notion database (it was pretty simple) in QB and exported the Notion data into CSV. I started the import and in  the preview screen it looked perfect. But every time I hit "import" I get "Can not update built-in fields values." I can't find any simple solutions to this, just very complex instructions about API, which is a little beyond my skills! Does anyone know of a simple workaround? Thank you!

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

Issue with native Save and Keep Working button.I have a form, on which are several fields that a user completes, the results of which feed into several GetFieldValues fields. These retrieves prices from another table based on the selections made. That part works fine, but then there are some additional calculations made using that price and other fields on the form, but the price isn't "retrieved" until the record is saved. Thus, the need for the Save and Keep Working option. But that button doesn't behave in an expected way.So I'm struggling to determine the cause within my environment when using the native Save and Keep Working button. First: after the first time this button is selected, the Save and New option no longer appears. And Second: sometimes when using this option, and just Save, the form saves but a new empty form is presented.Is there a better/different way I could save and continue mid-form data entry, so that my price retrievals occur, but allow the user to still have t

Is anyone using an expense management for users in the field to them import into QuickBase? We track expenses (expense table) to our projects. We are looking at apps like Expensify, Concur, Navan (or similar app) to capture receipts and data (most have an smartscan feature). We are looking to see if any app has a better connection to export data to QuickBase/Pipeline rather then manually sending the data over.  

Hi all, hoping someone may be able to assist.Am using a pipeline to remove attachments using the format of 'fid_14=&delfile_fid_14=1'The result of this is that whilst the attachment looks to be removed from the form, it still is actually being stored (app file manager shows the attachments still exist).Has anyone else encountered this or possibly have a solution ?Cheers in advance.

I have created a table report by grouping the data based on a specific field. I would like to add totals and averages for a few of the columns in each group. How can I do that?

Hello Qrew!  Hope everyone had a solid weekend! Quick heads-up: there aren’t any virtual Qrew meetups on the calendar this week, but there’s still plenty happening across Quickbase if you’re looking to connect or pick up something new:  Sam’s Office HoursMonday–Friday, 1–2pm EDT No agenda, just bring what you’re working on and join the conversation.  FastField Office HoursMondays, Wednesdays, and Fridays, 2–3pm EDT Hop in for tips and best practices, or just to see what’s new in FastField.  Boston Qrew Meetup Wed August 20th, 4-6pm @MintzJoin the Boston area Qrew for an in-person event to  network and share use case tips.  Webinar: Feature Focus July & August ReleaseThurs Aug 21st, 1:00pm EDTJoin us as we review features that have come to Quickbase in July and August that you won't want to miss out on.  On your own time:  If you’re itching to learn something, check out the new Quikbase University experience. Lots of fresh cou

I would like to update my currently active notification’s permission type from Recipient to Open. Is there a way to do this without creating a new notification from scratch?Thanks in Advance!