Combining fields

I need to store a date and time as a single field in this format:

2010-09-11 08:00:00

Is there a way to collect this data using Gravity Forms' date and time fields and then concatenate them into one field? I see from this forum's "Localization of the Date Picker and Date Format" thread that changing the date slashes to dashes is a different issue, so please consider the "combining fields" aspect of this request.

-Ken

Thanks, Carl! The form is here:

http://www.challengeblog.org/submit/

I'm trying to store the data in the format expected by this plugin:

http://wordpress.org/extend/plugins/the-events-calendar/

That plugin has fields for both "startdate' and "enddate". I'm choosing to ask my users for only one date. Is there a way to store that data in two different custom fields?

Carl,

Yup! I'm having no problem using Gravity Forms to collect and store all the other fields (great how your plugin is so versatile!). Here's everything The Events Calendar uses:

_isEvent
_EventStartDate
_EventEndDate
_EventVenue
_EventCountry
_EventAddress
_EventCity
_EventState
_EventProvince
_EventZip
_EventCost
_EventPhone

Elsewhere, someone else has asked the author of TEC to make his plugin Gravity Forms-friendly.

Unsurprisingly, I too am curious to see this code. :-)

Him Tim, were you able to refine the code to add the correct custom field? I'm trying to use gravity forms with the Event Calendar plugin and facing the same "crisis" :)

You help is appreciated.

Using the update_post_meta WordPress function, you'll want to add a line that is something like this:

add_action("gform_post_submission_5", "add_EventStartDate", 10, 2);
function add_EventStartDate($entry, $form) {
    update_post_meta($entry['post_id'], "_EventStartDate", "your value");
}

On this line:

update_post_meta($entry['post_id'], "_EventStartDate", "$formatted_date");

...remove the quotes around the $formatted_date variable. Let me know if that does the trick.

I've checked the result getting through to the database..

::00

Not sure if that represents a failed submission or not :(

With the new version of Gravity Forms you can now name fields which makes this hack much easier. However I'm running into an issue where the Start and End dates are not being passed to the Events UNLESS an editor goes in an manually unchecks the "All day event?" box and then publishes the post. Otherwise the date data is lost and it defaults to 1970. Any ideas how to fix this? I'm using this code in my functions file:

add_action("gform_pre_submission", "format_event_date");
function format_event_date($form){

    //replace 1 with your actual form id
    if($form["id"] != 4)
        return;

    //replace 4 with your actual date field ID
    $date = $_POST["eventday"];

    //replace with your actual time field ID
    $time = $_POST["starttime"];
    $timeend = $_POST["endtime"];

    $hour = str_pad($time[0], 2, "0", STR_PAD_LEFT); //making sure hour has 2 digits
    $minute = str_pad($time[1], 2, "0", STR_PAD_LEFT); //making sure minutes has 2 digits

    $hourend = str_pad($timeend[0], 2, "0", STR_PAD_LEFT); //making sure hour has 2 digits
    $minuteend = str_pad($timeend[1], 2, "0", STR_PAD_LEFT); //making sure minutes has 2 digits

    //formatting date
    $raw_date = "{$date} {$hour}:{$minute}{$time[2]}";
    $formatted_date = gmdate("Y-m-d H:i:s", strtotime($raw_date));

    $raw_dateend = "{$date} {$hourend}:{$minuteend}{$timeend[2]}";
    $formatted_dateend = gmdate("Y-m-d H:i:s", strtotime($raw_dateend));

    //replace with the IDs of the hidden fields that will hold the formatted dates
    $_POST["eventstartdate"] = $formatted_date;
    $_POST["eventenddate"] = $formatted_dateend;

 }

I've got this code to work for Gravity Forms v1.3 and The Events Calendar. At the end I've also got a snippet to format the post_name from the post_title for the pretty URL. Also, my date and times are both in an array because i'm using the Date Field rather than the Date Picker in Gravity Forms.

//GravityForms Modifications
//change post type for Events to sp_events for Event Posting form
add_filter("gform_post_data", "change_post_type", 10, 2);
function change_post_type($post_data, $form){

    if($form["id"] == '5'){
        $post_data["post_type"] = "sp_events";
    }
    return $post_data;
}

//convert date and time to Events Calendar style for Event Posting form
add_action("gform_pre_submission", "format_event_date");
function format_event_date($form){

    //replace 5 with your actual form id
    if($form["id"] != 5)
    	return;

    //replace input_5 and input_6 with your actual date field IDs
    $startDate = $_POST["input_5"];
    $endDate = $_POST["input_6"];

    //replace input_23 and input_24 with your actual time field IDs
    $startTime = $_POST["input_23"];
    $endTime = $_POST["input_24"];

    $eventStartDate = $startDate[2] . "-" . $startDate[0] . "-" . $startDate[1] . " " . $startTime[0] . ":" . $startTime[1].$startTime[2];

    $eventEndDate = $endDate[2] . "-" . $endDate[0] . "-" . $endDate[1] . " " . $endTime[0] . ":" . $endTime[1].$endTime[2];

    $eventStartDate = strtotime($eventStartDate);
    $eventEndDate = strtotime($eventEndDate);

    //formatting date
    $formatted_start_date = strftime("%Y-%m-%d %H:%M:%S", $eventStartDate);
    $formatted_end_date = strftime("%Y-%m-%d %H:%M:%S", $eventEndDate);

    //replace with the IDs of the hidden fields that will hold the formatted dates
    $_POST["input_5"] = $formatted_start_date;
    $_POST["input_6"] = $formatted_end_date;
}

add_action("gform_post_submission", "add_EventDatesAndTimes", 10, 2);
function add_EventDatesAndTimes($entry, $form) {
    update_post_meta($entry['post_id'], "_EventStartDate", $_POST["input_5"]);
    update_post_meta($entry['post_id'], "_EventEndDate", $_POST["input_6"]);
}

add_action("gform_pre_submission", "create_friendly_url");
function create_friendly_url()
{
	 $phrase = $_POST['title'];
	 $maxLength = 200;
    $result = strtolower($phrase);

    $result = preg_replace("/[^a-z0-9\s-]/", "", $result);
    $result = trim(preg_replace("/[\s-]+/", " ", $result));
    $result = trim(substr($result, 0, $maxLength));
    $result = preg_replace("/\s/", "-", $result);

    $_POST["postname"] = $formatted_dateend;
}

Hello,

I am interested in using the date picker as well. Thank you.

Hi everyone,

I am trying to create a form to submit to a custom post type that has The Events Calendar metabox. I am able to get all of the variables into the post except the date and time. I am using a variation of alex's code which I have put in my theme's functions.php file.

The form I am using has custom post fields of date and time type for the start and end dates and times respectively. The form also has two custom post fields of type hidden. I will work to get the form online so it can be inspected. Currently I am editing locally and using GF 1.5.

Many thanks for your help the help of all those who attacked this problem before me!

Benjamin

http://pastebin.com/embed_js.php?i=wVwkeQjk

hi benjamin, could you please explain how you managene to get this working properly?

thanks,

Luc