Well 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.commark.shnier@gmail.com------------------------------
Original Message:
Sent: 11-24-2020 17:24
From: Jack Woods
Subject: Approval Formula Field
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
Original Message:
Sent: 11-24-2020 17:15
From: Mark Shnier (YQC)
Subject: Approval Formula Field
:) 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
Original Message:
Sent: 11-24-2020 14:55
From: Jack Woods
Subject: Approval Formula Field
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
Original Message:
Sent: 11-24-2020 14:48
From: Mark Shnier (YQC)
Subject: Approval Formula Field
What is the symptom of the problem?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
Original Message:
Sent: 11-24-2020 14:42
From: Jack Woods
Subject: 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 what I'm doing wrong please :)
how-to-keep-track-of-approvals-using-quickbase
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)
)
------------------------------
Jack Woods
------------------------------