Hi: Can I limit entries from a mobile device...

(George Joseph) #1

Hi:

Can I limit entries from a mobile device?

Example having the user only enter one entry per hour.

(Tony Fader) #2

@George_Joseph You could add a valid_if to one of your columns that checks to see if there is a row by the same user that is less than an hour old:

COUNT(SELECT(YourTable[KeyColumn], AND( [Email Column] = USEREMAIL(), [Timestamp Column] >= NOW() - “001:00:00” ))) = 0

(Tony Fader) #3

https://help.appsheet.com/expressions/expression-types/date-and-time-expressions

(George Joseph) #4

Hi Tony:

It’s going to be a public app that allows users to sign in based on how close they are to an office location.

What I’m trying to achieve is not having the same person sign in twice in any given timeframe.

In other words I want John to sign in, but prevent him from signing in James.

(Tony Fader) #5

@George_Joseph Generally we advise against trying to build your own authentication mechanism. It will be inherently insecure. See this article and @praveen’s comment on this thread.

help.appsheet.com - Require Sign-In: The Essentials https://plus.google.com/102595816291334213292/posts/AaxakNduScH

Require Sign-In: The Essentials help.appsheet.com

(George Joseph) #6

Thank Tony,

After reading I agree and I’ll follow this workflow.

Thanks again.