Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

Waiting on

I have the following dependent checkboxes.  If the cost is at a certain break point then the checkboxes will be checked.  If the cost is over 5000 then the VP of quality, VP of finance, and one other VP must sign off. Therefore the "Additional Approvals Required" will be checked and they will pick which VP will sign off (VP of Sales, VP of engr, or VP of Ops)
If three signoffs are complete then the record can be closed.  
If the cost is over 25000 then the division manager must sign off.  

I want to create a field that shows what we are waiting on.  

App builders
Formulas and functions
Tips and tricks
  • EvanMartinez's avatar
    EvanMartinez
    Quickbase Staff
    8 years ago
    Hi Sarah,

    How do you indicate when that approval is received? Is there another checkbox field those VPs check when they give their approval?
    • ArchiveUser's avatar
      ArchiveUser
      Qrew Captain
      8 years ago
      Their approval will be the a pull down with Approved or Disapproved. 
    • EvanMartinez's avatar
      EvanMartinez
      Quickbase Staff
      8 years ago
      Hi Sarah,

      In that case you could make use of a formula text field and an If formula to check for what is checked and what is missing. For example:

      If([VP Of Quality Review Required]=True AND [VP of Quality Approval]="", "VP of Quality Review Required", "") & " " &
      [VP Of Finance Review Required]=True AND [VP of Finance Approval]="", "VP of Finance Review Required", "")

      This would check to confirm that the VP's approval is required and if that status field is blank (hasn't been denied or approved) then if it is is it would display the text message "VP of Quality Review Required". You would just need to add a line to the formula for each comparison and result. Connecting each one with & " " &. So in my Example if you required the VP of Quality and the VP of Finance and neither had responded that field would display:

      VP of Quality Review Required VP of Finance Review Required

      You could add more lines to fit the number of options available and adjust the style or message to fit your needs but this is the rough formula build for that sort of use case. 
    • ArchiveUser's avatar
      ArchiveUser
      Qrew Captain
      8 years ago
      The problem with this is there are many people that will be opening this to look at it.  Will this require them to approve before they close it?  I want to have a quick way to look at what are we waiting on.
  • EvanMartinez's avatar
    EvanMartinez
    Quickbase Staff
    8 years ago
    Hi Sarah,


    It most likely needs to be adjusted for your field names and types. When you at it doesn't like it what do you mean? You get an error message? You get no error but also get no results? Almost all formulas need slight adjustments to match the field types and syntaxes necessary. This was just a rough example of the structure and formatting. Is the VP of Quality fields for example a multiple choice text field?
    • ArchiveUser's avatar
      ArchiveUser
      Qrew Captain
      8 years ago
      VP of Quality Review required is a checkbox
      VP of Quality is an approval Multiple Choice with "Approved" and "Disapproved" option.  


      The error message is :"closing parenthesis missing
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      8 years ago
      try this

      List("\n",

      If([VP of Quality Review Required]=true and [VP of Quality]<>"Approved", "VP of Quality Review Required"),

      IF([VP of Finance Review Required]=true and [VP of Finance]<>"Approved", "VP of Finance Review Required"))
    • EvanMartinez's avatar
      EvanMartinez
      Quickbase Staff
      8 years ago
      Thanks Mark!

      I believe Mark's version should be a bit closer to what you need. When I gave it a quick glance it looks like an If was missing but using a List function should also give you a more consistent return.