Two Conditional Statements in a valid_if

AppSheet AppSheet Q&A
1

On the same column I need to have

1- a dependent drop down list

2- check for duplicates

1- Property Type[Offer type]

2-
ISBLANK(
FILTER(
“Properties”,
AND(
ISNOTBLANK([Province]), ([Province] = [_THISROW].[Province]),
ISNOTBLANK([State]), ([State] = [_THISROW].[State]),
ISNOTBLANK([Village]), ([Village] = [_THISROW].[Village]),
NOT([_ROWNUMBER] = [_THISROW].[_ROWNUMBER])
)
)
)

Can Some Help How to do it

2

Place your dropdown list expression in the Suggested Values property under the Auto Compute section of the column.

Place your validation code as you would normally in the Valid_If.

1 Like
3

Did not work

4

The validation worked fine from the browser

but from the mobile it did not, I was able to duplicate the record

5

If this is what you meant by “Did not work”, then I suspect the validation was not catching the use case properly to identify it as a duplicate.

Please provide the details of the use case that “did not work” and we can help you sort it out.

1 Like
6

Yes, you’re right . I found the problem in the mobile, the way to write the numbers is different, so it is not recognized in the validation.

AL_Shaikh_Real__0-1663821357193.png

That made the validation not to work

Thanks for Helping

1 Like