JackWoods
4 years agoQrew Trainee
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
------------------------------
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
------------------------------