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

Question

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 · Answer

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

* {{issue.ATTENDING.value.size}}

Rachel Young_o1fi3i · Answer

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 · Answer

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