Approval Formula Field
Hey, I'm using the below article to set up a group approvals for my team. it all seems to work except for the formula field that kirk is talking about. Could you look at my formula and let me know ...
Forum Discussion
Hey - Thank you, Mark.
no error when I put in the formula. It's accepting the users into the formula on the front end. When I go to Approve the Approval Record with the Group Status field the user is not falling off the "Need Approval" list. See the screen grab attached. I should no longer be in the Need Approval field.
I need this user list field to be a list of user who have yet to mark it as approved based on the group status field.
------------------------------
Jack Woods
------------------------------
no error when I put in the formula. It's accepting the users into the formula on the front end. When I go to Approve the Approval Record with the Group Status field the user is not falling off the "Need Approval" list. See the screen grab attached. I should no longer be in the Need Approval field.
I need this user list field to be a list of user who have yet to mark it as approved based on the group status field.
------------------------------
Jack Woods
------------------------------
MarkShnier__You
Qrew Legend
Qrew Legend:) I believe that the problem is that there is a space missing in all your lines
where it has this
&"]Approved")),
it needs to be this
&"] Approved")),
ie a space before the A
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
where it has this
&"]Approved")),
it needs to be this
&"] Approved")),
ie a space before the A
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- You caught me - I actually tried to see if that would solve my problem. I still have the same issue - space or no space.
Still scratching my head here.
------------------------------
Jack Woods
------------------------------- MarkShnier__YouWell now i know how to do that technique. hank you.
This worked for me when I put in the missing space.
ToUserList(
If(not(Contains([Group Status], (Part(UserListToNames([Approvers]),1,";"))&"] Approved")), ToUser(Part(UserListToEmails([Approvers]),1,";")),null),
If(not(Contains([Group Status], (Part(UserListToNames([Approvers]),2,";"))&"] Approved")), ToUser(Part(UserListToEmails([Approvers]),2,";")),null),
If(not(Contains([Group Status], (Part(UserListToNames([Approvers]),3,";"))&"] Approved")), ToUser(Part(UserListToEmails([Approvers]),3,";")),null),
If(not(Contains([Group Status], (Part(UserListToNames([Approvers]),4,";"))&"] Approved")), ToUser(Part(UserListToEmails([Approvers]),4,";")),null),
If(not(Contains([Group Status], (Part(UserListToNames([Approvers]),5,";"))&"] Approved")), ToUser(Part(UserListToEmails([Approvers]),5,";")),null),
If(not(Contains([Group Status], (Part(UserListToNames([Approvers]),6,";"))&"] Approved")), ToUser(Part(UserListToEmails([Approvers]),6,";")),null),
If(not(Contains([Group Status], (Part(UserListToNames([Approvers]),7,";"))&"] Approved")), ToUser(Part(UserListToEmails([Approvers]),7,";")),null),
If(not(Contains([Group Status], (Part(UserListToNames([Approvers]),8,";"))&"] Approved")), ToUser(Part(UserListToEmails([Approvers]),8,";")),null),
If(not(Contains([Group Status], (Part(UserListToNames([Approvers]),9,";"))&"] Approved")), ToUser(Part(UserListToEmails([Approvers]),9,";")),null),
If(not(Contains([Group Status], (Part(UserListToNames([Approvers]),10,";"))&"] Approved")), ToUser(Part(UserListToEmails([Approvers]),10,";")),null)
)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- I figured it out. The Status field needs to Log the entry on the same line. In the Status field properties you will find this setting under Log Entries. "Show the name and date on the same line as the entry"
have a good one!
------------------------------
Jack Woods
------------------------------
