chadtesting

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/

Thank you, CodePeople

• This reply was modified 7 years, 8 months ago by chadtesting.
• This reply was modified 7 years, 8 months ago by chadtesting.

These ones?
https://postimg.org/image/hl0uzv71t/
https://postimg.org/image/75j2izb8v/

They are working fine from here.. It’s just a postimg URL

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/75j2izb8v/

I’ve emailed you username/password access.

Best Regards,

Chad.

• This reply was modified 7 years, 8 months ago by chadtesting.
• This reply was modified 7 years, 8 months ago by chadtesting.

Hi CodePeople,

https://www.futureu.ca

The code is on pg6. I can give you back end access if needed.

Thank you

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 7 years, 8 months ago by chadtesting.
• This reply was modified 7 years, 8 months ago by chadtesting.
• This reply was modified 7 years, 8 months ago by chadtesting.
• This reply was modified 7 years, 8 months ago by chadtesting.

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 7 years, 8 months ago by chadtesting.
• This reply was modified 7 years, 8 months ago by chadtesting.
• This reply was modified 7 years, 8 months ago by chadtesting.
• This reply was modified 7 years, 8 months ago by chadtesting.
• This reply was modified 7 years, 8 months ago by chadtesting.
• This reply was modified 7 years, 8 months ago by chadtesting.

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.

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/v41kuvonr/

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 7 years, 8 months ago by chadtesting.
• This reply was modified 7 years, 8 months ago by chadtesting.
• This reply was modified 7 years, 8 months ago by chadtesting.
• This reply was modified 7 years, 8 months ago by chadtesting.
• This reply was modified 7 years, 8 months ago by chadtesting.

Yep was exactly what was needed.

Oh nice, thanks. I will give that a try!

Is it possible that because the dropdowns I am ignoring are part of a calculated array, that it’s breaking my form?

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 7 years, 8 months ago by chadtesting.

I can confirm this works. My problem is unrelated.

Perfect, thank you!

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();

??