How do I set dynamic values based on previous entries?

Question

I am working on a volunteer signup form where some of the fields have a limited number of slots available (for example Monday setup needs 15 people). I am good with the form in general but I need a way to determine how many slots are already filled so that the slot doesn't get overbooked. In the past I was able to do this using Freeform 3, but when the changed the structure in 4.x that option vanished. As such I bring my case to the community for guidance on the best way to accomplish this.

Thanks.

Answer 1

Couldn't you use freeform's form info tag pair to perform a conditional check? You could use that tag pair to lookup how many entries already exist in your collection, and then everything flows from there.

{exp:freeform:form_info form_name="your_form_name"}
    {if freeform:total_results < "15"}
       Thank you but this session is full
    {if:else}
        Insert your registration form here.
    {/if}
{/exp:freeform:form_info}

You could use a math plugin to do a little number manipulation too, if you needed to indicate in the page how many spots were left.

Answer 2

With some help from an associate we worked out the following solution using the query module.

{exp:query sql="SELECT COUNT( * ) AS itemCount FROM exp_freeform_form_entries_4 WHERE form_field_52 = 'yes'"}
                                {if 15 > {itemCount}}
              <td><label for="setup_1">Mon. Dec. 9, Setup/iron - 9am-noon: {exp:query sql="SELECT 15 - COUNT( * ) AS itemNeeded FROM exp_freeform_form_entries_4 WHERE form_field_52 = 'yes'"}{itemNeeded}{/exp:query} needed </label>
              <input type="checkbox" name="setup_1" id="setup_1" value="Yes" /></td>
                                {if:else}
                                    <td>Monday 9-noon is full</td>
                                {/if}
                            {/exp:query}