Data validation issue

I am trying to make a data validation on my form, I use the same as this Add Conditional Visibility & Data Validation

The issue that I am facing is that once I entered all the required fields I back and delete one field and the validation is not changing to the submit gray button

=NOT(OR(ISBLANK($[Field1]),ISBLANK($[Field2]),ISBLANK($[Field3]),ISBLANK($[Field4]))))

Hi @Gsanchezc :honeybee:

I tried this out and experienced what you did as well; I'll let the team know, so they can take a look.

For a solution now, you can have your formula check if the fields are empty with "" instead:
=NOT(OR($[Field1]="",$[Field2]="",$[Field3]="",$[Field4]=""))

With this formula in the visibility properties, the submit button hides as expected after I delete input from a field.

Hope that helps, and let us know if you bump into anything else! :slight_smile: :honey_pot:

1 Like

Thanks, this workaround works at my end too. Nevertheless providing the option of required fields in HoneyCode will be the ultimate solution for this use case, don't you agree?

I'm happy that formula works for you, @Gsanchezc! :slight_smile:

And good note, I can see how an easier option or way to make a field mandatory would be helpful. I'll pass this along to our team as improvement request. Let us know if you think of anything else that would make it easier for you to build in Honeycode. :honeybee: :honey_pot:

@Alyssa - What would formula above ^^^ look like if in addition to regular fields you had many checkboxes and at least one of the checkboxes needs to be =TRUE (Checked) ? I was hoping I could some how reference the whole block or segment rather than each check box.

Hi @MJ!

For this, I'd recommend creating a screen variable that validates if at least one of the checkboxes are selected. Then you would add this variable into the formula on the submit button.

To set this up, create a data cell and set it to variable. For the value, set it to check if any toggle has been selected with: =OR($[Toggle1]=TRUE, $[Toggle2]=TRUE, $[Toggle3]=TRUE)

Then for the visibility on your submit form, here's a formula that checks if each field is filled out and at least one checkbox is selected: =AND($[Field1]<>"",$[Field2]<>"",$[Field3]<>"",$[Field4]<>"", $[CheckboxesNotBlank]=TRUE)

Let us know if that helps and if you have any other questions. :slight_smile: :honey_pot: :honeybee: