Forum Discussion

JackWoods's avatar
JackWoods
Qrew Trainee
5 years ago

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
------------------------------
Formulas and functions
Tables and fields
    • JackWoods's avatar
      JackWoods
      Qrew Trainee
      5 years ago
      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
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        :) 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
        ------------------------------