Hiding DS fields?

But it’s not though. By entering that in the condition, the dropdown box is then RESTRICTED to just the value retrieved by the condition. There is no way for the user to override this value. Back to square one. I am starting to believe this is just not possible within the functionality of the plugin.

• This reply was modified 6 years, 9 months ago by mpbaweb.

Ok. I think I have solved the issue.

There is a bug whereby the condition does not recalculate when it’s dependencies change, so if the user changes one of the key fields, then the condition that is passed to the dropdown does not recalculate.

I have emailed you the exported cpfm file and the csv so you can check this yourself

Hello,

I’m sorry, but I’ve not received the email. Please, zip the exported file, and send me it from the “contact us” page in my private website:

https://cff.dwbooster.com/contact-us

Best regards.

There is no facility for attaching a file on that page. I sent the email to [email protected]

Hello @mpbaweb,

First, into the “Hull DropDown*” field, the condition cannot be simply <%fieldname19%> you should define it comparing with the records in the recordset field, as follows:

record['rhull'] == '<%fieldname19%>'

The condition into the “Transponder from DS” should be corrected too:

record['rclubno']=='<%fieldname14%>' && record['rclass']=='<%fieldname15%>'

Look the space characters between the different elements.

Please, check the rest of conditions.

Best regards.

Put those fixes in. Still doesn’t work. The dropdown now recalculates when the user changes his input, but is now back to being restricted to a single value returned by the condition. And the transponder field now retrieves nothing.

It’s just not possible to do this is it?

If you think you managed to make this work, then please send me the corrected cpfm file you used, as following your latest instructions is a step backwards from what I had already achieved.

• This reply was modified 6 years, 9 months ago by mpbaweb.

Hello @mpbaweb,

I’m sorry, the problem is that I really do not understand what do you want. If you are filtering the values in the DropDown field, will be available only the options that satisfy the filtering condition and not others. For loading other options is required modify the filtering values.

Best regards.

Well that’s exactly it. I don’t want to filter the dropdown,I just want to preselect one of its values. All the necessary data is available to do this.
It’s a really basic requirement to retrieve user data but allow them to override the values. I do not understand why such a simple requirement is so difficult to achieve

• This reply was modified 6 years, 9 months ago by mpbaweb.
• This reply was modified 6 years, 9 months ago by mpbaweb.

Hello,

If you want to load all possible options in the DropDown DS field, and select by default the option whose value coincide with the value entered through the fieldname19 field, the solution would be:

In the DropDown DS field settings:

– Select the Recordset option as the Datasource.
– Select the fieldname11 as the recordset.
– Enter the column name for value and text, in your case: rhull
– Let in blank the condition attribute.

Now, insert a Calculated field in the form with the equation:

(function(){
jQuery('[id*="fieldname'+'17_"] [vt="'+fieldname19+'"]').prop('selected', true).change();
})()

As the calculated field is used as auxiliar, you can tick the checkbox for hiding the field from the public form.

Best regards.

Together I think we have solved this now. I made the change you suggested and had the following result:
The dropdown is not restricted to a single value now. GOOD
The dropdown shows ALL values. BAD

The dropdown should only show values that are appropriate to the class selected by the user. So I added a non-unique condition to the dropdown DS that filtered this:
record[‘rclass’]=='<%fieldname15%>’

The form is now working as expected.

Thank you.

• This reply was modified 6 years, 9 months ago by mpbaweb.

Hello @mpbaweb,

Thank you very much for letting me know that everything is working now as you need.

Best regards.