Hello, Like all apps with communities, there...

(Ilan Sarbac) #1

Hello,

Like all apps with communities, there is a subscription page or a form to fill before going to the main page.

Does somebody know how to put a required subscription page or a form ???

(Jonas /) #2

create a table “subscribers” save the useres e-mail in it.

use an expression on your starting view, somehting like this:

if(in(useremail(), subscribers[e-mail]),

“subscribed starting view”,

“unsubscribed starting view” )

Keep in mind, that some experienced users will still be able to access other views if the have the deeplink to a different view of your app.

You can counter that with using the same if statement for a show_if of all your views except the subscriber form view.

hope that helps

(Ilan Sarbac) #3

Hello Jonas,

Thank you for your reply.

Actually, the form they have to fill is directly on the google form. I would like to hide all the database for those who didn’t fill the form.

Otherwise,

where do I have to paste the expression :

if(in(useremail(), subscribers[e-mail]),

“subscribed starting view”,

“unsubscribed starting view” )

Thank you :slight_smile:

(Jonas /) #4

why do you use a google form instead of using AppSheet?

(Ilan Sarbac) #5

I didn’t know Appsheet before Google Form that gathers some questions requiring formula for my app

(Jonas /) #6

you can directly convert a googleform into an AppSheet app (it automatically imports all the logic)

https://chrome.google.com/webstore/detail/appsheet/hmmicpkfdjjchdajlldfckjaanfobjob