Skip to main content

I want a field that tells me if a volunteer shift is full, using the Volunteers Needed number field and the Volunteers Assigned linked records field.

 

If I could write the code in plain English, something like:

IF number of records in Volunteers Assigned] is equal to or greater than {Volunteers Needed}, then display “YES”, IF lesser than, then display “NO”

 

Checkbox field checked/unchecked instead of “YES” or “NO” text would also be cool but not necessary.

 

I can figure out the IF part, but can I get the number of records in Volunteers Assigned] just in the code, or do I need a Count field to find that and then use that Count field in the formula?

You could probably build a formula that would do this by nesting functions within functions, but I would just go with using the count field for comparison.  


Hey ​@Tish_Chambers!

You’ll want to have a Count field for {Volunteers Assigned}, and a formula which will say:
 

If({Volunteers Assigned}>={Volunteers Needed}, “Yes”, “No”)


Feel free to reach out if you need help setting this up.

Mike, Consultant @ Automatic Nation


Reply