How to decrease numbers in another form

This article will guide you on how to use a variable field in one form to decrease a number in another form. The example we will cover will include 2 forms, an Event Management Form – Admin Only and an Event Booking Form.

This is a variation to the existing Formidable Forms‘ Knowledge Base article Decrease an available count in another form.

Here’s the set-up:

Form 1: Event Management Form – Admin Only

This form is used for adding new events and contains the following fields (although you can add any fields you like):

  • Event Name
  • Event Date
  • Number of places available
  • Event Description

Form 2: Event Booking Form

In order to decrease a number in another form, you will need a second form.

This form is your event booking form and it uses a Dynamic Dropdown field to look at Form 1 > Event Date which will then display the dates available.

The form also uses a 2nd Dynamic List field to display the number of places still available and a hidden field to capture this number which can then be used elsewhere in the form to control conditional logic for your form elements if the number of places reaches the X limit.

Use the function below to make the number of seats decrease by a variable amount (instead of a fixed amount like the KB article shows):

add_action('frm_after_create_entry', 'after_entry_created', 30, 2);
function after_entry_created($entry_id, $form_id){
  if($form_id == 9){ //change 9 to the ID of your reservations form
    global $wpdb;
    $reward_ids = $_POST['item_meta'][95]; //change 95 to the ID of your Dynamic dropdown field in your reservations form
$booking_num = $_POST['item_meta'][96]; //change 96 to the ID of your booking places field in your reservations form
    $seat_count_field = 91; //change 91 to the ID of the available seats field in the event form
    foreach ( (array) $reward_ids as $reward_id ) {
        $available = FrmEntryMeta::get_entry_meta_by_field( $reward_id, $seat_count_field, $booking_num, true );
        $wpdb->update( $wpdb->prefix .'frm_item_metas', array( 'meta_value' => ( (int) $available-$booking_num ) ), array( 'item_id' => $reward_id, 'field_id' => $seat_count_field ) );
    }
  }
}

We’ve referenced various Fields in the snippet above. For more information, see below:
95 is the ID of the Dynamic Dropdown field in your booking form.
96 is the ID of the number of places that are being booked.
91 is the ID of the number of places in Form 1
9 is the ID of Form 2

And Thats It!

Check out the other demos and tutorials in our blog using the links below.

Let's Get Started

If you’re ready to get started with your next project click on the button below to try the Project Planner

TRY THE PROJECT PLANNER

You may also like…

Natural Language FormsDemosFormidable
10 Jan 2019

Natural Language Forms: Formidable Forms

We love natural language forms! Here you will find some examples that we've created using Formidable Forms. Have an idea…
Share a form entryFormidableTutorials
26 Mar 2019

Share a form entry between users

Share a form entry between multiple users: Formidable Forms There may come a point where multiple users may need to…
decrease number in another formFormidableTutorials
26 Mar 2019

Decrease a number in another form

How to decrease numbers in another form This article will guide you on how to use a variable field in…