QR code to access one view only in public app

[eldderri]

Hi friends,

     I am making a public app in appsheet to let any user access to my app by scanning the QR code .I have already ceated a QR code ,but the user can access all views in that case.How to make the user be able to access only one view to enter data and unable to see any other admin related views .

Best regards,

[KON_TROLL]

Well the QR code should then link to a specific view. See here: https://support.google.com/appsheet/answer/10108105?hl=en

And then make a QR code out of that.

But to hide other views in a public app is not possible based on user credentials. Its public. There are work arounds, but not recomended. 

[eldderri]

I have used IN(USEREMAIL(), {"................@gmail.com ", "................@gmail.com "}) on show if on each view I want to hide to restrict those views from public users and give access only to admin users. It seems working now.For the qr code I have already created it using:=IMAGE("https://api.qrserver.com/v1/create-qr-code/?size=1000x1000&data=" &
ENCODEURL....

Now when any other user scan the qr code he can see only the user special view :"Demande Stage pratique".How do you see this approach?

[eldderri]

The problem is that IN(USEREMAIL(), {"................@gmail.com ", "................@gmail.com "}) is applicable only when the app requires sign-in and does not work with public apps .Is there any workarround.

Regards,

[Steve]

What you want to do is impossible in a public app.

[eldderri]

What do you suggest? Shall I create two separate apps one with one view for public users and one for admins then link their tables afterwards.Will this approch work?

[Steve]

That would be one way.

Can you explain what you're trying to do with your app(s)? That may guide us to a better suggestion.

[eldderri]

I want to make an application to track training requests coming from outside universities students.The student has only to scan the qr code I have already mentioned to access a form and he shall be prompted to fill in with necessary data including scanning his request and attaching it.By doing so and clicking save an email message with attachment is sent to the admin ( Training coordinator and CC to training manager) .Then the coordinator start to process his request including transferring the email to other departments who by their turn accept or reject the resuest then the coordinator transfer the final decision to the student.What I want is to limit the student as public user to enter one view only which is Training Request,whereas the admin (Training coordinator and training manager) can enter all the view in the app.

Waiting for your suggestions because I really blocked at this point while all other approval workflow is practically known to me

[Steve · Accepted solution]

Yeah, I'd say two apps is the right approach: a public app to collect the training requests, and a non-public one that requires login for use by the admins. The public one should use Filter out all existing rows? to avoid exposing previously-collected requests to unauthorized users. The two apps would share the table(s) used to collect the requests.

[eldderri]

Thank you so much for your reply.Would you please clarify in short what do you mean by "The public one should use Filter out all existing rows? "

[Steve]

Did you follow the hyperlink?

[yasarcan]

....but I can see . maybe filter disabled

[eldderri]

Because filter using useremail() does not work with public apps

[yasarcan]

If you use a link like this to generate a QR code and only allow access through this QR, wouldn't that work?

https://www.appsheet.com/start/app_id?email=kullanici@example.com

[eldderri]

The app is used for public users and I cannot predict their email addresses.I opted to use qr code because I want only external users to use qr code to access  training request view.The other views are related to admins.For this reason I have changed my mind and accept Steve's suggestion as a solution by making two apps based on the same database.

Thank you for your interest.