-- phpMyAdmin SQL Dump -- version 5.1.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Feb 22, 2022 at 06:16 AM -- Server version: 10.1.37-MariaDB -- PHP Version: 7.3.1 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `multiforms` -- -- -------------------------------------------------------- -- -- Table structure for table `forms` -- CREATE TABLE `forms` ( `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci, `schema` longtext COLLATE utf8mb4_unicode_ci, `mailchimp_details` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Details for mailchimp', `is_template` tinyint(1) NOT NULL DEFAULT '0', `is_global_template` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) UNSIGNED NOT NULL, `submission_count` int(11) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `forms` -- INSERT INTO `forms` (`id`, `name`, `slug`, `description`, `schema`, `mailchimp_details`, `is_template`, `is_global_template`, `created_by`, `submission_count`, `created_at`, `updated_at`) VALUES ('0dbdb1e7-53d1-4905-9197-bc97fbcbb5eq', 'Counseling registration form', 'counseling-registration-form-9ys', 'Counseling registration form', '{\"form\":[{\"id\":5,\"name\":\"field_6\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"h1\",\"text_color\":\"#ee301d\",\"content\":\"Counseling registration form\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[]},{\"id\":6,\"name\":\"field_7\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"p\",\"text_color\":\"#343637\",\"content\":\"Provide your details below to attend Counseling.\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[]},{\"id\":0,\"name\":\"field_1\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Name\",\"help_text\":null,\"prefix_icon\":\"fa-user\",\"suffix_icon\":\"none\",\"placeholder\":\"Enter your name\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-6\",\"custom_attributes\":[]},{\"id\":1,\"name\":\"field_2\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"email\",\"label\":\"Email\",\"help_text\":null,\"prefix_icon\":\"fa-envelope\",\"suffix_icon\":\"none\",\"placeholder\":\"Email to contact you\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[{\"rule\":\"email\",\"error_msg\":\"Please provide a valid email\"}],\"conditional_class\":null,\"col\":\"col-md-6\",\"custom_attributes\":[]},{\"id\":13,\"name\":\"field_14\",\"extras\":{\"showConfigurator\":false},\"type\":\"range\",\"label\":\"Age\",\"help_text\":null,\"min\":\"20\",\"max\":\"60\",\"step\":\"1\",\"data_orientation\":\"horizontal\",\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[],\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[]},{\"id\":14,\"name\":\"field_15\",\"extras\":{\"showConfigurator\":false},\"type\":\"text_editor\",\"label\":\"Tell us something about youself\",\"placeholder\":\"Jot Down Here\",\"help_text\":null,\"editor_height\":150,\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[],\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[]},{\"id\":15,\"name\":\"field_16\",\"extras\":{\"showConfigurator\":false},\"type\":\"radio\",\"label\":\"which counseling session do you want?\",\"help_text\":null,\"options\":\"Career\\nHealth\\nFinancial Goal\",\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[],\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[]},{\"id\":17,\"name\":\"field_18\",\"extras\":{\"showConfigurator\":false},\"type\":\"switch\",\"label\":\"Should we contact you via phone?\",\"conditional_class\":null,\"help_text\":null,\"size\":\"switch\",\"col\":\"col-md-12\",\"custom_attributes\":[],\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[]},{\"id\":3,\"name\":\"field_4\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Phone No.\",\"help_text\":null,\"prefix_icon\":\"fa-phone\",\"suffix_icon\":\"none\",\"placeholder\":\"Phone number to contact you\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-6\",\"custom_attributes\":[]},{\"id\":12,\"name\":\"field_13\",\"extras\":{\"showConfigurator\":false},\"type\":\"calendar\",\"label\":\"Good time to contact you\",\"help_text\":null,\"size\":null,\"prefix_icon\":\"fa-clock\",\"suffix_icon\":\"none\",\"custom_class\":null,\"start_date\":\"none\",\"end_date\":\"none\",\"format\":null,\"disabled_days\":[],\"enable_time_picker\":true,\"time_format\":\"12\",\"time_picker_inline\":false,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-6\",\"custom_attributes\":[]}],\"emailConfig\":{\"email\":{\"from\":\"admin@admin.com\",\"to\":\"admin@admin.com\",\"cc\":null,\"bcc\":null,\"subject\":\"New Customer details: __field_1__\",\"body\":\"New Feedback:\\n\\nName: __field_1__\\nEmail: __field_2__\\nOffice address: __field_8__\\nHome address: __field_12__\\nContact time: __field_13__\"},\"auto_response\":{\"from\":null,\"to\":null,\"subject\":null,\"body\":null,\"is_enable\":false},\"smtp\":{\"host\":null,\"port\":null,\"from_address\":null,\"from_name\":null,\"encryption\":null,\"username\":null,\"password\":null,\"use_system_smtp\":1}},\"settings\":{\"recaptcha\":{\"is_enable\":0,\"site_key\":null,\"secret_key\":null},\"color\":{\"label\":\"#000000\",\"error_msg\":\"#a94442\",\"required_asterisk_color\":\"#a94442\",\"background\":\"#ffffff\",\"image_path\":null},\"notification\":{\"post_submit_action\":\"same_page\",\"failed_msg\":\"Something went wrong, please try again.\",\"success_msg\":\"Email sent successfully.\",\"redirect_url\":null,\"position\":\"toast-bottom-center\"},\"submit\":{\"text\":\"Submit\",\"loading_text\":\"Submitting...\",\"btn_alignment\":\"float-right\",\"btn_size\":null,\"btn_color\":\"btn-primary\",\"btn_style\":\"default\",\"btn_icon\":\"none\",\"icon_position\":\"left\"},\"form_data\":{\"col_visible\":[\"field_1\",\"field_2\",\"field_14\",\"field_15\",\"field_16\",\"field_18\",\"field_13\"],\"btn_enabled\":[\"view\",\"delete\"]},\"background\":{\"bg_type\":\"bg_color\"},\"form_scheduling\":{\"closed_msg\":\"The form has been closed now!\",\"start_date_time\":null,\"end_date_time\":null,\"is_enabled\":false},\"form_submision_ref\":{\"is_enabled\":false,\"prefix\":null,\"suffix\":null,\"start_no\":\"1\",\"min_digit\":\"4\"},\"theme\":\"cosmo\",\"is_enabled_draft_submit\":0},\"additional_js_css\":{\"js\":null,\"css\":null},\"conditional_fields\":[{\"action\":\"show\",\"element\":\"field_4\",\"conditions\":[{\"condition\":\"field_18\",\"value\":\"1\",\"element_type\":\"switch\",\"element_index\":7,\"operator\":\"==\"}]},{\"action\":\"show\",\"element\":\"field_13\",\"conditions\":[{\"condition\":\"field_18\",\"value\":\"1\",\"element_type\":\"switch\",\"element_index\":7,\"operator\":\"==\"}]}],\"form_attributes\":[]}', '{\"is_enable\":false,\"api_key\":null,\"list_id\":null,\"email_field\":null,\"name_field\":null}', 0, 0, 1, 0, '2020-07-28 13:32:42', '2020-07-29 10:13:41'), ('0dbdb1e7-53d1-4905-ddwd-bc97fbcbb554', 'Counseling registration form', 'counseling-registration-form-9ys', 'Counseling registration form', '{\"form\":[{\"id\":5,\"name\":\"field_6\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"h1\",\"text_color\":\"#ee301d\",\"content\":\"Counseling registration form\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[]},{\"id\":6,\"name\":\"field_7\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"p\",\"text_color\":\"#343637\",\"content\":\"Provide your details below to attend Counseling.\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[]},{\"id\":0,\"name\":\"field_1\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Name\",\"help_text\":null,\"prefix_icon\":\"fa-user\",\"suffix_icon\":\"none\",\"placeholder\":\"Enter your name\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-4\",\"custom_attributes\":[]},{\"id\":1,\"name\":\"field_2\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"email\",\"label\":\"Email\",\"help_text\":null,\"prefix_icon\":\"fa-envelope\",\"suffix_icon\":\"none\",\"placeholder\":\"Email to contact you\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[{\"rule\":\"email\",\"error_msg\":\"Please provide a valid email\"}],\"conditional_class\":null,\"col\":\"col-md-4\",\"custom_attributes\":[]},{\"id\":3,\"name\":\"field_4\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Phone No.\",\"help_text\":null,\"prefix_icon\":\"fa-phone\",\"suffix_icon\":\"none\",\"placeholder\":\"Phone number to contact you\",\"size\":null,\"custom_class\":null,\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-4\",\"custom_attributes\":[]},{\"id\":13,\"name\":\"field_14\",\"extras\":{\"showConfigurator\":false},\"type\":\"range\",\"label\":\"Age\",\"help_text\":null,\"min\":\"20\",\"max\":\"60\",\"step\":\"1\",\"data_orientation\":\"horizontal\",\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[],\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[]},{\"id\":14,\"name\":\"field_15\",\"extras\":{\"showConfigurator\":false},\"type\":\"text_editor\",\"label\":\"Tell us something abot you\",\"placeholder\":\"Jot Down Here\",\"help_text\":null,\"editor_height\":150,\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[],\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[]},{\"id\":15,\"name\":\"field_16\",\"extras\":{\"showConfigurator\":false},\"type\":\"radio\",\"label\":\"which counseling session do you want?\",\"help_text\":null,\"options\":\"Career\\nHealth\\nFinancial Goal\",\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[],\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[]},{\"id\":12,\"name\":\"field_13\",\"extras\":{\"showConfigurator\":false},\"type\":\"calendar\",\"label\":\"Good time to contact you\",\"help_text\":null,\"size\":null,\"prefix_icon\":\"fa-clock\",\"suffix_icon\":\"none\",\"custom_class\":null,\"start_date\":\"none\",\"end_date\":\"none\",\"format\":null,\"disabled_days\":[],\"enable_time_picker\":true,\"time_format\":\"12\",\"time_picker_inline\":false,\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[]}],\"emailConfig\":{\"email\":{\"from\":\"admin@admin.com\",\"to\":\"admin@admin.com\",\"cc\":null,\"bcc\":null,\"subject\":\"New Customer details: __field_1__\",\"body\":\"New Feedback:\\n\\nName: __field_1__\\nEmail: __field_2__\\nOffice address: __field_8__\\nHome address: __field_12__\\nContact time: __field_13__\"},\"auto_response\":{\"from\":null,\"to\":null,\"subject\":null,\"body\":null,\"is_enable\":false},\"smtp\":{\"host\":null,\"port\":null,\"from_address\":null,\"from_name\":null,\"encryption\":null,\"username\":null,\"password\":null,\"use_system_smtp\":1}},\"settings\":{\"recaptcha\":{\"is_enable\":0,\"site_key\":null,\"secret_key\":null},\"color\":{\"label\":\"#000000\",\"error_msg\":\"#a94442\",\"required_asterisk_color\":\"#a94442\",\"background\":\"#ffffff\",\"image_path\":null},\"notification\":{\"post_submit_action\":\"same_page\",\"failed_msg\":\"Something went wrong, please try again.\",\"success_msg\":\"Email sent successfully.\",\"redirect_url\":null,\"position\":\"toast-top-right\"},\"submit\":{\"text\":\"Submit\",\"loading_text\":\"Submitting...\",\"btn_alignment\":\"float-right\",\"btn_size\":null,\"btn_color\":\"btn-primary\",\"btn_style\":\"default\",\"btn_icon\":\"none\",\"icon_position\":\"left\"},\"form_data\":{\"col_visible\":[\"field_1\",\"field_2\",\"field_14\",\"field_13\",\"field_15\",\"field_16\"],\"btn_enabled\":[\"view\",\"delete\"]},\"background\":{\"bg_type\":\"bg_color\"},\"form_scheduling\":{\"closed_msg\":\"The form has been closed now!\",\"start_date_time\":null,\"end_date_time\":null,\"is_enabled\":false},\"form_submision_ref\":{\"is_enabled\":false,\"prefix\":null,\"suffix\":null,\"start_no\":\"1\",\"min_digit\":\"4\"},\"theme\":\"cosmo\",\"is_enabled_draft_submit\":0},\"additional_js_css\":{\"js\":null,\"css\":null},\"conditional_fields\":[{\"action\":null,\"element\":null,\"conditions\":[{\"condition\":null,\"value\":null,\"element_type\":\"text\",\"element_index\":null,\"operator\":\"==\"}]}],\"form_attributes\":[]}', '{\"is_enable\":false,\"api_key\":null,\"list_id\":null,\"email_field\":null,\"name_field\":null}', 1, 0, 1, 0, '2020-07-28 13:32:42', '2020-07-28 13:32:42'), ('254525ab-e3b4-45f0-1213-24cf89fed1ee', 'Appointment request', 'appointment-request-omp', 'Appointment request for any service', '{\"form\":[{\"id\":5,\"name\":\"field_6\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"h1\",\"text_color\":\"#ee301d\",\"content\":\"Appointment Request\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":6,\"name\":\"field_7\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"p\",\"text_color\":\"#515658\",\"content\":\"Let us know how we can help transform your landscape!\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[]},{\"id\":0,\"name\":\"field_1\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Name\",\"help_text\":null,\"prefix_icon\":\"fa-user\",\"suffix_icon\":\"none\",\"placeholder\":\"Enter your name\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-4\",\"custom_attributes\":[]},{\"id\":3,\"name\":\"field_4\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Phone No.\",\"help_text\":null,\"prefix_icon\":\"fa-phone\",\"suffix_icon\":\"none\",\"placeholder\":\"Phone number to contact you\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-4\",\"custom_attributes\":[]},{\"id\":1,\"name\":\"field_2\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"email\",\"label\":\"Email\",\"help_text\":null,\"prefix_icon\":\"fa-envelope\",\"suffix_icon\":\"none\",\"placeholder\":\"Email to contact you\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[{\"rule\":\"email\",\"error_msg\":\"Please provide a valid email\"}],\"conditional_class\":null,\"col\":\"col-md-4\",\"custom_attributes\":[]},{\"id\":7,\"name\":\"field_8\",\"extras\":{\"showConfigurator\":false},\"type\":\"textarea\",\"label\":\"Address\",\"help_text\":null,\"prefix_icon\":\"fa-map-marker\",\"suffix_icon\":\"none\",\"rows\":3,\"columns\":null,\"placeholder\":\"Provide street, landmark, city, state, postal code, country\",\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":8,\"name\":\"field_9\",\"extras\":{\"showConfigurator\":false},\"type\":\"checkbox\",\"label\":\"What days work best for you?\",\"help_text\":null,\"options\":\"Monday\\nTuesday\\nWednesday\\nThursday\\nFriday\\nSaturday\",\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":9,\"name\":\"field_10\",\"extras\":{\"showConfigurator\":false},\"type\":\"radio\",\"label\":\"What time works best for you?\",\"help_text\":null,\"options\":\"Morning\\nAfternoon\\nEvening\",\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":10,\"name\":\"field_11\",\"extras\":{\"showConfigurator\":false},\"type\":\"calendar\",\"label\":\"Any specific date\\/time?\",\"help_text\":null,\"size\":null,\"prefix_icon\":\"fa-calendar-check\",\"suffix_icon\":\"none\",\"custom_class\":null,\"start_date\":\"today\",\"end_date\":\"none\",\"format\":\"MM-DD-YYYY\",\"disabled_days\":[],\"enable_time_picker\":true,\"time_format\":\"12\",\"time_picker_inline\":true,\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":11,\"name\":\"field_12\",\"extras\":{\"showConfigurator\":false},\"type\":\"textarea\",\"label\":\"What services are you intersted in?\",\"help_text\":null,\"prefix_icon\":\"none\",\"suffix_icon\":\"none\",\"rows\":3,\"columns\":null,\"placeholder\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":13,\"name\":\"field_14\",\"extras\":{\"showConfigurator\":false},\"type\":\"terms_and_condition\",\"label\":\"Terms & Conditions\",\"link\":null,\"custom_class\":null,\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[],\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[]}],\"emailConfig\":{\"email\":{\"from\":\"admin@admin.com\",\"to\":\"admin@admin.com\",\"cc\":null,\"bcc\":null,\"subject\":\"New Appointment request from : __field_1__\",\"body\":\"New Appoinment request : \\nName : __field_1__\\nPhone Number : __field_4__\\nEmail : __field_2__\\nAddress : __field_8__\\nWhat Days work best for __field_1__ : __field_9__\\nWhat time work best for __field_1__ : __field_10__\\nSpecific date\\/time : __field_11__ \\nService Intrested In : __field_12__\"},\"auto_response\":{\"from\":null,\"to\":null,\"subject\":null,\"body\":null,\"is_enable\":false},\"smtp\":{\"host\":null,\"port\":null,\"from_address\":null,\"from_name\":null,\"encryption\":null,\"username\":null,\"password\":null,\"use_system_smtp\":1}},\"settings\":{\"recaptcha\":{\"is_enable\":0,\"site_key\":null,\"secret_key\":null},\"color\":{\"label\":\"#000000\",\"error_msg\":\"#a94442\",\"required_asterisk_color\":\"#a94442\",\"background\":\"#ffffff\",\"image_path\":null},\"notification\":{\"post_submit_action\":\"same_page\",\"failed_msg\":\"Something went wrong, please try again.\",\"success_msg\":\"Email sent successfully.\",\"redirect_url\":null,\"position\":\"toast-top-right\"},\"submit\":{\"text\":\"Submit\",\"loading_text\":\"Submitting...\",\"btn_alignment\":\"float-right\",\"btn_size\":null,\"btn_color\":\"btn-primary\",\"btn_style\":\"default\",\"btn_icon\":\"none\",\"icon_position\":\"left\"},\"form_data\":{\"col_visible\":[\"field_1\",\"field_2\",\"field_8\",\"field_9\",\"field_10\",\"field_11\",\"field_12\",\"field_13\",\"field_14\"],\"btn_enabled\":[\"view\",\"delete\"]},\"background\":{\"bg_type\":\"bg_color\"},\"form_scheduling\":{\"closed_msg\":\"The form has been closed now!\",\"start_date_time\":null,\"end_date_time\":null,\"is_enabled\":false},\"form_submision_ref\":{\"is_enabled\":false,\"prefix\":null,\"suffix\":null,\"start_no\":\"1\",\"min_digit\":\"4\"},\"theme\":\"yeti\",\"is_enabled_draft_submit\":0},\"additional_js_css\":{\"js\":null,\"css\":null},\"conditional_fields\":[{\"action\":null,\"element\":null,\"conditions\":[{\"condition\":null,\"value\":null,\"element_type\":\"text\",\"element_index\":null,\"operator\":\"==\"}]}],\"form_attributes\":[]}', '{\"is_enable\":false,\"api_key\":null,\"list_id\":null,\"email_field\":null,\"name_field\":null}', 1, 0, 1, 0, '2020-07-28 13:32:42', '2020-07-28 13:32:42'), ('254525ab-e3b4-45f0-9d1e-24cf89fedwq1', 'Appointment request form', 'appointment-request-form-att', 'Appointment request for any service', '{\"form\":[{\"id\":5,\"name\":\"field_6\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"h1\",\"text_color\":\"#ee301d\",\"content\":\"Appointment request\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[]},{\"id\":6,\"name\":\"field_7\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"p\",\"text_color\":\"#515658\",\"content\":\"Let us know how we can help transform your landscape! the theme used here is \'yeti\'.\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[]},{\"id\":0,\"name\":\"field_1\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Name\",\"help_text\":null,\"prefix_icon\":\"fa-user\",\"suffix_icon\":\"none\",\"placeholder\":\"Enter your name\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-4\",\"custom_attributes\":[]},{\"id\":3,\"name\":\"field_4\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Phone No.\",\"help_text\":null,\"prefix_icon\":\"fa-phone\",\"suffix_icon\":\"none\",\"placeholder\":\"Phone number to contact you\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-4\",\"custom_attributes\":[]},{\"id\":1,\"name\":\"field_2\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"email\",\"label\":\"Email\",\"help_text\":null,\"prefix_icon\":\"fa-envelope\",\"suffix_icon\":\"none\",\"placeholder\":\"Email to contact you\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[{\"rule\":\"email\",\"error_msg\":\"Please provide a valid email\"}],\"conditional_class\":null,\"col\":\"col-md-4\",\"custom_attributes\":[]},{\"id\":7,\"name\":\"field_8\",\"extras\":{\"showConfigurator\":false},\"type\":\"textarea\",\"label\":\"Address\",\"help_text\":null,\"prefix_icon\":\"fa-map-marker\",\"suffix_icon\":\"none\",\"rows\":3,\"columns\":null,\"placeholder\":\"Provide street, landmark, city, state, postal code, country\",\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":8,\"name\":\"field_9\",\"extras\":{\"showConfigurator\":false},\"type\":\"checkbox\",\"label\":\"What days work best for you?\",\"help_text\":null,\"options\":\"Monday\\nTuesday\\nWednesday\\nThursday\\nFriday\\nSaturday\",\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":9,\"name\":\"field_10\",\"extras\":{\"showConfigurator\":false},\"type\":\"radio\",\"label\":\"What time works best for you?\",\"help_text\":null,\"options\":\"Morning\\nAfternoon\\nEvening\",\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":10,\"name\":\"field_11\",\"extras\":{\"showConfigurator\":false},\"type\":\"calendar\",\"label\":\"Any specific date\\/time?\",\"help_text\":null,\"size\":null,\"prefix_icon\":\"fa-calendar-check\",\"suffix_icon\":\"none\",\"custom_class\":null,\"start_date\":\"today\",\"end_date\":\"none\",\"format\":\"MM-DD-YYYY\",\"disabled_days\":[],\"enable_time_picker\":true,\"time_format\":\"12\",\"time_picker_inline\":true,\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":11,\"name\":\"field_12\",\"extras\":{\"showConfigurator\":false},\"type\":\"textarea\",\"label\":\"What services are you intersted in?\",\"help_text\":null,\"prefix_icon\":\"none\",\"suffix_icon\":\"none\",\"rows\":3,\"columns\":null,\"placeholder\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":13,\"name\":\"field_14\",\"extras\":{\"showConfigurator\":false},\"type\":\"terms_and_condition\",\"label\":\"Terms & Conditions\",\"link\":null,\"custom_class\":null,\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[],\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[]}],\"emailConfig\":{\"email\":{\"from\":\"admin@admin.com\",\"to\":\"admin@admin.com\",\"cc\":null,\"bcc\":null,\"subject\":\"New Appointment request from : __field_1__\",\"body\":\"New Appoinment request : \\nName : __field_1__\\nPhone Number : __field_4__\\nEmail : __field_2__\\nAddress : __field_8__\\nWhat Days work best for __field_1__ : __field_9__\\nWhat time work best for __field_1__ : __field_10__\\nSpecific date\\/time : __field_11__ \\nService Intrested In : __field_12__\"},\"auto_response\":{\"from\":null,\"to\":null,\"subject\":null,\"body\":null,\"is_enable\":false},\"smtp\":{\"host\":null,\"port\":null,\"from_address\":null,\"from_name\":null,\"encryption\":null,\"username\":null,\"password\":null,\"use_system_smtp\":1}},\"settings\":{\"recaptcha\":{\"is_enable\":0,\"site_key\":null,\"secret_key\":null},\"color\":{\"label\":\"#000000\",\"error_msg\":\"#a94442\",\"required_asterisk_color\":\"#a94442\",\"background\":\"#ffffff\",\"image_path\":null},\"notification\":{\"post_submit_action\":\"same_page\",\"failed_msg\":\"Something went wrong, please try again.\",\"success_msg\":\"Email sent successfully.\",\"redirect_url\":null,\"position\":\"toast-top-right\"},\"submit\":{\"text\":\"Submit\",\"loading_text\":\"Submitting...\",\"btn_alignment\":\"float-right\",\"btn_size\":null,\"btn_color\":\"btn-primary\",\"btn_style\":\"default\",\"btn_icon\":\"none\",\"icon_position\":\"left\"},\"form_data\":{\"col_visible\":[\"field_1\",\"field_2\",\"field_8\",\"field_9\",\"field_10\",\"field_11\",\"field_12\",\"field_13\",\"field_14\"],\"btn_enabled\":[\"view\",\"delete\"]},\"background\":{\"bg_type\":\"bg_color\"},\"form_scheduling\":{\"closed_msg\":\"The form has been closed now!\",\"start_date_time\":null,\"end_date_time\":null,\"is_enabled\":false},\"form_submision_ref\":{\"is_enabled\":false,\"prefix\":null,\"suffix\":null,\"start_no\":\"1\",\"min_digit\":\"4\"},\"theme\":\"yeti\",\"is_enabled_draft_submit\":0},\"additional_js_css\":{\"js\":null,\"css\":null},\"conditional_fields\":[{\"action\":null,\"element\":null,\"conditions\":[{\"condition\":null,\"value\":null,\"element_type\":\"text\",\"element_index\":null,\"operator\":\"==\"}]}],\"form_attributes\":[]}', '{\"is_enable\":false,\"api_key\":null,\"list_id\":null,\"email_field\":null,\"name_field\":null}', 0, 0, 1, 0, '2020-07-28 13:32:42', '2020-07-29 09:58:55'), ('2cf00d1d-9553-42d5-b406-002d0fa0a426', 'Product order', 'product-order-mktts', 'Product order form for your customers', '{\"form\":[{\"id\":0,\"name\":\"field_1\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"h2\",\"text_color\":\"#f32b6d\",\"content\":\"Product Order\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[]},{\"id\":1,\"name\":\"field_2\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Name\",\"help_text\":null,\"prefix_icon\":\"fa-user\",\"suffix_icon\":\"none\",\"placeholder\":\"Enter your name\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-6\",\"custom_attributes\":[]},{\"id\":2,\"name\":\"field_3\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Company\",\"help_text\":null,\"prefix_icon\":\"fa-briefcase\",\"suffix_icon\":\"none\",\"placeholder\":\"Enter Company name\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-6\",\"custom_attributes\":[]},{\"id\":5,\"name\":\"field_6\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Phone no.\",\"help_text\":null,\"prefix_icon\":\"fa-phone-square\",\"suffix_icon\":\"none\",\"placeholder\":\"Enter phone no. to contact you\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[{\"rule\":\"digits\",\"error_msg\":\"Please Provide valid number.\"}],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":3,\"name\":\"field_4\",\"extras\":{\"showConfigurator\":false},\"type\":\"textarea\",\"label\":\"Shipping Address\",\"help_text\":null,\"prefix_icon\":\"fa-map-marker-alt\",\"suffix_icon\":\"none\",\"rows\":3,\"columns\":null,\"placeholder\":\"Provide street, landmark, city, state, postal code, country\",\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":4,\"name\":\"field_5\",\"extras\":{\"showConfigurator\":false},\"type\":\"textarea\",\"label\":\"Billing Address\",\"help_text\":null,\"prefix_icon\":\"fa-map-marker\",\"suffix_icon\":\"none\",\"rows\":3,\"columns\":null,\"placeholder\":\"Provide street, landmark, city, state, postal code, country\",\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":6,\"name\":\"field_7\",\"extras\":{\"showConfigurator\":false},\"type\":\"textarea\",\"label\":\"Special Instructions\",\"help_text\":null,\"prefix_icon\":\"fa-info\",\"suffix_icon\":\"none\",\"rows\":3,\"columns\":null,\"placeholder\":null,\"custom_class\":null,\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":7,\"name\":\"field_8\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"h4\",\"text_color\":\"#212529\",\"content\":\"My products\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[]},{\"id\":8,\"name\":\"field_9\",\"extras\":{\"showConfigurator\":false},\"type\":\"checkbox\",\"label\":null,\"help_text\":null,\"options\":\"Product 1 $3.00\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-6\",\"custom_attributes\":[]},{\"id\":9,\"name\":\"field_10\",\"extras\":{\"showConfigurator\":false},\"type\":\"dropdown\",\"label\":\"Quantity For Product 1\",\"help_text\":null,\"prefix_icon\":\"none\",\"suffix_icon\":\"none\",\"options\":\"1\\n2\\n3\\n4\\n5\\n6\\n7\\n8\\n9\\n10\",\"size\":null,\"custom_class\":null,\"multiselect\":false,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-6\",\"custom_attributes\":[]},{\"id\":10,\"name\":\"field_11\",\"extras\":{\"showConfigurator\":false},\"type\":\"checkbox\",\"label\":null,\"help_text\":null,\"options\":\"Product 2 $5.00\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-6\",\"custom_attributes\":[]},{\"id\":11,\"name\":\"field_12\",\"extras\":{\"showConfigurator\":false},\"type\":\"dropdown\",\"label\":\"Quantity For Product 2\",\"help_text\":null,\"prefix_icon\":\"none\",\"suffix_icon\":\"none\",\"options\":\"1\\n2\\n3\\n4\\n5\\n6\\n7\\n8\\n9\\n10\",\"size\":null,\"custom_class\":null,\"multiselect\":false,\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-6\",\"custom_attributes\":[]}],\"emailConfig\":{\"email\":{\"from\":\"admin@admin.com\",\"to\":\"admin@admin.com\",\"cc\":null,\"bcc\":null,\"subject\":\"Product Order From : __field_2__\",\"body\":\"Product Order : \\nName : __field_2__\\nCompany : __field_3__ \\nShipping Address : __field_4__\\nBilling Address : __field_5__\\nContact number : __field_6__\\nSpecial Intruction : __field_7__\\nProduct 1: __field_9__\\nQuantity for product 1 : __field_10__\\nProduct 2 : __field_11__\\nQuantity for product 2 : __field_12__\"},\"auto_response\":{\"from\":null,\"to\":null,\"subject\":null,\"body\":null,\"is_enable\":false},\"smtp\":{\"host\":null,\"port\":null,\"from_address\":null,\"from_name\":null,\"encryption\":null,\"username\":null,\"password\":null,\"use_system_smtp\":1}},\"settings\":{\"recaptcha\":{\"is_enable\":0,\"site_key\":null,\"secret_key\":null},\"color\":{\"label\":\"#000000\",\"error_msg\":\"#a94442\",\"required_asterisk_color\":\"#a94442\",\"background\":\"#ffffff\",\"image_path\":null},\"notification\":{\"post_submit_action\":\"same_page\",\"failed_msg\":\"Something went wrong, please try again.\",\"success_msg\":\"Email sent successfully.\",\"redirect_url\":null,\"position\":\"toast-top-right\"},\"submit\":{\"text\":\"Submit\",\"loading_text\":\"Submitting...\",\"btn_alignment\":\"float-right\",\"btn_size\":null,\"btn_color\":\"btn-outline-success\",\"btn_style\":\"outline\",\"btn_icon\":\"fa-fast-forward\",\"icon_position\":\"left\"},\"form_data\":{\"col_visible\":[\"field_2\",\"field_3\",\"field_4\",\"field_5\",\"field_6\",\"field_7\",\"field_9\",\"field_10\",\"field_11\",\"field_12\"],\"btn_enabled\":[\"view\",\"delete\"]},\"background\":{\"bg_type\":\"bg_color\"},\"form_scheduling\":{\"closed_msg\":\"The form has been closed now!\",\"start_date_time\":null,\"end_date_time\":null,\"is_enabled\":false},\"form_submision_ref\":{\"is_enabled\":false,\"prefix\":null,\"suffix\":null,\"start_no\":\"1\",\"min_digit\":\"4\"},\"theme\":\"cerulean\",\"is_enabled_draft_submit\":0},\"additional_js_css\":{\"js\":null,\"css\":null},\"conditional_fields\":[{\"action\":null,\"element\":null,\"conditions\":[{\"condition\":null,\"value\":null,\"element_type\":\"text\",\"element_index\":null,\"operator\":\"==\"}]}],\"form_attributes\":[]}', '{\"is_enable\":false,\"api_key\":null,\"list_id\":null,\"email_field\":null,\"name_field\":null}', 1, 0, 1, 0, '2020-07-28 13:32:42', '2020-07-28 13:32:42'), ('3984156b-e698-4e68-858d-1758002a3d14', 'Research survey form', 'research-survey-form-jeq', 'Surveys are the perfect way to gauge customer, employee, or even just public opinion about your brand', '{\"form\":[{\"id\":0,\"name\":\"field_1\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"h1\",\"text_color\":\"#267acf\",\"content\":\"Research Survey\",\"col\":\"col-md-12\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"custom_attributes\":[],\"conditional_class\":null},{\"id\":1,\"name\":\"field_2\",\"extras\":{\"showConfigurator\":false},\"type\":\"html_text\",\"label\":\"HTML Text\",\"html_text\":\"

Please take a few minutes to fill out this research survey.<\\/span>
<\\/p>\",\"custom_class\":null,\"col\":\"col-md-12\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"custom_attributes\":[],\"conditional_class\":null},{\"id\":2,\"name\":\"field_3\",\"extras\":{\"showConfigurator\":false},\"type\":\"radio\",\"label\":\"Gender\",\"help_text\":null,\"options\":\"Male\\nFemale\\nN\\/A\",\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[],\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[]},{\"id\":3,\"name\":\"field_4\",\"extras\":{\"showConfigurator\":false},\"type\":\"radio\",\"label\":\"Age\",\"help_text\":null,\"options\":\"0 - 17\\n18 - 24\\n25 - 34\\n35 - 44\\n45 - 54\\n55 or more\",\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[],\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[]},{\"id\":4,\"name\":\"field_5\",\"extras\":{\"showConfigurator\":false},\"type\":\"radio\",\"label\":\"Education\",\"help_text\":null,\"options\":\"Less than HS diploma\\nHigh school\\nBachelors degree\\nGraduate degre\\nMaster degree\",\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[],\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[]},{\"id\":5,\"name\":\"field_6\",\"extras\":{\"showConfigurator\":false},\"type\":\"radio\",\"label\":\"income\",\"help_text\":null,\"options\":\"$0 - $24,999\\n$25,000 - $49,999\\n$50,000 - $74,999\\n$75,000 - $99,999\\n$100,000 - $149,999\\n$150,000 or more\",\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[],\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[]},{\"id\":6,\"name\":\"field_7\",\"extras\":{\"showConfigurator\":false},\"type\":\"radio\",\"label\":\"Business type\",\"help_text\":null,\"options\":\"Real state\\nHealth sector\\nFood business\\n Life\\/career coach\\nConsultant firm\",\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[],\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[]},{\"id\":7,\"name\":\"field_8\",\"extras\":{\"showConfigurator\":false},\"type\":\"switch\",\"label\":\"Any other business?\",\"conditional_class\":null,\"help_text\":null,\"size\":\"switch\",\"col\":\"col-md-12\",\"custom_attributes\":[],\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[]},{\"id\":8,\"name\":\"field_9\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Business name\",\"help_text\":null,\"prefix_icon\":\"none\",\"suffix_icon\":\"none\",\"placeholder\":null,\"size\":null,\"custom_class\":null,\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[],\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[]}],\"emailConfig\":{\"email\":{\"enable\":null,\"from\":null,\"to\":null,\"cc\":null,\"bcc\":null,\"subject\":null,\"body\":null},\"auto_response\":{\"from\":null,\"to\":null,\"subject\":null,\"body\":null,\"is_enable\":false},\"smtp\":{\"host\":null,\"port\":null,\"from_address\":null,\"from_name\":null,\"encryption\":null,\"username\":null,\"password\":null,\"use_system_smtp\":1}},\"settings\":{\"recaptcha\":{\"is_enable\":0,\"site_key\":null,\"secret_key\":null},\"color\":{\"label\":\"#000000\",\"error_msg\":\"#a94442\",\"required_asterisk_color\":\"#a94442\",\"background\":\"#ffffff\",\"image_path\":null},\"notification\":{\"post_submit_action\":\"same_page\",\"failed_msg\":\"Something went wrong, please try again.\",\"success_msg\":\"Email sent successfully.\",\"redirect_url\":null,\"position\":\"toast-bottom-right\"},\"submit\":{\"text\":\"Save\",\"loading_text\":\"Saving....\",\"btn_alignment\":\"float-right\",\"btn_size\":null,\"btn_color\":\"btn-outline-warning\",\"btn_style\":\"outline\",\"btn_icon\":\"fa-save\",\"icon_position\":\"left\"},\"form_data\":{\"col_visible\":[\"field_3\",\"field_4\",\"field_5\",\"field_6\",\"field_7\",\"field_8\",\"field_9\"],\"btn_enabled\":[\"view\",\"delete\"]},\"background\":{\"bg_type\":\"bg_color\"},\"form_scheduling\":{\"closed_msg\":\"The form has been closed now!\",\"start_date_time\":null,\"end_date_time\":null,\"is_enabled\":false},\"form_submision_ref\":{\"is_enabled\":false,\"prefix\":null,\"suffix\":null,\"start_no\":\"1\",\"min_digit\":\"4\"},\"theme\":\"materia\",\"is_enabled_draft_submit\":0},\"additional_js_css\":{\"js\":null,\"css\":null},\"conditional_fields\":[{\"action\":\"show\",\"element\":\"field_9\",\"conditions\":[{\"condition\":\"field_8\",\"value\":\"1\",\"element_type\":\"switch\",\"element_index\":7,\"operator\":\"==\"}]}],\"form_attributes\":[]}', '[]', 0, 0, 1, 0, '2020-07-28 16:45:13', '2020-07-29 09:57:34'), ('426ce4ff-1341-461d-123s-e855ce444a31', 'Contact form', 'contact-form-peg', 'Simple form with name, contact, subject & body.', '{\"form\":[{\"id\":5,\"name\":\"field_6\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"h1\",\"text_color\":\"#ee301d\",\"content\":\"Contact us\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[]},{\"id\":6,\"name\":\"field_7\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"p\",\"text_color\":\"#343637\",\"content\":\"Fill out the form below and we will contact you soon.\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[]},{\"id\":0,\"name\":\"field_1\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Name\",\"help_text\":null,\"prefix_icon\":\"fa-user\",\"suffix_icon\":\"none\",\"placeholder\":\"Enter your name\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":1,\"name\":\"field_2\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"email\",\"label\":\"Email\",\"help_text\":null,\"prefix_icon\":\"fa-envelope\",\"suffix_icon\":\"none\",\"placeholder\":\"Email to contact you\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[{\"rule\":\"email\",\"error_msg\":\"Please provide a valid email\"}],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":3,\"name\":\"field_4\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Phone No.\",\"help_text\":null,\"prefix_icon\":\"fa-phone\",\"suffix_icon\":\"none\",\"placeholder\":\"Phone number to contact you\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":2,\"name\":\"field_3\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Subject\",\"help_text\":null,\"prefix_icon\":\"fa-question\",\"suffix_icon\":\"none\",\"placeholder\":null,\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":4,\"name\":\"field_5\",\"extras\":{\"showConfigurator\":false},\"type\":\"textarea\",\"label\":\"Body\",\"help_text\":null,\"prefix_icon\":\"none\",\"suffix_icon\":\"none\",\"rows\":\"7\",\"columns\":null,\"placeholder\":null,\"custom_class\":null,\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"}],\"emailConfig\":{\"email\":{\"from\":\"admin@admin.com\",\"to\":\"admin@admin.com\",\"cc\":null,\"bcc\":null,\"subject\":\"New contact from __field_1__\",\"body\":\"New contact form submission:\\n\\nName: __field_1__\\nEmail: __field_2__\\nPhone No.: __field_4__\\nSubject: __field_3__\\nBody: __field_5__\\n\\n--------------------------\\nSend via contact form\"},\"auto_response\":{\"from\":null,\"to\":null,\"subject\":null,\"body\":null,\"is_enable\":false},\"smtp\":{\"host\":null,\"port\":null,\"from_address\":null,\"from_name\":null,\"encryption\":null,\"username\":null,\"password\":null,\"use_system_smtp\":1}},\"settings\":{\"recaptcha\":{\"is_enable\":0,\"site_key\":null,\"secret_key\":null},\"color\":{\"label\":\"#000000\",\"error_msg\":\"#a94442\",\"required_asterisk_color\":\"#a94442\",\"background\":\"#ffffff\",\"image_path\":null},\"notification\":{\"post_submit_action\":\"redirect\",\"failed_msg\":\"Something went wrong, please try again.\",\"success_msg\":\"Email sent successfully.\",\"redirect_url\":\"http:\\/\\/thewebfosters.com\\/\",\"position\":\"toast-top-right\"},\"submit\":{\"text\":\"Submit\",\"loading_text\":\"Submitting...\",\"btn_alignment\":\"float-right\",\"btn_size\":null,\"btn_color\":\"btn-outline-success\",\"btn_style\":\"outline\",\"btn_icon\":\"fa-share\",\"icon_position\":\"right\"},\"form_data\":{\"col_visible\":[\"field_1\",\"field_2\",\"field_4\",\"field_3\",\"field_5\"],\"btn_enabled\":[\"view\",\"delete\"]},\"background\":{\"bg_type\":\"bg_color\"},\"form_scheduling\":{\"closed_msg\":\"The form has been closed now!\",\"start_date_time\":null,\"end_date_time\":null,\"is_enabled\":false},\"form_submision_ref\":{\"is_enabled\":true,\"prefix\":\"#ref\",\"suffix\":null,\"start_no\":\"1\",\"min_digit\":\"4\"},\"theme\":\"materia\",\"is_enabled_draft_submit\":true},\"additional_js_css\":{\"js\":null,\"css\":null},\"conditional_fields\":[{\"action\":null,\"element\":null,\"conditions\":[{\"condition\":null,\"value\":null,\"element_type\":\"text\",\"element_index\":null,\"operator\":\"==\"}]}],\"form_attributes\":[]}', '{\"is_enable\":false,\"api_key\":null,\"list_id\":null,\"email_field\":null,\"name_field\":null}', 1, 0, 1, 1, '2020-07-28 13:32:42', '2020-07-28 13:32:42'); INSERT INTO `forms` (`id`, `name`, `slug`, `description`, `schema`, `mailchimp_details`, `is_template`, `is_global_template`, `created_by`, `submission_count`, `created_at`, `updated_at`) VALUES ('426ce4ff-1341-461d-b562-e855ce44lyn6', 'Contact form with Draft button', 'contact-form-with-draft-button-aub', 'Simple form with name, contact, subject & body.', '{\"form\":[{\"id\":5,\"name\":\"field_6\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"h1\",\"text_color\":\"#ee301d\",\"content\":\"Contact us\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[]},{\"id\":6,\"name\":\"field_7\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"p\",\"text_color\":\"#343637\",\"content\":\"Fill out the form below and we will contact you soon, material theme is used here, you can save form as a draft and you\'ll be given a URL through which you can fill & submit the form later.\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[]},{\"id\":0,\"name\":\"field_1\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Name\",\"help_text\":null,\"prefix_icon\":\"fa-user\",\"suffix_icon\":\"none\",\"placeholder\":\"Enter your name\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":1,\"name\":\"field_2\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"email\",\"label\":\"Email\",\"help_text\":null,\"prefix_icon\":\"fa-envelope\",\"suffix_icon\":\"none\",\"placeholder\":\"Email to contact you\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[{\"rule\":\"email\",\"error_msg\":\"Please provide a valid email\"}],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":3,\"name\":\"field_4\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Phone No.\",\"help_text\":null,\"prefix_icon\":\"fa-phone\",\"suffix_icon\":\"none\",\"placeholder\":\"Phone number to contact you\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":2,\"name\":\"field_3\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Subject\",\"help_text\":null,\"prefix_icon\":\"fa-question\",\"suffix_icon\":\"none\",\"placeholder\":null,\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":4,\"name\":\"field_5\",\"extras\":{\"showConfigurator\":false},\"type\":\"textarea\",\"label\":\"Body\",\"help_text\":null,\"prefix_icon\":\"none\",\"suffix_icon\":\"none\",\"rows\":\"7\",\"columns\":null,\"placeholder\":null,\"custom_class\":null,\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"}],\"emailConfig\":{\"email\":{\"from\":\"admin@admin.com\",\"to\":\"admin@admin.com\",\"cc\":null,\"bcc\":null,\"subject\":\"New contact from __field_1__\",\"body\":\"New contact form submission:\\n\\nName: __field_1__\\nEmail: __field_2__\\nPhone No.: __field_4__\\nSubject: __field_3__\\nBody: __field_5__\\n\\n--------------------------\\nSend via contact form\"},\"auto_response\":{\"from\":null,\"to\":null,\"subject\":null,\"body\":null,\"is_enable\":false},\"smtp\":{\"host\":null,\"port\":null,\"from_address\":null,\"from_name\":null,\"encryption\":null,\"username\":null,\"password\":null,\"use_system_smtp\":1}},\"settings\":{\"recaptcha\":{\"is_enable\":0,\"site_key\":null,\"secret_key\":null},\"color\":{\"label\":\"#000000\",\"error_msg\":\"#a94442\",\"required_asterisk_color\":\"#a94442\",\"background\":\"#ffffff\",\"image_path\":null},\"notification\":{\"post_submit_action\":\"redirect\",\"failed_msg\":\"Something went wrong, please try again.\",\"success_msg\":\"Email sent successfully.\",\"redirect_url\":\"http:\\/\\/thewebfosters.com\\/\",\"position\":\"toast-top-right\"},\"submit\":{\"text\":\"Submit\",\"loading_text\":\"Submitting...\",\"btn_alignment\":\"float-right\",\"btn_size\":null,\"btn_color\":\"btn-outline-success\",\"btn_style\":\"outline\",\"btn_icon\":\"fa-share\",\"icon_position\":\"right\"},\"form_data\":{\"col_visible\":[\"field_1\",\"field_2\",\"field_4\",\"field_3\",\"field_5\"],\"btn_enabled\":[\"view\",\"delete\"]},\"background\":{\"bg_type\":\"bg_color\"},\"form_scheduling\":{\"closed_msg\":\"The form has been closed now!\",\"start_date_time\":null,\"end_date_time\":null,\"is_enabled\":false},\"form_submision_ref\":{\"is_enabled\":true,\"prefix\":\"#ref\",\"suffix\":null,\"start_no\":\"1\",\"min_digit\":\"4\"},\"theme\":\"materia\",\"is_enabled_draft_submit\":true},\"additional_js_css\":{\"js\":null,\"css\":null},\"conditional_fields\":[{\"action\":null,\"element\":null,\"conditions\":[{\"condition\":null,\"value\":null,\"element_type\":\"text\",\"element_index\":null,\"operator\":\"==\"}]}],\"form_attributes\":[]}', '{\"is_enable\":false,\"api_key\":null,\"list_id\":null,\"email_field\":null,\"name_field\":null}', 0, 0, 1, 1, '2020-07-28 13:32:42', '2020-07-28 13:32:42'), ('6309c0a2-77ed-47aa-b0e2-81e5a4c048a0', 'Contact form with conditional field', 'contact-form-with-conditional-field-9q8', 'Simple form with name, contact, subject & body.', '{\"form\":[{\"id\":5,\"name\":\"field_6\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"h1\",\"text_color\":\"#ee301d\",\"content\":\"Contact us\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":6,\"name\":\"field_7\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"p\",\"text_color\":\"#343637\",\"content\":\"Fill out the form below and we will contact you soon, here email & phone no. are conditional fields, fill the name and see the effect.\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[]},{\"id\":0,\"name\":\"field_1\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Name\",\"help_text\":null,\"prefix_icon\":\"fa-user\",\"suffix_icon\":\"none\",\"placeholder\":\"Enter your name\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":1,\"name\":\"field_2\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"email\",\"label\":\"Email\",\"help_text\":null,\"prefix_icon\":\"fa-envelope\",\"suffix_icon\":\"none\",\"placeholder\":\"Email to contact you\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[{\"rule\":\"email\",\"error_msg\":\"Please provide a valid email\"}],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":3,\"name\":\"field_4\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Phone No.\",\"help_text\":null,\"prefix_icon\":\"fa-phone\",\"suffix_icon\":\"none\",\"placeholder\":\"Phone number to contact you\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":2,\"name\":\"field_3\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Subject\",\"help_text\":null,\"prefix_icon\":\"fa-question\",\"suffix_icon\":\"none\",\"placeholder\":null,\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":4,\"name\":\"field_5\",\"extras\":{\"showConfigurator\":false},\"type\":\"textarea\",\"label\":\"Body\",\"help_text\":null,\"prefix_icon\":\"none\",\"suffix_icon\":\"none\",\"rows\":\"7\",\"columns\":null,\"placeholder\":null,\"custom_class\":null,\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"}],\"emailConfig\":{\"email\":{\"from\":\"admin@admin.com\",\"to\":\"admin@admin.com\",\"cc\":null,\"bcc\":null,\"subject\":\"New contact from __field_1__\",\"body\":\"New contact form submission:\\n\\nName: __field_1__\\nEmail: __field_2__\\nPhone No.: __field_4__\\nSubject: __field_3__\\nBody: __field_5__\\n\\n--------------------------\\nSend via contact form\"},\"auto_response\":{\"from\":null,\"to\":null,\"subject\":null,\"body\":null,\"is_enable\":false},\"smtp\":{\"host\":null,\"port\":null,\"from_address\":null,\"from_name\":null,\"encryption\":null,\"username\":null,\"password\":null,\"use_system_smtp\":1}},\"settings\":{\"recaptcha\":{\"is_enable\":false,\"site_key\":null,\"secret_key\":null},\"color\":{\"label\":\"#000000\",\"error_msg\":\"#a94442\",\"required_asterisk_color\":\"#a94442\",\"background\":\"#86A7A3\",\"image_path\":null},\"notification\":{\"post_submit_action\":\"same_page\",\"failed_msg\":\"Something went wrong, please try again.\",\"success_msg\":\"Email sent successfully.\",\"redirect_url\":null,\"position\":\"toast-bottom-center\"},\"submit\":{\"text\":\"Submit\",\"loading_text\":\"Submitting...\",\"btn_alignment\":\"float-right\",\"btn_size\":null,\"btn_color\":\"btn-outline-primary\",\"btn_style\":\"outline\",\"btn_icon\":\"fa-save\",\"icon_position\":\"left\"},\"form_data\":{\"col_visible\":[\"field_1\",\"field_2\",\"field_4\",\"field_3\",\"field_5\"],\"btn_enabled\":[\"view\",\"delete\"]},\"background\":{\"bg_type\":\"bg_color\"},\"form_scheduling\":{\"closed_msg\":\"The form has been closed now!\",\"start_date_time\":null,\"end_date_time\":null,\"is_enabled\":false},\"form_submision_ref\":{\"is_enabled\":false,\"prefix\":null,\"suffix\":null,\"start_no\":\"1\",\"min_digit\":\"4\"},\"theme\":\"lumen\",\"is_enabled_draft_submit\":0},\"additional_js_css\":{\"js\":null,\"css\":null},\"conditional_fields\":[{\"action\":\"show\",\"element\":\"field_2\",\"conditions\":[{\"condition\":\"field_1\",\"value\":null,\"element_type\":\"text\",\"element_index\":2,\"operator\":\"not_empty\"}]},{\"action\":\"show\",\"element\":\"field_4\",\"conditions\":[{\"condition\":\"field_1\",\"value\":null,\"element_type\":\"text\",\"element_index\":2,\"operator\":\"not_empty\"},{\"condition\":\"field_2\",\"value\":null,\"element_type\":\"text\",\"element_index\":3,\"operator\":\"not_empty\"}]}],\"form_attributes\":[]}', '{\"is_enable\":false,\"api_key\":null,\"list_id\":null,\"email_field\":null,\"name_field\":null}', 0, 0, 1, 0, '2020-07-28 13:32:42', '2020-07-29 10:09:14'), ('6aaf3f59-afab-40ac-a5fc-f38ad7274ae9', 'Course registration form', 'course-registration-form-tge', 'Course registration form for students', '{\"form\":[{\"id\":0,\"name\":\"field_1\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"h2\",\"text_color\":\"#f7676b\",\"content\":\"Student Registration Form\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":1,\"name\":\"field_2\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"p\",\"text_color\":\"#5c646d\",\"content\":\"Fill out the form carefully for registration\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":2,\"name\":\"field_3\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Student Name\",\"help_text\":null,\"prefix_icon\":\"fa-user\",\"suffix_icon\":\"none\",\"placeholder\":\"Enter your name\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-6\",\"custom_attributes\":[]},{\"id\":3,\"name\":\"field_4\",\"extras\":{\"showConfigurator\":false},\"type\":\"calendar\",\"label\":\"Birth Date\",\"help_text\":null,\"size\":null,\"prefix_icon\":\"fa-calendar-check\",\"suffix_icon\":\"none\",\"custom_class\":null,\"start_date\":\"none\",\"end_date\":\"none\",\"format\":\"MM-DD-YYYY\",\"disabled_days\":[],\"enable_time_picker\":false,\"time_format\":\"12\",\"time_picker_inline\":false,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-6\",\"custom_attributes\":[]},{\"id\":4,\"name\":\"field_5\",\"extras\":{\"showConfigurator\":false},\"type\":\"radio\",\"label\":\"Gender\",\"help_text\":null,\"options\":\"Male\\nFemale\\nOther\",\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":6,\"name\":\"field_7\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"email\",\"label\":\"Email\",\"help_text\":null,\"prefix_icon\":\"fa-envelope\",\"suffix_icon\":\"none\",\"placeholder\":\"Enter your email\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[{\"rule\":\"email\",\"error_msg\":\"Please provide correct email.\"}],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":7,\"name\":\"field_8\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Mobile Number\",\"help_text\":null,\"prefix_icon\":\"fa-phone-square\",\"suffix_icon\":\"none\",\"placeholder\":\"Enter your mobile number\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":8,\"name\":\"field_9\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Company\",\"help_text\":null,\"prefix_icon\":\"fa-briefcase\",\"suffix_icon\":\"none\",\"placeholder\":\"Enter company name\",\"size\":null,\"custom_class\":null,\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":9,\"name\":\"field_10\",\"extras\":{\"showConfigurator\":false},\"type\":\"dropdown\",\"label\":\"Courses\",\"help_text\":\"Choose course you want to pursue\",\"prefix_icon\":\"fa-certificate\",\"suffix_icon\":\"none\",\"options\":\"Php\\nJava\\nC++\\nPython\\nGame Design\",\"size\":null,\"custom_class\":null,\"multiselect\":false,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":5,\"name\":\"field_6\",\"extras\":{\"showConfigurator\":false},\"type\":\"textarea\",\"label\":\"Address\",\"help_text\":null,\"prefix_icon\":\"fa-home\",\"suffix_icon\":\"none\",\"rows\":3,\"columns\":null,\"placeholder\":\"Provide street, landmark, city, state, postal code, country\",\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":11,\"name\":\"field_12\",\"extras\":{\"showConfigurator\":false},\"type\":\"file_upload\",\"label\":\"Image for logo\",\"help_text\":null,\"upload_text\":\"Drop a file here\",\"no_of_files\":\"1\",\"send_as_email_attachment\":true,\"file_size_limit\":5,\"file_type\":\"Specify_type\",\"allowed_file_type\":\".jpg, .png, .jpeg\",\"custom_class\":null,\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[],\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[]},{\"id\":10,\"name\":\"field_11\",\"extras\":{\"showConfigurator\":false},\"type\":\"textarea\",\"label\":\"Enquiry if any ?\",\"help_text\":null,\"prefix_icon\":\"fa-question-circle\",\"suffix_icon\":\"none\",\"rows\":3,\"columns\":null,\"placeholder\":null,\"custom_class\":null,\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"}],\"emailConfig\":{\"email\":{\"from\":\"admin@admin.com\",\"to\":\"admin@admin.com\",\"cc\":null,\"bcc\":null,\"subject\":\"New Registration By: __field_3__\",\"body\":\"Registration Details : \\nName : __field_3__\\nDOB : __field_4__\\nGender : __field_5__\\nAddress : __field_6__\\nEmail : __field_7__\\nMobile Number : __field_8__\\nCompany : __field_9__\\nCourse : __field_10__\\nEnquiry : __field_11__\"},\"auto_response\":{\"from\":null,\"to\":null,\"subject\":null,\"body\":null,\"is_enable\":false},\"smtp\":{\"host\":null,\"port\":null,\"from_address\":null,\"from_name\":null,\"encryption\":null,\"username\":null,\"password\":null,\"use_system_smtp\":1}},\"settings\":{\"recaptcha\":{\"is_enable\":0,\"site_key\":null,\"secret_key\":null},\"color\":{\"label\":\"#000000\",\"error_msg\":\"#a94442\",\"required_asterisk_color\":\"#a94442\",\"background\":\"#ffe2c2\",\"image_path\":null},\"notification\":{\"post_submit_action\":\"same_page\",\"failed_msg\":\"Something went wrong, please try again.\",\"success_msg\":\"Email sent successfully.\",\"redirect_url\":null,\"position\":\"toast-top-right\"},\"submit\":{\"text\":\"Submit\",\"loading_text\":\"Submitting...\",\"btn_alignment\":\"float-right\",\"btn_size\":null,\"btn_color\":\"btn-success\",\"btn_style\":\"default\",\"btn_icon\":\"fa-save\",\"icon_position\":\"left\"},\"form_data\":{\"col_visible\":[\"field_3\",\"field_4\",\"field_5\",\"field_6\",\"field_7\",\"field_8\",\"field_9\",\"field_10\",\"field_11\",\"field_12\"],\"btn_enabled\":[\"view\",\"delete\"]},\"background\":{\"bg_type\":\"bg_color\"},\"form_scheduling\":{\"closed_msg\":\"The form has been closed now!\",\"start_date_time\":null,\"end_date_time\":null,\"is_enabled\":false},\"form_submision_ref\":{\"is_enabled\":false,\"prefix\":null,\"suffix\":null,\"start_no\":\"1\",\"min_digit\":\"4\"},\"theme\":\"lux\",\"is_enabled_draft_submit\":0},\"additional_js_css\":{\"js\":null,\"css\":null},\"conditional_fields\":[{\"action\":null,\"element\":null,\"conditions\":[{\"condition\":null,\"value\":null,\"element_type\":\"text\",\"element_index\":null,\"operator\":\"==\"}]}],\"form_attributes\":[]}', '{\"is_enable\":false,\"api_key\":null,\"list_id\":null,\"email_field\":null,\"name_field\":null}', 1, 0, 1, 0, '2020-07-28 13:32:42', '2020-07-28 13:32:42'), ('ab0e7000-01b4-49ac-9af0-aacc112c8419', 'Test Contact form 1', 'test-contact-form-1-lcj', NULL, '{\"form\":[{\"id\":5,\"name\":\"field_6\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"h1\",\"text_color\":\"#ee301d\",\"content\":\"Contact us\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[]},{\"id\":6,\"name\":\"field_7\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"p\",\"text_color\":\"#343637\",\"content\":\"Fill out the form below and we will contact you soon.\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[]},{\"id\":0,\"name\":\"field_1\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Name\",\"help_text\":null,\"prefix_icon\":\"fa-user\",\"suffix_icon\":\"none\",\"placeholder\":\"Enter your name\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":1,\"name\":\"field_2\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"email\",\"label\":\"Email\",\"help_text\":null,\"prefix_icon\":\"fa-envelope\",\"suffix_icon\":\"none\",\"placeholder\":\"Email to contact you\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[{\"rule\":\"email\",\"error_msg\":\"Please provide a valid email\"}],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":3,\"name\":\"field_4\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Phone No.\",\"help_text\":null,\"prefix_icon\":\"fa-phone\",\"suffix_icon\":\"none\",\"placeholder\":\"Phone number to contact you\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":2,\"name\":\"field_3\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Subject\",\"help_text\":null,\"prefix_icon\":\"fa-question\",\"suffix_icon\":\"none\",\"placeholder\":null,\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":4,\"name\":\"field_5\",\"extras\":{\"showConfigurator\":false},\"type\":\"textarea\",\"label\":\"Body\",\"help_text\":null,\"prefix_icon\":\"none\",\"suffix_icon\":\"none\",\"rows\":\"7\",\"columns\":null,\"placeholder\":null,\"custom_class\":null,\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"}],\"emailConfig\":{\"email\":{\"from\":\"admin@admin.com\",\"to\":\"admin@admin.com\",\"cc\":null,\"bcc\":null,\"subject\":\"New contact from __field_1__\",\"body\":\"New contact form submission:\\n\\nName: __field_1__\\nEmail: __field_2__\\nPhone No.: __field_4__\\nSubject: __field_3__\\nBody: __field_5__\\n\\n--------------------------\\nSend via contact form\"},\"auto_response\":{\"from\":\"admin@online.mw\",\"to\":\"field_2\",\"subject\":\"Form __field_3__\",\"body\":\"

__field_1__ <\\/p>

__field_3__ <\\/p>

__field_4__ <\\/p>

__field_2__ <\\/p>

__field_5__ <\\/p>


<\\/p>

__submission_ref__
<\\/p>\",\"is_enable\":true,\"attach_pdf\":true},\"smtp\":{\"host\":null,\"port\":null,\"from_address\":null,\"from_name\":null,\"encryption\":null,\"username\":null,\"password\":null,\"use_system_smtp\":1}},\"settings\":{\"recaptcha\":{\"is_enable\":0,\"site_key\":null,\"secret_key\":null},\"color\":{\"label\":\"#000000\",\"error_msg\":\"#a94442\",\"required_asterisk_color\":\"#a94442\",\"background\":\"#ffffff\",\"image_path\":null,\"page_color\":\"#f4f6f9\"},\"notification\":{\"post_submit_action\":\"same_page\",\"failed_msg\":\"Something went wrong, please try again.\",\"success_msg\":\"Email sent successfully.\",\"redirect_url\":\"http:\\/\\/thewebfosters.com\\/\",\"position\":\"toast-top-right\"},\"submit\":{\"text\":\"Submit\",\"loading_text\":\"Submitting...\",\"btn_alignment\":\"float-right\",\"btn_size\":null,\"btn_color\":\"btn-outline-primary\",\"btn_style\":\"outline\",\"btn_icon\":\"fa-share\",\"icon_position\":\"right\"},\"form_data\":{\"col_visible\":[\"field_1\",\"field_2\",\"field_4\",\"field_3\"],\"btn_enabled\":[\"view\"]},\"background\":{\"bg_type\":\"bg_color\"},\"form_scheduling\":{\"closed_msg\":\"The form has been closed now!\",\"start_date_time\":null,\"end_date_time\":null,\"is_enabled\":false},\"form_submision_ref\":{\"is_enabled\":true,\"prefix\":\"#onl\",\"suffix\":null,\"start_no\":\"1\",\"min_digit\":\"4\"},\"theme\":\"materia\",\"is_enabled_draft_submit\":true,\"password_protection\":{\"is_enabled\":false,\"password\":null},\"pdf_design\":{\"header\":\"

{form_name}<\\/span><\\/span><\\/span><\\/h1>


<\\/span><\\/span>{submission_date}<\\/span><\\/sub><\\/span><\\/h1>\"}},\"additional_js_css\":{\"js\":null,\"css\":null},\"conditional_fields\":[{\"action\":null,\"element\":null,\"conditions\":[{\"condition\":null,\"value\":null,\"element_type\":\"text\",\"element_index\":null,\"operator\":\"==\"}]}],\"form_attributes\":[]}', '{\"is_enable\":false,\"api_key\":null,\"list_id\":null,\"email_field\":null,\"name_field\":null}', 0, 0, 1, 5, '2022-02-21 16:09:11', '2022-02-21 16:33:21'), ('b111b35b-a8bb-47fc-af34-e5a02b2a7add', 'Event registration form', 'event-registration-form-1hv', 'Event registration form, can be used for hackthon or webinar invitation', '{\"form\":[{\"id\":5,\"name\":\"field_6\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"h1\",\"text_color\":\"#ee301d\",\"content\":\"Event registration\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":6,\"name\":\"field_7\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"p\",\"text_color\":\"#343637\",\"content\":\"Register by providing the details below,the theme here used is lumen.\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[]},{\"id\":0,\"name\":\"field_1\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Name\",\"help_text\":null,\"prefix_icon\":\"fa-user\",\"suffix_icon\":\"none\",\"placeholder\":\"Enter your name\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-6\",\"custom_attributes\":[]},{\"id\":1,\"name\":\"field_2\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"email\",\"label\":\"Email\",\"help_text\":null,\"prefix_icon\":\"fa-envelope\",\"suffix_icon\":\"none\",\"placeholder\":\"Email to contact you\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[{\"rule\":\"email\",\"error_msg\":\"Please provide a valid email\"}],\"conditional_class\":null,\"col\":\"col-md-6\",\"custom_attributes\":[]},{\"id\":15,\"name\":\"field_16\",\"extras\":{\"showConfigurator\":false},\"type\":\"radio\",\"label\":\"Gender\",\"help_text\":null,\"options\":\"Male\\nFemale\\nOther\",\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[],\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[]},{\"id\":3,\"name\":\"field_4\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Phone No.\",\"help_text\":null,\"prefix_icon\":\"fa-phone\",\"suffix_icon\":\"none\",\"placeholder\":\"Phone number to contact you\",\"size\":null,\"custom_class\":null,\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":13,\"name\":\"field_14\",\"extras\":{\"showConfigurator\":false},\"type\":\"radio\",\"label\":\"Which Event?\",\"help_text\":null,\"options\":\"Innovathon-Innovating Hackathon\\nHackerTech Hackathon\\nWebinar on Flutter dev\\nWebinar On TDD Using Jest\",\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[]},{\"id\":14,\"name\":\"field_15\",\"extras\":{\"showConfigurator\":false},\"type\":\"file_upload\",\"label\":\"Verification Documents\",\"help_text\":\"Provide us the document to verify (passport or any other government identify proof)\",\"upload_text\":\"Drop a file here (Max 1 MB)\",\"no_of_files\":\"1\",\"send_as_email_attachment\":true,\"file_size_limit\":\"1\",\"file_type\":\"all\",\"allowed_file_type\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":16,\"name\":\"field_17\",\"extras\":{\"showConfigurator\":false},\"type\":\"signature\",\"label\":\"Signature\",\"col\":\"col-md-12\",\"html_text\":null,\"custom_class\":null,\"custom_attributes\":[],\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null}],\"emailConfig\":{\"email\":{\"from\":\"admin@admin.com\",\"to\":\"admin@admin.com\",\"cc\":null,\"bcc\":null,\"subject\":\"New registration details: __field_1__\",\"body\":\"New Registration:\\n\\nName: __field_1__\\nEmail: __field_2__\\nPhone no.: __field_4__\\nEvent: __field_14__\"},\"auto_response\":{\"from\":null,\"to\":null,\"subject\":null,\"body\":null,\"is_enable\":false},\"smtp\":{\"host\":null,\"port\":null,\"from_address\":null,\"from_name\":null,\"encryption\":null,\"username\":null,\"password\":null,\"use_system_smtp\":1}},\"settings\":{\"recaptcha\":{\"is_enable\":0,\"site_key\":null,\"secret_key\":null},\"color\":{\"label\":\"#000000\",\"error_msg\":\"#a94442\",\"required_asterisk_color\":\"#a94442\",\"background\":\"#ffffff\",\"image_path\":null},\"notification\":{\"post_submit_action\":\"same_page\",\"failed_msg\":\"Something went wrong, please try again.\",\"success_msg\":\"Email sent successfully.\",\"redirect_url\":null,\"position\":\"toast-top-right\"},\"submit\":{\"text\":\"Submit\",\"loading_text\":\"Submitting...\",\"btn_alignment\":\"float-right\",\"btn_size\":null,\"btn_color\":\"btn-primary\",\"btn_style\":\"default\",\"btn_icon\":\"none\",\"icon_position\":\"left\"},\"form_data\":{\"col_visible\":[\"field_1\",\"field_2\",\"field_14\",\"field_15\",\"field_16\",\"field_17\",\"field_18\"],\"btn_enabled\":[\"view\",\"delete\"]},\"background\":{\"bg_type\":\"bg_color\"},\"form_scheduling\":{\"closed_msg\":\"The form has been closed now!\",\"start_date_time\":null,\"end_date_time\":null,\"is_enabled\":false},\"form_submision_ref\":{\"is_enabled\":false,\"prefix\":null,\"suffix\":null,\"start_no\":\"1\",\"min_digit\":\"4\"},\"theme\":\"lumen\",\"is_enabled_draft_submit\":0},\"additional_js_css\":{\"js\":null,\"css\":null},\"conditional_fields\":[{\"action\":null,\"element\":null,\"conditions\":[{\"condition\":null,\"value\":null,\"element_type\":\"text\",\"element_index\":null,\"operator\":\"==\"}]}],\"form_attributes\":[]}', '{\"is_enable\":false,\"api_key\":null,\"list_id\":null,\"email_field\":null,\"name_field\":null}', 0, 0, 1, 0, '2020-07-28 13:32:42', '2020-07-28 13:32:42'), ('b111b35b-a8bb-47fc-zds1-e5a02b2a732s', 'Event registration form', 'event-registration-form-1hv', 'Event registration form, can be used for hackathon or webinar invitation', '{\"form\":[{\"id\":5,\"name\":\"field_6\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"h1\",\"text_color\":\"#ee301d\",\"content\":\"Event registration\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":6,\"name\":\"field_7\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"p\",\"text_color\":\"#343637\",\"content\":\"Register by providing the details below.\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[]},{\"id\":0,\"name\":\"field_1\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Name\",\"help_text\":null,\"prefix_icon\":\"fa-user\",\"suffix_icon\":\"none\",\"placeholder\":\"Enter your name\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-6\",\"custom_attributes\":[]},{\"id\":1,\"name\":\"field_2\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"email\",\"label\":\"Email\",\"help_text\":null,\"prefix_icon\":\"fa-envelope\",\"suffix_icon\":\"none\",\"placeholder\":\"Email to contact you\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[{\"rule\":\"email\",\"error_msg\":\"Please provide a valid email\"}],\"conditional_class\":null,\"col\":\"col-md-6\",\"custom_attributes\":[]},{\"id\":15,\"name\":\"field_16\",\"extras\":{\"showConfigurator\":false},\"type\":\"radio\",\"label\":\"Gender\",\"help_text\":null,\"options\":\"Male\\nFemale\\nOther\",\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[],\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[]},{\"id\":3,\"name\":\"field_4\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Phone No.\",\"help_text\":null,\"prefix_icon\":\"fa-phone\",\"suffix_icon\":\"none\",\"placeholder\":\"Phone number to contact you\",\"size\":null,\"custom_class\":null,\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":13,\"name\":\"field_14\",\"extras\":{\"showConfigurator\":false},\"type\":\"radio\",\"label\":\"Which Event?\",\"help_text\":null,\"options\":\"Innovathon-Innovating Hackathon\\nHackerTech Hackathon\\nWebinar on Flutter dev\\nWebinar On TDD Using Jest\",\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[]},{\"id\":14,\"name\":\"field_15\",\"extras\":{\"showConfigurator\":false},\"type\":\"file_upload\",\"label\":\"Verification Documents\",\"help_text\":\"Provide us the document to verify (passport or any other government identify proof)\",\"upload_text\":\"Drop a file here (Max 1 MB)\",\"no_of_files\":\"1\",\"send_as_email_attachment\":true,\"file_size_limit\":\"1\",\"file_type\":\"all\",\"allowed_file_type\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":16,\"name\":\"field_17\",\"extras\":{\"showConfigurator\":false},\"type\":\"signature\",\"label\":\"Signature\",\"col\":\"col-md-12\",\"html_text\":null,\"custom_class\":null,\"custom_attributes\":[],\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null}],\"emailConfig\":{\"email\":{\"from\":\"admin@admin.com\",\"to\":\"admin@admin.com\",\"cc\":null,\"bcc\":null,\"subject\":\"New registration details: __field_1__\",\"body\":\"New Registration:\\n\\nName: __field_1__\\nEmail: __field_2__\\nPhone no.: __field_4__\\nEvent: __field_14__\"},\"auto_response\":{\"from\":null,\"to\":null,\"subject\":null,\"body\":null,\"is_enable\":false},\"smtp\":{\"host\":null,\"port\":null,\"from_address\":null,\"from_name\":null,\"encryption\":null,\"username\":null,\"password\":null,\"use_system_smtp\":1}},\"settings\":{\"recaptcha\":{\"is_enable\":0,\"site_key\":null,\"secret_key\":null},\"color\":{\"label\":\"#000000\",\"error_msg\":\"#a94442\",\"required_asterisk_color\":\"#a94442\",\"background\":\"#ffffff\",\"image_path\":null},\"notification\":{\"post_submit_action\":\"same_page\",\"failed_msg\":\"Something went wrong, please try again.\",\"success_msg\":\"Email sent successfully.\",\"redirect_url\":null,\"position\":\"toast-top-right\"},\"submit\":{\"text\":\"Submit\",\"loading_text\":\"Submitting...\",\"btn_alignment\":\"float-right\",\"btn_size\":null,\"btn_color\":\"btn-primary\",\"btn_style\":\"default\",\"btn_icon\":\"none\",\"icon_position\":\"left\"},\"form_data\":{\"col_visible\":[\"field_1\",\"field_2\",\"field_14\",\"field_15\",\"field_16\",\"field_17\",\"field_18\"],\"btn_enabled\":[\"view\",\"delete\"]},\"background\":{\"bg_type\":\"bg_color\"},\"form_scheduling\":{\"closed_msg\":\"The form has been closed now!\",\"start_date_time\":null,\"end_date_time\":null,\"is_enabled\":false},\"form_submision_ref\":{\"is_enabled\":false,\"prefix\":null,\"suffix\":null,\"start_no\":\"1\",\"min_digit\":\"4\"},\"theme\":\"lumen\",\"is_enabled_draft_submit\":0},\"additional_js_css\":{\"js\":null,\"css\":null},\"conditional_fields\":[{\"action\":null,\"element\":null,\"conditions\":[{\"condition\":null,\"value\":null,\"element_type\":\"text\",\"element_index\":null,\"operator\":\"==\"}]}],\"form_attributes\":[]}', '{\"is_enable\":false,\"api_key\":null,\"list_id\":null,\"email_field\":null,\"name_field\":null}', 1, 0, 1, 0, '2020-07-28 13:32:42', '2020-07-28 13:32:42'), ('c4b9f308-d5ee-4ea6-a918-f2f94f0816ef', 'Contact form with \'sketchy\' theme', 'contact-form-with-sketchy-theme-i41', 'Simple form with name, contact, subject & body.', '{\"form\":[{\"id\":5,\"name\":\"field_6\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"h1\",\"text_color\":\"#ee301d\",\"content\":\"Contact us\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":6,\"name\":\"field_7\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"p\",\"text_color\":\"#343637\",\"content\":\"Fill out the form below and we will contact you soon, the theme here used is \\\"Sketchy\\\".\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[]},{\"id\":0,\"name\":\"field_1\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Name\",\"help_text\":null,\"prefix_icon\":\"fa-user\",\"suffix_icon\":\"none\",\"placeholder\":\"Enter your name\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-6\",\"custom_attributes\":[{\"key\":\"aria-label\",\"value\":\"name\"}]},{\"id\":1,\"name\":\"field_2\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"email\",\"label\":\"Email\",\"help_text\":null,\"prefix_icon\":\"fa-envelope\",\"suffix_icon\":\"none\",\"placeholder\":\"Email to contact you\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[{\"rule\":\"email\",\"error_msg\":\"Please provide a valid email\"}],\"conditional_class\":null,\"col\":\"col-md-6\",\"custom_attributes\":[{\"key\":\"aria-label\",\"value\":\"email\"},{\"key\":\"role\",\"value\":\"email\"}]},{\"id\":3,\"name\":\"field_4\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Phone No.\",\"help_text\":null,\"prefix_icon\":\"fa-phone\",\"suffix_icon\":\"none\",\"placeholder\":\"Phone number to contact you\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":2,\"name\":\"field_3\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Subject\",\"help_text\":null,\"prefix_icon\":\"fa-question\",\"suffix_icon\":\"none\",\"placeholder\":null,\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":4,\"name\":\"field_5\",\"extras\":{\"showConfigurator\":false},\"type\":\"textarea\",\"label\":\"Body\",\"help_text\":null,\"prefix_icon\":\"none\",\"suffix_icon\":\"none\",\"rows\":\"7\",\"columns\":null,\"placeholder\":null,\"custom_class\":null,\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"}],\"emailConfig\":{\"email\":{\"from\":\"admin@admin.com\",\"to\":\"admin@admin.com\",\"cc\":null,\"bcc\":null,\"subject\":\"New contact from __field_1__\",\"body\":\"New contact form submission:\\n\\nName: __field_1__\\nEmail: __field_2__\\nPhone No.: __field_4__\\nSubject: __field_3__\\nBody: __field_5__\\n\\n--------------------------\\nSend via contact form\"},\"auto_response\":{\"from\":null,\"to\":null,\"subject\":null,\"body\":null,\"is_enable\":false},\"smtp\":{\"host\":null,\"port\":null,\"from_address\":null,\"from_name\":null,\"encryption\":null,\"username\":null,\"password\":null,\"use_system_smtp\":1}},\"settings\":{\"recaptcha\":{\"is_enable\":0,\"site_key\":null,\"secret_key\":null},\"color\":{\"label\":\"#000000\",\"error_msg\":\"#a94442\",\"required_asterisk_color\":\"#a94442\",\"background\":\"#ffffff\",\"image_path\":null},\"notification\":{\"post_submit_action\":\"same_page\",\"failed_msg\":\"Something went wrong, please try again.\",\"success_msg\":\"Email sent successfully.\",\"redirect_url\":null,\"position\":\"toast-top-right\"},\"submit\":{\"text\":\"Submit\",\"loading_text\":\"Submitting...\",\"btn_alignment\":\"float-right\",\"btn_size\":null,\"btn_color\":\"btn-primary\",\"btn_style\":\"default\",\"btn_icon\":\"none\",\"icon_position\":\"left\"},\"form_data\":{\"col_visible\":[\"field_1\",\"field_2\",\"field_3\",\"field_5\",\"field_8\",\"field_9\"],\"btn_enabled\":[\"view\",\"delete\"]},\"background\":{\"bg_type\":\"bg_color\"},\"form_scheduling\":{\"closed_msg\":\"The form has been closed now!\",\"start_date_time\":null,\"end_date_time\":null,\"is_enabled\":false},\"form_submision_ref\":{\"is_enabled\":false,\"prefix\":null,\"suffix\":null,\"start_no\":\"1\",\"min_digit\":\"4\"},\"theme\":\"sketchy\",\"is_enabled_draft_submit\":0},\"additional_js_css\":{\"js\":null,\"css\":null},\"conditional_fields\":[{\"action\":null,\"element\":null,\"conditions\":[{\"condition\":null,\"value\":null,\"element_type\":\"text\",\"element_index\":null,\"operator\":\"==\"}]}],\"form_attributes\":[{\"key\":\"role\",\"value\":\"form\"},{\"key\":\"aria-label\",\"value\":\"contact-info\"}]}', '{\"is_enable\":false,\"api_key\":null,\"list_id\":null,\"email_field\":null,\"name_field\":null}', 0, 0, 1, 0, '2020-07-28 13:32:42', '2020-07-28 14:57:42'); INSERT INTO `forms` (`id`, `name`, `slug`, `description`, `schema`, `mailchimp_details`, `is_template`, `is_global_template`, `created_by`, `submission_count`, `created_at`, `updated_at`) VALUES ('e2fd806b-91e0-4235-23xz-10b1b80ce879', 'Feedback form', 'feedback-form-goa', 'Simple feedback form for your company', '{\"form\":[{\"id\":5,\"name\":\"field_6\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"h1\",\"text_color\":\"#ee301d\",\"content\":\"Feedback Form\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":6,\"name\":\"field_7\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"p\",\"text_color\":\"#343637\",\"content\":\"Provide your feedback in the below form.\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[]},{\"id\":0,\"name\":\"field_1\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Name\",\"help_text\":null,\"prefix_icon\":\"fa-user\",\"suffix_icon\":\"none\",\"placeholder\":\"Enter your name\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-4\",\"custom_attributes\":[]},{\"id\":1,\"name\":\"field_2\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"email\",\"label\":\"Email\",\"help_text\":null,\"prefix_icon\":\"fa-envelope\",\"suffix_icon\":\"none\",\"placeholder\":\"Email to contact you\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[{\"rule\":\"email\",\"error_msg\":\"Please provide a valid email\"}],\"conditional_class\":null,\"col\":\"col-md-4\",\"custom_attributes\":[]},{\"id\":3,\"name\":\"field_4\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Phone No.\",\"help_text\":null,\"prefix_icon\":\"fa-phone\",\"suffix_icon\":\"none\",\"placeholder\":\"Phone number to contact you\",\"size\":null,\"custom_class\":null,\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-4\",\"custom_attributes\":[]},{\"id\":7,\"name\":\"field_8\",\"extras\":{\"showConfigurator\":false},\"type\":\"textarea\",\"label\":\"Office address\",\"help_text\":null,\"prefix_icon\":\"fa-globe\",\"suffix_icon\":\"none\",\"rows\":3,\"columns\":null,\"placeholder\":\"Provide Street, Landmark, State, Postal Code, Country\",\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":8,\"name\":\"field_9\",\"extras\":{\"showConfigurator\":false},\"type\":\"dropdown\",\"label\":\"How did you hear about us?\",\"help_text\":null,\"prefix_icon\":\"fa-bullhorn\",\"suffix_icon\":\"none\",\"options\":\"Newspaper\\nInternet\\nMagazine\\nFacebook\\nTwitter\\nLinkedIn\",\"size\":null,\"custom_class\":null,\"multiselect\":false,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":11,\"name\":\"field_12\",\"extras\":{\"showConfigurator\":false},\"type\":\"rating\",\"label\":\"Rate us\",\"conditional_class\":null,\"stars_to_display\":5,\"min_rating\":0,\"max_rating\":5,\"increment\":0.5,\"direction\":\"ltr\",\"size\":\"md\",\"col\":\"col-md-12\",\"custom_attributes\":[],\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[]},{\"id\":4,\"name\":\"field_5\",\"extras\":{\"showConfigurator\":false},\"type\":\"textarea\",\"label\":\"Feedback about us:\",\"help_text\":null,\"prefix_icon\":\"none\",\"suffix_icon\":\"none\",\"rows\":\"4\",\"columns\":null,\"placeholder\":null,\"custom_class\":null,\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":9,\"name\":\"field_10\",\"extras\":{\"showConfigurator\":false},\"type\":\"textarea\",\"label\":\"Suggestions if any for further improvement:\",\"help_text\":null,\"prefix_icon\":\"none\",\"suffix_icon\":\"none\",\"rows\":3,\"columns\":null,\"placeholder\":null,\"custom_class\":null,\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":10,\"name\":\"field_11\",\"extras\":{\"showConfigurator\":false},\"type\":\"radio\",\"label\":\"Will you be willing to recommend us?\",\"help_text\":null,\"options\":\"Yes\\nNo\\nMaybe\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"}],\"emailConfig\":{\"email\":{\"from\":\"admin@admin.com\",\"to\":\"admin@admin.com\",\"cc\":null,\"bcc\":null,\"subject\":\"New Feedback from __field_1__\",\"body\":\"New Feedback:\\n\\nName: __field_1__\\nEmail: __field_2__\\nOffice address: __field_8__\\nHow did you hear about us?: __field_9__\\nFeedback: __field_5__\\nSuggestion: __field_10__\\nWill you recommend?: __field_11__\\n\\n--------------------------\\nSend via feedback form\"},\"auto_response\":{\"from\":null,\"to\":null,\"subject\":null,\"body\":null,\"is_enable\":false},\"smtp\":{\"host\":null,\"port\":null,\"from_address\":null,\"from_name\":null,\"encryption\":null,\"username\":null,\"password\":null,\"use_system_smtp\":1}},\"settings\":{\"recaptcha\":{\"is_enable\":0,\"site_key\":null,\"secret_key\":null},\"color\":{\"label\":\"#000000\",\"error_msg\":\"#a94442\",\"required_asterisk_color\":\"#a94442\",\"background\":\"#ffffff\",\"image_path\":null},\"notification\":{\"post_submit_action\":\"same_page\",\"failed_msg\":\"Something went wrong, please try again.\",\"success_msg\":\"Email sent successfully.\",\"redirect_url\":null,\"position\":\"toast-top-right\"},\"submit\":{\"text\":\"Submit\",\"loading_text\":\"Submitting...\",\"btn_alignment\":\"float-right\",\"btn_size\":null,\"btn_color\":\"btn-primary\",\"btn_style\":\"default\",\"btn_icon\":\"none\",\"icon_position\":\"left\"},\"form_data\":{\"col_visible\":[\"field_1\",\"field_2\",\"field_8\",\"field_9\",\"field_5\",\"field_10\",\"field_11\",\"field_12\"],\"btn_enabled\":[\"view\",\"delete\"]},\"background\":{\"bg_type\":\"bg_color\"},\"form_scheduling\":{\"closed_msg\":\"The form has been closed now!\",\"start_date_time\":null,\"end_date_time\":null,\"is_enabled\":false},\"form_submision_ref\":{\"is_enabled\":false,\"prefix\":null,\"suffix\":null,\"start_no\":\"1\",\"min_digit\":\"4\"},\"theme\":\"flatly\",\"is_enabled_draft_submit\":0},\"additional_js_css\":{\"js\":null,\"css\":null},\"conditional_fields\":[{\"action\":null,\"element\":null,\"conditions\":[{\"condition\":null,\"value\":null,\"element_type\":\"text\",\"element_index\":null,\"operator\":\"==\"}]}],\"form_attributes\":[]}', '{\"is_enable\":false,\"api_key\":null,\"list_id\":null,\"email_field\":null,\"name_field\":null}', 1, 0, 1, 0, '2020-07-28 13:32:42', '2020-07-28 13:32:42'), ('e2fd806b-91e0-4235-8973-10b1b80ce879', 'Feedback form', '', 'Simple feedback form for your company', '{\"form\":[{\"id\":5,\"name\":\"field_6\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"h1\",\"text_color\":\"#ee301d\",\"content\":\"Feedback form\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[]},{\"id\":6,\"name\":\"field_7\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"p\",\"text_color\":\"#343637\",\"content\":\"Provide your feedback in the below form, the theme used here is \'flatly\'.\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[]},{\"id\":0,\"name\":\"field_1\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Name\",\"help_text\":null,\"prefix_icon\":\"fa-user\",\"suffix_icon\":\"none\",\"placeholder\":\"Enter your name\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-4\",\"custom_attributes\":[]},{\"id\":1,\"name\":\"field_2\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"email\",\"label\":\"Email\",\"help_text\":null,\"prefix_icon\":\"fa-envelope\",\"suffix_icon\":\"none\",\"placeholder\":\"Email to contact you\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[{\"rule\":\"email\",\"error_msg\":\"Please provide a valid email\"}],\"conditional_class\":null,\"col\":\"col-md-4\",\"custom_attributes\":[]},{\"id\":3,\"name\":\"field_4\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Phone No.\",\"help_text\":null,\"prefix_icon\":\"fa-phone\",\"suffix_icon\":\"none\",\"placeholder\":\"Phone number to contact you\",\"size\":null,\"custom_class\":null,\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-4\",\"custom_attributes\":[]},{\"id\":7,\"name\":\"field_8\",\"extras\":{\"showConfigurator\":false},\"type\":\"textarea\",\"label\":\"Office address\",\"help_text\":null,\"prefix_icon\":\"fa-globe\",\"suffix_icon\":\"none\",\"rows\":3,\"columns\":null,\"placeholder\":\"Provide Street, Landmark, State, Postal Code, Country\",\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":8,\"name\":\"field_9\",\"extras\":{\"showConfigurator\":false},\"type\":\"dropdown\",\"label\":\"How did you hear about us?\",\"help_text\":null,\"prefix_icon\":\"fa-bullhorn\",\"suffix_icon\":\"none\",\"options\":\"Newspaper\\nInternet\\nMagazine\\nFacebook\\nTwitter\\nLinkedIn\",\"size\":null,\"custom_class\":null,\"multiselect\":false,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":11,\"name\":\"field_12\",\"extras\":{\"showConfigurator\":false},\"type\":\"rating\",\"label\":\"Rate us\",\"conditional_class\":null,\"stars_to_display\":5,\"min_rating\":0,\"max_rating\":5,\"increment\":0.5,\"direction\":\"ltr\",\"size\":\"md\",\"col\":\"col-md-12\",\"custom_attributes\":[],\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[]},{\"id\":4,\"name\":\"field_5\",\"extras\":{\"showConfigurator\":false},\"type\":\"textarea\",\"label\":\"Feedback about us:\",\"help_text\":null,\"prefix_icon\":\"none\",\"suffix_icon\":\"none\",\"rows\":\"4\",\"columns\":null,\"placeholder\":null,\"custom_class\":null,\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":9,\"name\":\"field_10\",\"extras\":{\"showConfigurator\":false},\"type\":\"textarea\",\"label\":\"Suggestions if any for further improvement:\",\"help_text\":null,\"prefix_icon\":\"none\",\"suffix_icon\":\"none\",\"rows\":3,\"columns\":null,\"placeholder\":null,\"custom_class\":null,\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":10,\"name\":\"field_11\",\"extras\":{\"showConfigurator\":false},\"type\":\"radio\",\"label\":\"Will you be willing to recommend us?\",\"help_text\":null,\"options\":\"Yes\\nNo\\nMaybe\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"}],\"emailConfig\":{\"email\":{\"from\":\"admin@admin.com\",\"to\":\"admin@admin.com\",\"cc\":null,\"bcc\":null,\"subject\":\"New Feedback from __field_1__\",\"body\":\"New Feedback:\\n\\nName: __field_1__\\nEmail: __field_2__\\nOffice address: __field_8__\\nHow did you hear about us?: __field_9__\\nFeedback: __field_5__\\nSuggestion: __field_10__\\nWill you recommend?: __field_11__\\n\\n--------------------------\\nSend via feedback form\"},\"auto_response\":{\"from\":null,\"to\":null,\"subject\":null,\"body\":null,\"is_enable\":false},\"smtp\":{\"host\":null,\"port\":null,\"from_address\":null,\"from_name\":null,\"encryption\":null,\"username\":null,\"password\":null,\"use_system_smtp\":1}},\"settings\":{\"recaptcha\":{\"is_enable\":0,\"site_key\":null,\"secret_key\":null},\"color\":{\"label\":\"#000000\",\"error_msg\":\"#a94442\",\"required_asterisk_color\":\"#a94442\",\"background\":\"#ffffff\",\"image_path\":null},\"notification\":{\"post_submit_action\":\"same_page\",\"failed_msg\":\"Something went wrong, please try again.\",\"success_msg\":\"Email sent successfully.\",\"redirect_url\":null,\"position\":\"toast-top-right\"},\"submit\":{\"text\":\"Submit\",\"loading_text\":\"Submitting...\",\"btn_alignment\":\"float-right\",\"btn_size\":null,\"btn_color\":\"btn-primary\",\"btn_style\":\"default\",\"btn_icon\":\"none\",\"icon_position\":\"left\"},\"form_data\":{\"col_visible\":[\"field_1\",\"field_2\",\"field_8\",\"field_9\",\"field_5\",\"field_10\",\"field_11\",\"field_12\"],\"btn_enabled\":[\"view\",\"delete\"]},\"background\":{\"bg_type\":\"bg_color\"},\"form_scheduling\":{\"closed_msg\":\"The form has been closed now!\",\"start_date_time\":null,\"end_date_time\":null,\"is_enabled\":false},\"form_submision_ref\":{\"is_enabled\":false,\"prefix\":null,\"suffix\":null,\"start_no\":\"1\",\"min_digit\":\"4\"},\"theme\":\"flatly\",\"is_enabled_draft_submit\":0},\"additional_js_css\":{\"js\":null,\"css\":null},\"conditional_fields\":[{\"action\":null,\"element\":null,\"conditions\":[{\"condition\":null,\"value\":null,\"element_type\":\"text\",\"element_index\":null,\"operator\":\"==\"}]}],\"form_attributes\":[]}', '{\"is_enable\":false,\"api_key\":null,\"list_id\":null,\"email_field\":null,\"name_field\":null}', 0, 0, 1, 0, '2020-07-28 13:21:55', '2020-07-28 14:23:16'), ('e5ea46f9-40ee-471d-b3de-75e163475f6e', 'Contact form with \'litera\' theme', 'contact-form-with-litera-theme-pmz', 'Simple form with name, contact, subject & body.', '{\"form\":[{\"id\":5,\"name\":\"field_6\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"h1\",\"text_color\":\"#ee301d\",\"content\":\"Contact us\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":6,\"name\":\"field_7\",\"extras\":{\"showConfigurator\":false},\"type\":\"heading\",\"label\":\"Heading\\/Paragraph\",\"tag\":\"p\",\"text_color\":\"#343637\",\"content\":\"Fill out the form below and we will contact you soon, \'litera\' theme is used here with background color.\",\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[]},{\"id\":0,\"name\":\"field_1\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Name\",\"help_text\":null,\"prefix_icon\":\"fa-user\",\"suffix_icon\":\"none\",\"placeholder\":\"Enter your name\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":7,\"name\":\"field_8\",\"extras\":{\"showConfigurator\":false},\"type\":\"radio\",\"label\":\"Gender\",\"help_text\":null,\"options\":\"Male\\nFemale\\nOther\",\"conditional_class\":null,\"col\":\"col-md-12\",\"custom_attributes\":[],\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[]},{\"id\":1,\"name\":\"field_2\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"email\",\"label\":\"Email\",\"help_text\":null,\"prefix_icon\":\"fa-envelope\",\"suffix_icon\":\"none\",\"placeholder\":\"Email to contact you\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[{\"rule\":\"email\",\"error_msg\":\"Please provide a valid email\"}],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":3,\"name\":\"field_4\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Phone No.\",\"help_text\":null,\"prefix_icon\":\"fa-phone\",\"suffix_icon\":\"none\",\"placeholder\":\"Phone number to contact you\",\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":2,\"name\":\"field_3\",\"extras\":{\"showConfigurator\":false},\"type\":\"text\",\"subtype\":\"text\",\"label\":\"Subject\",\"help_text\":null,\"prefix_icon\":\"fa-question\",\"suffix_icon\":\"none\",\"placeholder\":null,\"size\":null,\"custom_class\":null,\"required\":true,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"},{\"id\":4,\"name\":\"field_5\",\"extras\":{\"showConfigurator\":false},\"type\":\"textarea\",\"label\":\"Body\",\"help_text\":null,\"prefix_icon\":\"none\",\"suffix_icon\":\"none\",\"rows\":\"7\",\"columns\":null,\"placeholder\":null,\"custom_class\":null,\"required\":false,\"required_error_msg\":\"This field is required\",\"validations\":[],\"conditional_class\":null,\"col\":\"col-md-12\"}],\"emailConfig\":{\"email\":{\"from\":\"admin@admin.com\",\"to\":\"admin@admin.com\",\"cc\":null,\"bcc\":null,\"subject\":\"New contact from __field_1__\",\"body\":\"New contact form submission:\\n\\nName: __field_1__\\nEmail: __field_2__\\nPhone No.: __field_4__\\nSubject: __field_3__\\nBody: __field_5__\\n\\n--------------------------\\nSend via contact form\"},\"auto_response\":{\"from\":null,\"to\":null,\"subject\":null,\"body\":null,\"is_enable\":false},\"smtp\":{\"host\":null,\"port\":null,\"from_address\":null,\"from_name\":null,\"encryption\":null,\"username\":null,\"password\":null,\"use_system_smtp\":1}},\"settings\":{\"recaptcha\":{\"is_enable\":0,\"site_key\":null,\"secret_key\":null},\"color\":{\"label\":\"#000000\",\"error_msg\":\"#a94442\",\"required_asterisk_color\":\"#a94442\",\"background\":\"#cdeca7\",\"image_path\":null},\"notification\":{\"post_submit_action\":\"same_page\",\"failed_msg\":\"Something went wrong, please try again.\",\"success_msg\":\"Email sent successfully.\",\"redirect_url\":null,\"position\":\"toast-top-center\"},\"submit\":{\"text\":\"Submit\",\"loading_text\":\"Submitting...\",\"btn_alignment\":\"float-right\",\"btn_size\":null,\"btn_color\":\"btn-outline-success\",\"btn_style\":\"outline\",\"btn_icon\":\"fa-archive\",\"icon_position\":\"left\"},\"form_data\":{\"col_visible\":[\"field_1\",\"field_8\",\"field_2\",\"field_4\",\"field_3\",\"field_5\"],\"btn_enabled\":[\"view\",\"delete\"]},\"background\":{\"bg_type\":\"bg_color\"},\"form_scheduling\":{\"closed_msg\":\"The form has been closed now!\",\"start_date_time\":null,\"end_date_time\":null,\"is_enabled\":false},\"form_submision_ref\":{\"is_enabled\":false,\"prefix\":null,\"suffix\":null,\"start_no\":\"1\",\"min_digit\":\"4\"},\"theme\":\"litera\",\"is_enabled_draft_submit\":0},\"additional_js_css\":{\"js\":null,\"css\":null},\"conditional_fields\":[{\"action\":null,\"element\":null,\"conditions\":[{\"condition\":null,\"value\":null,\"element_type\":\"text\",\"element_index\":null,\"operator\":\"==\"}]}],\"form_attributes\":[]}', '{\"is_enable\":false,\"api_key\":null,\"list_id\":null,\"email_field\":null,\"name_field\":null}', 0, 0, 1, 0, '2020-07-28 11:45:59', '2020-07-28 14:57:10'); -- -------------------------------------------------------- -- -- Table structure for table `form_data` -- CREATE TABLE `form_data` ( `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL, `form_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL, `submission_ref` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `submitted_by` bigint(20) DEFAULT NULL, `data` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `source` char(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Source of form submittion', `status` enum('complete','incomplete') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'complete', `token` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `form_data` -- INSERT INTO `form_data` (`id`, `form_id`, `submission_ref`, `submitted_by`, `data`, `source`, `status`, `token`, `created_at`, `updated_at`) VALUES ('0c9c9cd6-cfe2-4679-a0f8-8990d81b34ac', 'ab0e7000-01b4-49ac-9af0-aacc112c8419', '#ref0001', 1, '{\"field_1\":\"San\",\"field_2\":\"sanjeewa@globemw.net\",\"field_4\":\"0888272544\",\"field_3\":\"subject1\",\"field_5\":\"body here\",\"status\":\"complete\",\"submission_ref\":\"#ref0001\"}', 'app', 'complete', NULL, '2022-02-21 16:11:11', '2022-02-21 16:11:21'), ('46fa80c7-d7a5-4835-acd7-22153dbfd261', 'ab0e7000-01b4-49ac-9af0-aacc112c8419', '#onl0005', 1, '{\"field_1\":\"dffd\",\"field_2\":\"sanjeewa@globemw.net\",\"field_4\":\"0888272544\",\"field_3\":\"sdadsa\",\"field_5\":\"dsdsad\",\"status\":\"complete\",\"submission_ref\":\"#onl0005\"}', 'app', 'complete', NULL, '2022-02-21 16:33:21', '2022-02-21 16:33:21'), ('7c318512-0bde-49d7-9778-ac035f91711c', 'ab0e7000-01b4-49ac-9af0-aacc112c8419', '#onl0002', 1, '{\"field_1\":\"dffd\",\"field_2\":\"sanjeewa@globemw.net\",\"field_4\":\"0888272544\",\"field_3\":\"sdadsa\",\"field_5\":\"dsdsad\",\"status\":\"complete\",\"submission_ref\":\"#onl0002\"}', 'app', 'complete', NULL, '2022-02-21 16:26:25', '2022-02-21 16:26:25'), ('b385824f-786d-41f0-8cd4-8049a42d8cde', 'ab0e7000-01b4-49ac-9af0-aacc112c8419', '#onl0004', 1, '{\"field_1\":\"dffd\",\"field_2\":\"sanjeewa@globemw.net\",\"field_4\":\"0888272544\",\"field_3\":\"sdadsa\",\"field_5\":\"dsdsad\",\"status\":\"complete\",\"submission_ref\":\"#onl0004\"}', 'app', 'complete', NULL, '2022-02-21 16:31:51', '2022-02-21 16:31:51'), ('da0baf87-b02b-4cbe-a0cd-999d2f3f3820', 'e2fd806b-91e0-4235-8973-10b1b80ce879', NULL, 2, '{\"field_1\":\"gggg\",\"field_2\":\"sss@ss.cc\",\"field_4\":\"\",\"field_8\":\"dsads\",\"field_9\":\"Internet\",\"field_12\":\"3\",\"field_5\":\"dsadsads\",\"field_10\":\"dsada\",\"field_11\":\"No\",\"status\":\"complete\"}', 'app', 'complete', NULL, '2022-02-21 12:34:57', '2022-02-21 12:34:57'), ('de5d15e8-aeca-4fa0-81e0-afb5250c48ed', 'ab0e7000-01b4-49ac-9af0-aacc112c8419', '#onl0003', 1, '{\"field_1\":\"dffd\",\"field_2\":\"sanjeewa@globemw.net\",\"field_4\":\"0888272544\",\"field_3\":\"sdadsa\",\"field_5\":\"dsdsad\",\"status\":\"complete\",\"submission_ref\":\"#onl0003\"}', 'app', 'complete', NULL, '2022-02-21 16:28:11', '2022-02-21 16:28:11'); -- -------------------------------------------------------- -- -- Table structure for table `form_data_comments` -- CREATE TABLE `form_data_comments` ( `id` bigint(20) UNSIGNED NOT NULL, `form_data_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint(20) NOT NULL, `comment` text COLLATE utf8mb4_unicode_ci NOT NULL, `score` int(11) DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `form_data_comments` -- INSERT INTO `form_data_comments` (`id`, `form_data_id`, `user_id`, `comment`, `score`, `created_at`, `updated_at`) VALUES (1, '7c318512-0bde-49d7-9778-ac035f91711c', 1, 'ddff', 0, '2022-02-21 16:36:56', '2022-02-21 16:36:56'), (2, '7c318512-0bde-49d7-9778-ac035f91711c', 1, 'cc3', 0, '2022-02-21 16:37:10', '2022-02-21 16:37:10'), (3, '0c9c9cd6-cfe2-4679-a0f8-8990d81b34ac', 1, 'sd', 2, '2022-02-21 16:55:09', '2022-02-21 16:55:09'), (4, '0c9c9cd6-cfe2-4679-a0f8-8990d81b34ac', 1, 'dsa', 3, '2022-02-21 17:02:17', '2022-02-21 17:02:17'), (5, '0c9c9cd6-cfe2-4679-a0f8-8990d81b34ac', 1, 'sdadsaddda', NULL, '2022-02-21 17:04:13', '2022-02-21 17:04:13'), (6, '0c9c9cd6-cfe2-4679-a0f8-8990d81b34ac', 2, 'dsadsadsa', 5, '2022-02-21 17:08:07', '2022-02-21 17:08:07'); -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '2014_10_12_000000_create_users_table', 1), (2, '2014_10_12_100000_create_password_resets_table', 1), (3, '2019_05_22_110831_create_forms_table', 1), (4, '2019_05_28_115307_create_form_data_table', 1), (5, '2019_06_25_074951_create_systems_table', 1), (6, '2019_06_27_074700_add_is_template_to_forms_table', 1), (7, '2019_07_29_111057_add_mailchimp_field_forms_table', 1), (8, '2019_09_13_082524_create_packages_table', 1), (9, '2019_09_16_052622_add_is_active_to_users_table', 1), (10, '2019_09_16_182039_create_user_settings_table', 1), (11, '2019_09_18_182206_create_package_subscriptions_table', 1), (12, '2019_12_20_110545_add_form_slug_to_forms_table', 1), (13, '2019_12_20_172319_add_submission_ref_to_form_data_table', 1), (14, '2020_07_20_095648_create_form_data_comments_table', 1), (15, '2020_07_23_111735_add_new_column_to_users_table', 1), (16, '2020_07_23_114633_create_user_forms_table', 1), (17, '2020_07_25_094400_create_visitors_table', 1), (18, '2021_12_09_155618_add_is_global_template_to_forms_table', 1), (19, '2022_02_21_184231_from-comment-add-score', 2), (20, '2022_02_21_203035_create_companies_table', 3); -- -------------------------------------------------------- -- -- Table structure for table `packages` -- CREATE TABLE `packages` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci NOT NULL, `no_of_active_forms` int(11) NOT NULL DEFAULT '0', `is_form_downloadable` tinyint(1) NOT NULL, `price_interval` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `interval` int(11) NOT NULL, `price` decimal(20,4) NOT NULL, `sort_order` int(11) NOT NULL DEFAULT '0', `is_active` tinyint(1) NOT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `packages` -- INSERT INTO `packages` (`id`, `name`, `description`, `no_of_active_forms`, `is_form_downloadable`, `price_interval`, `interval`, `price`, `sort_order`, `is_active`, `deleted_at`, `created_at`, `updated_at`) VALUES (1, 'Free', 'Free', 10, 1, 'months', 1, '0.0000', 1, 1, NULL, '2022-02-21 15:25:09', '2022-02-21 15:25:09'), (2, 'Admin Package', 'Admin', 0, 1, 'year', 1, '0.0000', 2, 1, NULL, '2022-02-21 15:25:48', '2022-02-21 15:25:48'); -- -------------------------------------------------------- -- -- Table structure for table `package_subscriptions` -- CREATE TABLE `package_subscriptions` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `package_id` bigint(20) UNSIGNED NOT NULL, `start_date` date NOT NULL, `end_date` date NOT NULL, `package_details` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `package_price` decimal(20,4) NOT NULL, `paid_via` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `payment_transaction_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` enum('approved','waiting','declined') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'waiting', `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `package_subscriptions` -- INSERT INTO `package_subscriptions` (`id`, `user_id`, `package_id`, `start_date`, `end_date`, `package_details`, `package_price`, `paid_via`, `payment_transaction_id`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES (3, 2, 1, '2022-02-21', '2022-03-21', '{\"name\":\"Free\",\"description\":\"Free\",\"no_of_active_forms\":10,\"is_form_downloadable\":1,\"price_interval\":\"months\",\"interval\":1}', '0.0000', NULL, 'FREE', 'approved', NULL, '2022-02-21 15:42:49', '2022-02-21 15:42:49'); -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `systems` -- CREATE TABLE `systems` ( `id` int(10) UNSIGNED NOT NULL, `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `value` text COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `systems` -- INSERT INTO `systems` (`id`, `key`, `value`) VALUES (1, 'version', '4.3'), (2, 'additional_js', ''), (3, 'additional_css', ''); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT '1', `can_create_form` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `is_active`, `can_create_form`, `created_at`, `updated_at`) VALUES (1, 'admin', 'admin@online.mw', NULL, '$2y$10$sAbmmFLLb1hw/fGSbmQ61O/nyQDB95iNJpKi0TIvNM1uNO6gZHZaS', NULL, 1, 1, '2022-02-21 11:56:08', '2022-02-21 12:06:14'), (2, 'sanjeewa', 'sanjeewa@globemw.net', NULL, '$2y$10$e7MiP1hV.I21BsSF.XBA2OEVJLBLe/Qwu2VnuXjZ90Quz5e3pTFWC', NULL, 1, 1, '2022-02-21 12:27:32', '2022-02-21 12:27:32'); -- -------------------------------------------------------- -- -- Table structure for table `user_forms` -- CREATE TABLE `user_forms` ( `id` bigint(20) UNSIGNED NOT NULL, `form_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL, `assigned_to` bigint(20) UNSIGNED NOT NULL, `assigned_by` bigint(20) UNSIGNED NOT NULL, `permissions` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `user_forms` -- INSERT INTO `user_forms` (`id`, `form_id`, `assigned_to`, `assigned_by`, `permissions`, `created_at`, `updated_at`) VALUES (1, '254525ab-e3b4-45f0-9d1e-24cf89fedwq1', 2, 1, '[\"can_view_data\",\"can_view_form\"]', '2022-02-21 12:27:32', '2022-02-21 12:27:32'), (2, '3984156b-e698-4e68-858d-1758002a3d14', 2, 1, '[\"can_view_data\",\"can_view_form\"]', '2022-02-21 12:27:32', '2022-02-21 12:27:32'), (3, '426ce4ff-1341-461d-b562-e855ce44lyn6', 2, 1, '[\"can_view_data\",\"can_view_form\"]', '2022-02-21 12:27:32', '2022-02-21 12:27:32'), (4, '6309c0a2-77ed-47aa-b0e2-81e5a4c048a0', 2, 1, '[\"can_view_data\",\"can_view_form\"]', '2022-02-21 12:27:32', '2022-02-21 12:27:32'), (5, 'b111b35b-a8bb-47fc-af34-e5a02b2a7add', 2, 1, '[\"can_view_data\",\"can_view_form\"]', '2022-02-21 12:27:32', '2022-02-21 12:27:32'), (6, 'c4b9f308-d5ee-4ea6-a918-f2f94f0816ef', 2, 1, '[\"can_view_data\",\"can_view_form\"]', '2022-02-21 12:27:32', '2022-02-21 12:27:32'), (7, 'e2fd806b-91e0-4235-8973-10b1b80ce879', 2, 1, '[\"can_view_data\",\"can_view_form\"]', '2022-02-21 12:27:32', '2022-02-21 12:27:32'), (8, '3984156b-e698-4e68-858d-1758002a3d14', 2, 1, '[\"can_view_data\",\"can_view_form\"]', '2022-02-21 16:08:35', '2022-02-21 16:08:35'), (9, 'ab0e7000-01b4-49ac-9af0-aacc112c8419', 2, 1, '[\"can_design_form\",\"can_view_data\",\"can_view_form\"]', '2022-02-21 17:07:46', '2022-02-21 17:07:46'); -- -------------------------------------------------------- -- -- Table structure for table `user_settings` -- CREATE TABLE `user_settings` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `smtp` text COLLATE utf8mb4_unicode_ci NOT NULL, `language` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `timezone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `visitors` -- CREATE TABLE `visitors` ( `id` bigint(20) UNSIGNED NOT NULL, `form_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL, `is_unique` tinyint(1) NOT NULL, `referrer` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `visitors` -- INSERT INTO `visitors` (`id`, `form_id`, `is_unique`, `referrer`, `created_at`, `updated_at`) VALUES (1, '254525ab-e3b4-45f0-1213-24cf89fed1ee', 1, 'http://localhost/form-generator/public/home', '2022-02-21 13:43:25', '2022-02-21 13:43:25'); -- -- Indexes for dumped tables -- -- -- Indexes for table `forms` -- ALTER TABLE `forms` ADD PRIMARY KEY (`id`), ADD KEY `forms_created_by_foreign` (`created_by`); -- -- Indexes for table `form_data` -- ALTER TABLE `form_data` ADD PRIMARY KEY (`id`), ADD KEY `form_data_form_id_index` (`form_id`), ADD KEY `form_data_submitted_by_index` (`submitted_by`); -- -- Indexes for table `form_data_comments` -- ALTER TABLE `form_data_comments` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `packages` -- ALTER TABLE `packages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `package_subscriptions` -- ALTER TABLE `package_subscriptions` ADD PRIMARY KEY (`id`), ADD KEY `package_subscriptions_user_id_foreign` (`user_id`), ADD KEY `package_subscriptions_package_id_foreign` (`package_id`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Indexes for table `systems` -- ALTER TABLE `systems` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- Indexes for table `user_forms` -- ALTER TABLE `user_forms` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user_settings` -- ALTER TABLE `user_settings` ADD PRIMARY KEY (`id`), ADD KEY `user_settings_user_id_foreign` (`user_id`); -- -- Indexes for table `visitors` -- ALTER TABLE `visitors` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `form_data_comments` -- ALTER TABLE `form_data_comments` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21; -- -- AUTO_INCREMENT for table `packages` -- ALTER TABLE `packages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `package_subscriptions` -- ALTER TABLE `package_subscriptions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `systems` -- ALTER TABLE `systems` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `user_forms` -- ALTER TABLE `user_forms` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `user_settings` -- ALTER TABLE `user_settings` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `visitors` -- ALTER TABLE `visitors` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- Constraints for dumped tables -- -- -- Constraints for table `forms` -- ALTER TABLE `forms` ADD CONSTRAINT `forms_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`); -- -- Constraints for table `package_subscriptions` -- ALTER TABLE `package_subscriptions` ADD CONSTRAINT `package_subscriptions_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`), ADD CONSTRAINT `package_subscriptions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `user_settings` -- ALTER TABLE `user_settings` ADD CONSTRAINT `user_settings_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;