Formula Assistance
Can't get this to work: [Job - Project - GARAGE.NO SAND]=true and [Task]="SAND",([Job - Maximum FIELD BOARD COUNT.TO PAY]-24), [Job - Maximum FIELD BOARD COUNT.TO PAY], [Job - Project - GARAGE.NO PRIME PT/UP]=true and [Task]="PRIME P/U",([Job - Maximum FIELD BOARD COUNT.TO PAY]-24), [Job - Maximum FIELD BOARD COUNT.TO PAY], thank you
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 intoanother 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?
Creating formula to parse combined text field then create a userlist for notification email
Have an app where faculty submit leave requests. Then seven admins must approve request before it is ultimately approved. I created a pipeline that when a faculty member submits a leave request, new approver records are created for each admin role with a status of "Pending". Wondering if this is possible: I want to create a formula-url field in Leave Requests table that is a link to a "Pending" approver record, in Approver Decisions table, based on the related leave request and that the username is same as Approver username. I started this idea by finding this formula via a google search but I'm stumped as to how to move forward: URLRoot() & "db/" & [_DBID_APPROVERS] & "?a=er&rid=" & [Record ID#]. Any help would be appreciated. Kim
Gantt/Scheduler Plugin Settings
Good morning, Happy Thursday. The ask is to change the Quickbase Gantt Template App date format. The Gantt Template App can be found on the Exchange as a Quickbase alternative to Microsoft Project. The Quickbase Gantt Plugin has great out of the box functionality, but I can't figure out where to change the date format. If anyone has any experience using this Project Plan type plugin and has figured out how to change/customize settings (such as Date Formats) we would appreciate your insight. Thanks in advance,
Save and New Button creation
I am attempting to streamline (by removing manual actions) our part tracking process for newly machined parts and am looking for a way to add a "Save and New" button to the body of the form that preforms the same way as the built in Save and New button. Each part after machining is etched with a QR code that contains the relevant data for the part. Current setup below allows the user to click in the Part 3D Scan box, scan the QR code on the part at which time the data inputted and parsed into the correct boxes then it auto tabs to the Save and New button and pushes enter. My issue lies with the functionality of the button. Using the code I found in this forum I can "Save and Edit" however I can not figure out how to modify the code in order for it to open a new record for entry. var text url = URLRoot() & "db/" & Dbid() & "?a=er&rid=%%rid%%"; var text link = "<a href='" & $url & "' data-replaceRid='true' style='font-size: 11pt;margin-left: 5px; margin-top: 0px; height: 33px; width: 160px; text-align:center;background-color:#13294d;color:white;background-image: linear-gradient(to bottom, #13294d 0%, #13294d 100%);' class='SaveBeforeNavigating Vibrant'>Save and New</a>"; $link Any suggestions would be appreciated.
Extracting full name (with changes)
I've been able to successfully extract the surname of a user account using this formula: UserToName([Record Owner], "FF") The problem is that the user account was created as first name Richard and the contact record that corresponds to that user was set up as "Rick", so I'm not going to be able to make a match. My goal was to compare the record owner to a snapped value that occurs in a previous process, but when I tried changing the actual user account to Rick to circumvent the fact that the snapped field it is comparing to will not change, but apparently once the user name is set up it doesn't change. Is it possible that the user account will update after some period of time? if not, I'm open to other suggestions/ideas, and I thank you in advance for your input.
Extract Everything Left of 3rd Underscore from Right
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_20176 Desired result: 139_EDWARDS_DR_NW I have tried variations of Part, Left, NotLeft, Right, NotRight, Find and just can't seem to figure it out. Anyone have a solution?Is it possible to create email group based on formula field?
I have two fields: CT APPROVED APPROVER ROLE = list of roles if they have approved a vacation request CT REJECTED APPROVER ROLE = list if they rejected request Currently, 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
