Title: chadtesting's Replies | WordPress.org --- # chadtesting [ ](https://wordpress.org/support/users/chadtesting/) * [Profile](https://wordpress.org/support/users/chadtesting/) * [Topics Started](https://wordpress.org/support/users/chadtesting/topics/) * [Replies Created](https://wordpress.org/support/users/chadtesting/replies/) * [Reviews Written](https://wordpress.org/support/users/chadtesting/reviews/) * [Topics Replied To](https://wordpress.org/support/users/chadtesting/replied-to/) * [Engagements](https://wordpress.org/support/users/chadtesting/engagements/) * [Favorites](https://wordpress.org/support/users/chadtesting/favorites/) Search replies: ## Forum Replies Created Viewing 15 replies - 1 through 15 (of 75 total) 1 [2](https://wordpress.org/support/users/chadtesting/replies/page/2/?output_format=md) [3](https://wordpress.org/support/users/chadtesting/replies/page/3/?output_format=md) [4](https://wordpress.org/support/users/chadtesting/replies/page/4/?output_format=md) [5](https://wordpress.org/support/users/chadtesting/replies/page/5/?output_format=md) [→](https://wordpress.org/support/users/chadtesting/replies/page/2/?output_format=md) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Calculated Fields Form] Looking up a field using a recordset](https://wordpress.org/support/topic/looking-up-a-field-using-a-recordset/) * Thread Starter [chadtesting](https://wordpress.org/support/users/chadtesting/) * (@chadtesting) * [9 years, 2 months ago](https://wordpress.org/support/topic/looking-up-a-field-using-a-recordset/#post-8929248) * This is resolved. For all those who may be wondering what the missing piece is, in the DS recordset, all fields you are using need to be highlighted. See below * [https://postimg.org/image/bl7ynzodx/](https://postimg.org/image/bl7ynzodx/) * Thank you, CodePeople - This reply was modified 9 years, 2 months ago by [chadtesting](https://wordpress.org/support/users/chadtesting/). - This reply was modified 9 years, 2 months ago by [chadtesting](https://wordpress.org/support/users/chadtesting/). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Calculated Fields Form] Looking up a field using a recordset](https://wordpress.org/support/topic/looking-up-a-field-using-a-recordset/) * Thread Starter [chadtesting](https://wordpress.org/support/users/chadtesting/) * (@chadtesting) * [9 years, 2 months ago](https://wordpress.org/support/topic/looking-up-a-field-using-a-recordset/#post-8926857) * These ones? [https://postimg.org/image/hl0uzv71t/](https://postimg.org/image/hl0uzv71t/) [https://postimg.org/image/75j2izb8v/](https://postimg.org/image/75j2izb8v/) * They are working fine from here.. It’s just a postimg URL * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Calculated Fields Form] Looking up a field using a recordset](https://wordpress.org/support/topic/looking-up-a-field-using-a-recordset/) * Thread Starter [chadtesting](https://wordpress.org/support/users/chadtesting/) * (@chadtesting) * [9 years, 2 months ago](https://wordpress.org/support/topic/looking-up-a-field-using-a-recordset/#post-8923788) * OK the form is ready. [CP_CALCULATED_FIELDS id=”7″] The fields start near the bottom at fieldname43. * Use the following images for reference: [https://postimg.org/image/hl0uzv71t/](https://postimg.org/image/hl0uzv71t/) [https://postimg.org/image/75j2izb8v/](https://postimg.org/image/75j2izb8v/) * I’ve emailed you username/password access. * Best Regards, * Chad. - This reply was modified 9 years, 2 months ago by [chadtesting](https://wordpress.org/support/users/chadtesting/). - This reply was modified 9 years, 2 months ago by [chadtesting](https://wordpress.org/support/users/chadtesting/). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Calculated Fields Form] Looking up a field using a recordset](https://wordpress.org/support/topic/looking-up-a-field-using-a-recordset/) * Thread Starter [chadtesting](https://wordpress.org/support/users/chadtesting/) * (@chadtesting) * [9 years, 2 months ago](https://wordpress.org/support/topic/looking-up-a-field-using-a-recordset/#post-8921892) * Hi CodePeople, * [http://www.futureu.ca](http://www.futureu.ca) * The code is on pg6. I can give you back end access if needed. * Thank you * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Calculated Fields Form] Looking up a field using a recordset](https://wordpress.org/support/topic/looking-up-a-field-using-a-recordset/) * Thread Starter [chadtesting](https://wordpress.org/support/users/chadtesting/) * (@chadtesting) * [9 years, 2 months ago](https://wordpress.org/support/topic/looking-up-a-field-using-a-recordset/#post-8919776) * Sorry, but there is something missing still. I wonder if some sort of ‘on change’ logic needs to be added for the dropdown field? Is it supposed to evaluate it dynamically? I’ve removed the extra closed curly bracer in your equation as well. * ``` (function(){ var records = fieldname90; /** fieldname90 is the ds recordset. **/ for(var i in records) { if(records[i][0] == fieldname91) /** fieldname91 is the ds dropdown. Record 0 is the field to match. Record 3 is the field to return. Text is the value to return. **/ { return records[i][3]; } } /** fieldname88 is the calculated field **/ })() ``` - This reply was modified 9 years, 2 months ago by [chadtesting](https://wordpress.org/support/users/chadtesting/). - This reply was modified 9 years, 2 months ago by [chadtesting](https://wordpress.org/support/users/chadtesting/). - This reply was modified 9 years, 2 months ago by [chadtesting](https://wordpress.org/support/users/chadtesting/). - This reply was modified 9 years, 2 months ago by [chadtesting](https://wordpress.org/support/users/chadtesting/). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Calculated Fields Form] Looking up a field using a recordset](https://wordpress.org/support/topic/looking-up-a-field-using-a-recordset/) * Thread Starter [chadtesting](https://wordpress.org/support/users/chadtesting/) * (@chadtesting) * [9 years, 2 months ago](https://wordpress.org/support/topic/looking-up-a-field-using-a-recordset/#post-8919734) * Hmm.. Are you sure there isn’t some extra logic to code the ‘on change’ value for the dropdown field? Does it read the change in values dynamically to generate the text? * I’ve tried it a hundred different ways and the the thing won’t generate any output. I also removed a closed curly bracer from the original equation, as I think there was one too many. * ``` (function(){ var records = fieldname90; /** fieldname90 is the ds recordset. **/ for(var i in records) { if(records[i][0] == fieldname91) /** fieldname91 is the ds dropdown. Record 0 is the field to match. Record 3 is the text field to return. **/ { return records[i][3]; /** } **/ } } /** fieldname88 is the calculated field **/ })() ``` * I’m pretty sure I am understanding you perfectly but there’s something small missing. - This reply was modified 9 years, 2 months ago by [chadtesting](https://wordpress.org/support/users/chadtesting/). - This reply was modified 9 years, 2 months ago by [chadtesting](https://wordpress.org/support/users/chadtesting/). - This reply was modified 9 years, 2 months ago by [chadtesting](https://wordpress.org/support/users/chadtesting/). - This reply was modified 9 years, 2 months ago by [chadtesting](https://wordpress.org/support/users/chadtesting/). - This reply was modified 9 years, 2 months ago by [chadtesting](https://wordpress.org/support/users/chadtesting/). - This reply was modified 9 years, 2 months ago by [chadtesting](https://wordpress.org/support/users/chadtesting/). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Calculated Fields Form] Looking up a field using a recordset](https://wordpress.org/support/topic/looking-up-a-field-using-a-recordset/) * Thread Starter [chadtesting](https://wordpress.org/support/users/chadtesting/) * (@chadtesting) * [9 years, 2 months ago](https://wordpress.org/support/topic/looking-up-a-field-using-a-recordset/#post-8918275) * Hi CodePeople, * Well on the bright side, it seems to be a quiet day on the forums! * I am definitely interested in learning how the Recordset DS fields work within your plugin, so if there are examples I’m missing that will help me solve this problem myself, I’d be happy to research it. As it stands, I would have no way to know whether the plugin interprets csv columns as ‘column_a’ or [0]. I was just taking you at your word. * This still isn’t resolved however. Is it possible that the `foreach` is syntactically problematic? When I run it through a delinter, it seems to have a problem with the following line: * `foreach(var i in records)` * I am executing the code exactly as described above. * Best Regards, * Chad. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Calculated Fields Form] Looking up a field using a recordset](https://wordpress.org/support/topic/looking-up-a-field-using-a-recordset/) * Thread Starter [chadtesting](https://wordpress.org/support/users/chadtesting/) * (@chadtesting) * [9 years, 2 months ago](https://wordpress.org/support/topic/looking-up-a-field-using-a-recordset/#post-8914279) * Hi CodePeople, thanks for helping. * I understand exactly what you’re saying and I’m trying it and it still doesn’t work. I’ll attach screenshots. * [https://postimg.org/image/ddn4ugct1/](https://postimg.org/image/ddn4ugct1/) * [https://postimg.org/image/v41kuvonr/](https://postimg.org/image/v41kuvonr/) * [https://postimg.org/image/ufsqbxpxz/](https://postimg.org/image/ufsqbxpxz/) * In order… * 1.) DS Dropdown * 2.) DS Recordset * 3.) Output field (Calculated field) * Now when I choose a choice from column_a in fieldname43, it should also return column_c in fieldname87 * I’m importing the same CSV in both fields. * Best Regards, * Chad - This reply was modified 9 years, 2 months ago by [chadtesting](https://wordpress.org/support/users/chadtesting/). - This reply was modified 9 years, 2 months ago by [chadtesting](https://wordpress.org/support/users/chadtesting/). - This reply was modified 9 years, 2 months ago by [chadtesting](https://wordpress.org/support/users/chadtesting/). - This reply was modified 9 years, 2 months ago by [chadtesting](https://wordpress.org/support/users/chadtesting/). - This reply was modified 9 years, 2 months ago by [chadtesting](https://wordpress.org/support/users/chadtesting/). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Calculated Fields Form] When importing from CSV to a required dropdown, how to make first row invalid?](https://wordpress.org/support/topic/when-importing-from-csv-to-a-required-dropdown-how-to-make-first-row-invalid/) * Thread Starter [chadtesting](https://wordpress.org/support/users/chadtesting/) * (@chadtesting) * [9 years, 3 months ago](https://wordpress.org/support/topic/when-importing-from-csv-to-a-required-dropdown-how-to-make-first-row-invalid/page/2/#post-8903818) * Yep was exactly what was needed. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Calculated Fields Form] When importing from CSV to a required dropdown, how to make first row invalid?](https://wordpress.org/support/topic/when-importing-from-csv-to-a-required-dropdown-how-to-make-first-row-invalid/) * Thread Starter [chadtesting](https://wordpress.org/support/users/chadtesting/) * (@chadtesting) * [9 years, 3 months ago](https://wordpress.org/support/topic/when-importing-from-csv-to-a-required-dropdown-how-to-make-first-row-invalid/page/2/#post-8900133) * Oh nice, thanks. I will give that a try! * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Calculated Fields Form] When importing from CSV to a required dropdown, how to make first row invalid?](https://wordpress.org/support/topic/when-importing-from-csv-to-a-required-dropdown-how-to-make-first-row-invalid/) * Thread Starter [chadtesting](https://wordpress.org/support/users/chadtesting/) * (@chadtesting) * [9 years, 3 months ago](https://wordpress.org/support/topic/when-importing-from-csv-to-a-required-dropdown-how-to-make-first-row-invalid/page/2/#post-8900127) * Is it possible that because the dropdowns I am ignoring are part of a calculated array, that it’s breaking my form? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Calculated Fields Form] When importing from CSV to a required dropdown, how to make first row invalid?](https://wordpress.org/support/topic/when-importing-from-csv-to-a-required-dropdown-how-to-make-first-row-invalid/) * Thread Starter [chadtesting](https://wordpress.org/support/users/chadtesting/) * (@chadtesting) * [9 years, 3 months ago](https://wordpress.org/support/topic/when-importing-from-csv-to-a-required-dropdown-how-to-make-first-row-invalid/#post-8899869) * I have tested this extensively, and while it works perfectly for viewing my dropdowns, adding the ignore class to every other required dropdown except the one I’m viewing breaks my form. Even if I remove the class for each dropdown later in the form, it still won’t display my output. Toggling doesn’t work. * Is there a way to ignore the ‘required’ function of the field, without ignoring the entire field? * Thank you. - This reply was modified 9 years, 3 months ago by [chadtesting](https://wordpress.org/support/users/chadtesting/). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Calculated Fields Form] Referencing my new DS fields in Javascript](https://wordpress.org/support/topic/referencing-my-new-ds-fields-in-javascript/) * Thread Starter [chadtesting](https://wordpress.org/support/users/chadtesting/) * (@chadtesting) * [9 years, 3 months ago](https://wordpress.org/support/topic/referencing-my-new-ds-fields-in-javascript/#post-8896874) * I can confirm this works. My problem is unrelated. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Calculated Fields Form] When importing from CSV to a required dropdown, how to make first row invalid?](https://wordpress.org/support/topic/when-importing-from-csv-to-a-required-dropdown-how-to-make-first-row-invalid/) * Thread Starter [chadtesting](https://wordpress.org/support/users/chadtesting/) * (@chadtesting) * [9 years, 3 months ago](https://wordpress.org/support/topic/when-importing-from-csv-to-a-required-dropdown-how-to-make-first-row-invalid/#post-8891810) * Perfect, thank you! * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Calculated Fields Form] When importing from CSV to a required dropdown, how to make first row invalid?](https://wordpress.org/support/topic/when-importing-from-csv-to-a-required-dropdown-how-to-make-first-row-invalid/) * Thread Starter [chadtesting](https://wordpress.org/support/users/chadtesting/) * (@chadtesting) * [9 years, 3 months ago](https://wordpress.org/support/topic/when-importing-from-csv-to-a-required-dropdown-how-to-make-first-row-invalid/#post-8891702) * OK, then what is the opposite of the special class name ignore? Let’s say I assign my fields the class name ignore and want to set as visible * Is it.. * jQuery(‘.socsci’).visible(); * ?? Viewing 15 replies - 1 through 15 (of 75 total) 1 [2](https://wordpress.org/support/users/chadtesting/replies/page/2/?output_format=md) [3](https://wordpress.org/support/users/chadtesting/replies/page/3/?output_format=md) [4](https://wordpress.org/support/users/chadtesting/replies/page/4/?output_format=md) [5](https://wordpress.org/support/users/chadtesting/replies/page/5/?output_format=md) [→](https://wordpress.org/support/users/chadtesting/replies/page/2/?output_format=md)