Multiple values in form

AppSheet AppSheet Q&A
1

Hi, how to please prevent to multiple values of same type in form for PUBLIC app

for Name (already used)
Location (you cant fill the form because same Lat/Long)
Email (is it also possible to identifiy email without USEREMAIL() ? > by some trick with same text ?

2

Shodushi:

for Name (already used)

Use a Valid If expression.

Shodushi:

Location (you cant fill the form because same Lat/Long)

Use a Valid If expression, possibly that includes the DISTANCE() function.

Shodushi:

is it also possible to identifiy email without USEREMAIL() ?

Nope.

1 Like
3

Thanks. I tried

ISBLANK(
  FILTER(
    "UsersData",
    ([_THISROW].[Name] = [Name])
  )
  - LIST([_THISROW])
)

Looking good ?How I can modify an error message ?

Could you please write a short example how to use DISTANCE() ? with HERE()
(goal: not possible if you are in same location, (for example 1 km) in column Location where is latlong

4

Shodushi:

How I can modify an error message ?

3X_f_6_f6f9fc333f929a750d57a9b04bc8491787ea7d1d.png
3X_f_6_f6f9fc333f929a750d57a9b04bc8491787ea7d1d.png513×373 19.1 KB

Shodushi:

Could you please write a short example how to use DISTANCE() ? with HERE() > (goal: not possible if you are in same location, (for example 1 km) in column Location where is latlong

Try in Valid If expression for the Location column::

(DISTANCE([_THIS], HERE()) > 1.0)
2 Likes
5

Thank you very much

I am also trying

(DISTANCE([_THIS], HERE()) > 0.1) for 100 meters limit, I hope it will work too

1 Like
6

The ever first form with first map ping is invalid, in latlong column in initial value is HERE() and this new expression in valid if

but this is just an improvement not the necessary thing