Getting Started

 View Only
  • 1.  Approval Formula Field

    Posted 11-24-2020 14:43
      |   view attached
    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
    ------------------------------


  • 2.  RE: Approval Formula Field

    Posted 11-24-2020 14:49
    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
    ------------------------------



  • 3.  RE: Approval Formula Field

    Posted 11-24-2020 14:55
      |   view attached
    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
    ------------------------------



  • 4.  RE: Approval Formula Field

    Posted 11-24-2020 17:15
    :) 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
    ------------------------------



  • 5.  RE: Approval Formula Field

    Posted 11-24-2020 17:24
    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
    ------------------------------



  • 6.  RE: Approval Formula Field

    Posted 11-24-2020 17:48
    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.com
    mark.shnier@gmail.com
    ------------------------------



  • 7.  RE: Approval Formula Field

    Posted 12-01-2020 13:20
      |   view attached
    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
    ------------------------------