kheatley
4 months agoQrew Member
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