Automation for a number of selections creates a change in a different field?

[Rachel Young]

I have one field for the number of volunteers the event can have (let's say 1-5). Another field for different groups that are going to attend (this is a multiple select field with the group names). Is there a way to have a "FULL" field that flips to full if the number in field 1 matches the number of groups selected in field 2? So for example we can have 3 volunteers, once 3 groups are selected the 3rd field would flip to FULL. 

Next level would be if it was less than 3 to have the field say SPACE AVAILABLE, and if over 3 were selected it would say OVER CAPACITY

[Mark Segall]

Hi @Rachel Young and welcome to the community!

Yes - You could use automation to accomplish this:

Note - For illustration purposes I'm calling the fields:

• Available (Numeric)
• Attending (Numeric)
• Capacity (Select Field with Full, Space Available, Over Capacity values)

• TRIGGER: Field Value Changed (ATTENDING)
• IF CONDITION (Advanced)
  • {{issue.ATTENDING}}
    LESS THAN
    {{issue.AVAILABLE}}
  • ACTION: Edit Issue (CAPACITY)
    • Space Available
• ELSE CONDITION (Advanced)
  • {{issue.ATTENDING}}
    EQUALS
    {{issue.AVAILABLE}}
  • ACTION: Edit Issue (CAPACITY)
    • Full
• ELSE
  • ACTION: Edit Issue (CAPACITY)
    • Over Capacity

[Rachel Young]

Hi @Mark Segall  

Thank you so much for your response! The only problem is that my "Attending" field is a multiple select field with group names. Is there a way to automatically push that info into a separate numeric field? 

[Mark Segall]

Ahh - Apologies I missed that.  You shouldn't need the extra field.  You could tweak the conditions like this:

• {{issue.ATTENDING.value.size}}