Chris Wareham
Hello, I was wondering if anyone has the knowledge to help me on a specific matter. I have a form with a repeatable section, the fields are as follows: Date field Day of the week - Lookup Day period - Lookup Position - Lookup Task to replace - Text Lookup ( Watch lookup fields: Day of the week, day period, position ) Replace task with - Text Field Justification for change - Rich Text What i'm trying to do is change the value of "Task to replace" with the "Replace task with" value, when the entry is created and updated. This only needs to change for the entry being created and not the value set in the form entry from the lookup. the repeatable section is needed to allow multiple changes if needed. Many thanks Chris
Good day, I have a query and I’m hoping someone can shed some light on how to go about it, or if anyone has done similar before and has a work around. I have a form that a user can enter statistical data (numbers) for different periods of the day. The form has a checkbox function with conditionals set that populates the fields relevant to that period of day for the user to enter the data When submitted the data is passed through the URL, however I believe that this or the [frm-field-value field_id=4926 1493="[id]"] would be suffice. To pull in the values submitted. I can get the values but I need to perform a maths calculation, and this is where it’s getting tricky for me. I can use the math short code to calculate multiple values, but the problem I have is if the user is to select more than one option from the form I get a blank entry in the view. I need to look for a work around that allows the user to select as many of the options they need to then perform the calculation based on them. As you can see the + operator […]
Here is a function that allows you to change multiple values in text fields either for calculations or strings, Had a developer create a function so here it is if anyone else needs to use it but will need to amend it for their very own field keys and ID's
SQL query to build your own tables
Hello, I am looking into another approach, using the copy data to a second table in MySQL as follows: add_action('frm_after_create_entry', 'wp_frm_tasks', 20, 2);add_action('frm_after_create_entry', 'wp_frm_tasks', 20, 2);function wp_frm_tasks($entry_id, $form_id){ if($form_id == 14){ //change 4 to the form id of the form to copy global $wpdb; $values = array( 'user_id' => $_POST['item_meta'][1140], 'user_id_fe' => $_POST['item_meta'][230], 'profile_start_date_fe' => $_POST['item_meta'][1139], 'display_name_fe' => $_POST['item_meta'][1196], 'email_fe' => $_POST['item_meta'][1197], 'establishment_fe' => $_POST['item_meta'][473], 'rank_fe' => $_POST['item_meta'][474], 'task_name_fe' => $_POST['item_meta'][233], 'flexibility_fe' => $_POST['item_meta'][248], 'task_type_fe' => $_POST['item_meta'][247], 'entry_count_fe' => $_POST['item_meta'][1195],); //replace 25 and 26 with the field ids of the Formidable form. Change col_name to the column names in your table $wpdb->insert('wp_frm_tasks', $values); //change table_name to your table name }} This works well when not using repeatable sections, am i missing something to why when i use a repeatable section in a form this does not work? Obviously using the repeatable section in a form there can be multiple entries that require inserting into the new table. ( possible a foreach statement ) Thanks Chris
Hi, i am wondering if this is at all possible so i would like to reach out for some ideas from the community please. I am wanting to create a new form to allow users to input shift names, start times, shift length etc A user would need to create as many shifts as they like by using the repeatable section. I would like to know if there is a way of calculating the total hours for each shift length added. Example: Shift 1 = 8.00 in length Shift 2 = 10.00 in length I would need to calculate the total of both or all shift length values outside of the repeatable section so the total should be 18.00 and obviously calculate accordingly to the amount of shifts added or subtracted from the repeatable field. Thanks Chris