Best practice for using @mention in a log rich text field.
Anybody have a best practice on using the 'Mention' feature in a log rich text field? My use case is: A rich text field w/ log edits turned on is used as a collaboration tool for team members to provide updates and ask each other questions. They mention each other in the comments and receive an email when they have been mentioned, via the handy 'send to users @mentioned' feature in the new notifications (see image below). However, when the 'Log edits' setting is turned on, Quickbase will email ALL the users who have ever been mentioned, when really we want just the person/people who were mentioned in the most recent comment. My workaround for this is to create a formula field to parse out the most recent comment and then a webhook or form rule to enter this value into another rich text field, with the @mention feature turned on. This last rich text field is used in the 'To' setting of the notification. This is a lot of work to simply use the mention feature! Is there a better way to do it that I'm missing?
Count days between 2 dates with a twist
I have a Start date and end date I am using the Weekdaysub(end date), (Start Date). but i want to add a IF statement like say to add saturdays to the mix. so if I was to set the date from 5/25/2025 and end on 5/30/2025 but if the saturdays check box was clicked it would also add the saturdays between those dates and return 6 (Monday-Saturday) and if the saturdays was not checked it would return 5 (Monday - Friday)
Provide Link to New Record on Predecessor Record
I've created a system where when a user clicks "Create New Agreement" URL button, a new record will be created that brings over key information, including the "predecessors" record ID so that the new record can capture that this previous agreement is a "predecessor". However, I'm trying to figure out a way on how to link the "predecessor" record to the newly created agreement as I want a user to actively see in the "predecessor" record that this work has already been completed. Any recommendations on how to do this? Thanks!Convert Email Lookup Key to Text
I feel like I'm going insane this should be extremely easy. I'm trying to make a formula email field that simply gets populated with 1 email field (primary contact) if that's in fact filled out. Otherwise, populate with the referring attorney email field value. Both are lookups from two different tables. The email field for the referring attorney lookup is the key field for that table. For some reason QB is expecting a textlist, not text. I've tried all sorts of type conversions, as well as part/split functions (since Split is what comes up under Textlist Functions, though the email field would never have more than a single value in the first place). I know this is going to be ridiculously simple in the end.RegEx replace
Hello, I'm trying to implement a regex replace to remove all special characters from a field. However, it's not working as expected. The result still shows certain special characters and line breaks. Here is an example. Could you provide the regex pattern you're using and the example text? This will help me understand the issue better and offer a more precise solution. RegexReplace([field_name],"[^A-Za-z0-9 ]", "") If you have any ideas on how I can refactor my formula, I'd love to hear them!
