Stonefield Query Videos

is_valid) { # Grab all the fields submitted from the form and store them in variables. $Company = $_POST['Company']; $Contact = $_POST['Contact']; $Email = $_POST['Email']; $Phone1 = $_POST['Phone1']; $Address1 = $_POST['Address1']; $Address2 = $_POST['Address2']; $City = $_POST['City']; $State = $_POST['State']; $Zip = $_POST['Zip']; # The following gets the current date and we use this to populate the createon date in GoldMine $da = getdate(); $datestamp = "$da[mon]/$da[mday]/$da[year]"; # Low level form validation, checks to make sure required fields are not empty. if (empty($Email) || empty($Contact)|| empty($Company)) { # If any of the forms are empty display the following error message. echo "

Fields marked with an * are required.

Please go back and fill in all required fields.
"; } # If all fields have been filled in lets generate the Email else{ # Assign the users submitted email address to the From header for the email $mailheaders = "From: $Email\n"; $to = "jay@1stdirect.com"; $subject = "Web Lead"; // GoldMine Web Import Email Instructions $form = "[Instructions]\n"; //Save's the webimport email in the history tab in GoldMine $form .= "SaveThis=Web Import File\n"; // Duplicate check on Email $form .= "DupCheck=Email\n"; $form .= "Password=fd1811\n"; // If No Duplicate found send GoldMine email to user BOB with Subject "New Contact" and Body $form .= "OnNewSendGMEmail1=BOB,New Stonefield Query Videos Request," .$Contact. " has contacted us.\n"; // If Duplicate found send GoldMine email to user BOB with Subject "New Contact" and Body $form .= "OnDupSendGMEmail1=BOB,Dup Stonefield Query Videos Request," .$Contact. " has contacted us.\n"; //$form .= "OnDupSendGMEmail2=BOB,Dup Contact,Existing Contact " .$Contact. " has contacted us.\n"; // Data section for WebImport Email $form .= "[Data]\n"; // Map the variables used to store the form fields to the GoldMine Contact1 and Contact2 fields on the left $form .= "CreateOn=".$datestamp."\n"; $form .= "Company=".$Company."\n"; $form .= "Contact=".$Contact."\n"; $form .= "Address1=".$Address1."\n"; $form .= "Address2=".$Address2."\n"; $form .= "City=".$City."\n"; $form .= "State=".$State."\n"; $form .= "Zip=".$Zip."\n"; $form .= "Email=".$Email."\n"; $form .= "Phone1=".$Phone1."\n"; $form .= "Source=FD Website\n"; $form .= "Key1=Prospect\n"; $form .= "Notes=".$Version."\n"; $form .= "Key5=SFQ Videos\n"; $form .= "Key5=New Web Lead - SFQ\n"; // ContSupp section of the GoldMine Web Import Email - WebSite, Additional Contacts and Details // $form .= "[ContSupp]\n"; // Each seperate ContSupp Record is sequential ie CS1_..., CS2_..., CS3_..., etc. etc. // Stores the Website variable to a detail called website //$form .= "cs1_ContSupRef=".$Website."\n"; //$form .= "cs1_Contact=Web Site\n"; //$form .= "cs1_RecType=P\n"; // Adds an additional Contact //$form .= "cs2_Contact=".$AdditionalContactName."\n"; //$form .= "cs2_Title="$AdditionalContact_Title."\n"; //$form .= "cs2_Address1="$AdditionalContact_Address1."\n"; //$form .= "cs2_Address2="$AdditionalContact_Address2."\n"; //$form .= "cs2_City="$AdditionalContact_City."\n"; //$form .= "cs2_State="$AdditionalContact_State."\n"; //$form .= "cs2_Zip="$AdditionalContact_Zip."\n"; //$form .= "cs2_Country="$AdditionalContact_Country."\n"; //$form .= "cs2_Phone="$AdditionalContact_Phone."\n"; //$form .= "cs2_Ext="$AdditionalContact_Ext."\n"; //$form .= "cs2_Fax="$AdditionalContact_Fax."\n"; //$form .= "cs2_Dear="$AdditionalContact_Dear."\n"; //$form .= "cs2_Notes="$AdditionalContact_Notes."\n"; //$form .= "cs2_RecType=C\n"; // Adds a Detail Record //$form .= "cs3_ContSupRef=".$Detail_Reference."\n"; //$form .= "cs3_Contact=".$Detail_Name."\n"; //$form .= "cs3_Title=".$Detail_Title."\n"; //$form .= "cs3_LinkAcct=".$Detail_LinkAcct."\n"; //$form .= "cs3_Country=".$Detail_Country."\n"; //$form .= "cs3_Zip=".$Detail_Zip."\n"; //$form .= "cs3_Ext=".$Detail_Ext."\n"; //$form .= "cs3_State=".$Detail_State."\n"; //$form .= "cs3_Address1="$.Detail_Address1."\n"; //$form .= "cs3_Address2=".$Detail_Address2."\n"; //$form .= "cs3_RecType=P\n"; //$form .= "cs4_ContSupRef="Product Interest\n"; //$form .= "cs4_Contact=".$Detail_Name."\n"; //$form .= "cs4_Title=".$Detail_Title."\n"; //$form .= "cs4_LinkAcct=".$Detail_LinkAcct."\n"; //$form .= "cs4_Country=".$Detail_Country."\n"; //$form .= "cs4_Zip=".$Detail_Zip."\n"; //$form .= "cs4_Ext=".$Detail_Ext."\n"; //$form .= "cs4_State=".$Detail_State."\n"; //$form .= "cs4_Address1="$.Detail_Address1."\n"; //$form .= "cs4_Address2=".$Detail_Address2."\n"; //$form .= "cs4_RecType=P\n"; if (mail("$to","$subject","$form","$mailheaders")){ // If the email was sent successfully display this message echo "Stonefield Query Product Videos

Online videos are a great alternative to webinars because you can watch them as many times as you wish whenever you want. We are currently developing videos on subjects such as creating reports, filtering, output options, etc.

Please select a Video Demonstration from the list below:

	Stonefield Query for AccountMate
	Stonefield Query for ACT!
	Stonefield Query for Goldmine
	Stonefield Query for HEAT
	Stonefield Query for QuoteWerks (under construction)
	Stonefield Query for SalesLogix
	Stonefield Query SDK (under construction)
	Stonefield Query for Timberline (under construction)
	Advanced Report Designer   - Adding fields to a report.

"; } else { // If the email was not sent successfully display this message echo "

ERROR: Your message could not be sent. Please try again or call our office directly."; } } } else { # set the error code so that we can display it. You could also use # die ("reCAPTCHA failed"), but using the error message is # more user friendly $error = $resp->error; } } ?> Register below to access the Stonefield Query product videos.

Fields marked with an * are required