Michael Tidbury replied 2 years ago

Aaah Victor, many thanks for the super speedy reply. I'm in England.

What you say makes perfect sense - I did not know that empty fields are not stored - it explains why on View there is an option to display empty fields.

I will stick to the filter solution then.

I can pass two parameters (lettera and lettere) with values of a and e respectively and it works perfectly.

However, the connundrum is how to convert, for instance, a single radio button (Field assigned - No) to two parameters lettera and lettere.

I have tried using [if xxx equals="No"]a[/if xxx] in the default value for a hidden field lettera and similarly for a hidden field lettere. However, when I pass the hidden fields as parameters they pass the conditional test itself and not the test result.

Do you have any thoughts on that?

All the best,

Michael.

Victor Font replied 2 years ago

I have to question your use of the term "dynamic field" A dynamic field is a Pro lookup field that can be displayed in a variety of formats. The value of a dynamic field is an entry ID, which is numeric. The entry ID links the dynamic field's record id to the form field. There would never be an a or e in a dynamic value.

Michael Tidbury replied 2 years ago

Hi Victor,

The filter works fine; the field being filtered is Dynamic and the displayed value (from a look-up form) always contains an 'a' or an 'e'. This is proved because if I only filter for 'a' the displayed values with no 'a' but an 'e' come up.

To make it easier for the user, I want my search form to have a single radio button: 'Field empty' with 'Yes' as the only answer.

I have two hidden fields on the search form and I want to assign 'a' to one and 'e' to the other when the 'Field empty' has 'Yes' in it. These are then passed as the parameters.

How do I make the two hidden fields take on the 'a' or 'e' values when the radio button is ticked?

I tried making the default for the 'a' hidden field [if nnn equals="Yes"]a[/if nnn] where nnn is the number of the Field empty radio button. This passes a parameter of the whole text, i.e. it ignores the conditional statement.

I have got round it at the moment having two unnamed radio buttons: one when clicked has value 'a' and the other when clicked value 'e'. Then asking the user to tick both if they want to test for an empty field. It works fine but is clumbsy.

I'm sorry this is so long but hopefully it explains what is essentially a very simple business requirement 🙂

Bobby Clapp replied 2 years ago

Make the hidden fields conditional based on the radio. It's my understanding that if the condition doesn't allow the field to be save to the DB if the field doesn't show based on the condition.

Michael Tidbury replied 2 years ago

Hi Bobby,

Cunning...that idea works with the following modifications.

I have made the fields 'a' and 'e' text and visible only to the Administrator (a hidden field cannot be conditional so I had to hide the text fields from general view) and both conditional on the single 'Field empty' radio button.

It works perfectly.

Thank you to both you and Victor!

All the best,

Michael.