Forum Widgets
Recent Discussions
Pipeline expression to concatenate and format date
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-2025 HBL-0000 is the b.report_asset_id 08-01-2025 should be the formatted a.new_charge_date Pipeline shows the following error: Validation error: Incorrect template "{{[b.report_asset_id + '-' + a.new_charge_date|date_mdy}}": unexpected '}', expected ']'Solved0likes5Comments
Refresh Code Page
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.Solved0likes9Comments
Automatically Update Date Field
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.Solved0likes3Comments
Custom Role Permissions Question
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!Solved0likes5Comments
Help/suggestions on simplifying a child table
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.Solved0likes2CommentsSearch for Records with no new entries?
I'm trying to determine the best way to analyze records in a single table and return a list of records that had an entry 07-01-2025 but DON'T have an entry for 08-01-2025. I tried a simple table report that had 2 conditions Rate Date is equal to 07-01-2025 and Rate Date is not equal to 08-01-2025, but that just gave me the list of records that did have an entry on 07-01-2025. I'm trying to see which records from 07-01-2025 do not have a record for 08-01-2025.Solved0likes12CommentsInvalid entry error when entering a negative number
I have a numeric-currency field that I am using to adjust a total field. If I edit the record to enter a negative number I get an error Invalid entry. But I can enter a positive number, save and reopen the record, edit the field to add a "-" then it works. So why won't it accept the "-" on the first attempt? Why must I enter the positive value, re-edit, add the "-" in order to make it work?Solved0likes1CommentUsing RegexReplace()
Does this function support capturing groups, and if yes, how does one access the captured data? Intent is to use a this function looking for punctuation from a text field, and then add a new line to this. regex: ([.!?])\s* substitution: $1\n Documentation doesn't state one way or the other. I've tried escaping the new line value without success. Perhaps I'm just missing something simple.Solved0likes4Comments
Removing Invalid Characters for File Name
Good Afternoon, I am trying to manipulate a simple text field to remove the following characters: \ / : * ? " < > | So that I can use it for file names. When I try SearchandReplace, it keeps throwing up syntax errors for these characters despite my double quotes around them. Is there a way to get these characters removed to prevent any file upload issues due to file name? Thank you for the help!Solved0likes2Comments
