G.forms how to hide data for clients

[konrad_konrad_s]

Dear Users,
I am new at appsheet. I have connect my g.forms with appsheet. It works. But i have a question. I wish to give my app to my clients to make orders. They can open it and there is problem. They can see all rows filled by other clients. How i can make it. The uniq data for each client is e-mail. Can make some kind of filter.

[hru]

If I just response to your question, which is to make some kind of filter based on each client email, you can use security filter with below expression:

[EmailColumn] = USEREMAIL()

Here are further reference:

help.appsheet.com

Security Filters: The Essentials

You can use Security Filters to control which records a user can see and update.

[konrad_konrad_s]

Thank you so much. I will try to do it. Next i will inform about results.
Best regards

Konrad Serwatko

czw., 30 kwi 2020, 12:04 użytkownik Heru Herlambang via AppSheet Creator Community appsheet@discoursemail.com napisał:

[konrad_konrad_s]

It works. But there is another question. How can i make it in that way. That after filling the row client would see all earlier orders filtrated by e-mail.

czw., 30 kwi 2020, 13:29 użytkownik Konrad Serewatko konrad.serwatko@gmail.com napisał:

[hru]

With the Security filter, user/client will only see the ONLY row relates to the e-mail. Including all earlier orders.
Perhaps for your case, since the client/user is filling a Form-view, you can change the Finished-View to the view of earlier orders in the UX > VIEW, so after click SAVE, it will navigate to the earlier orders view.

[konrad_konrad_s]

As you wrote this user filter should make to fill new row, and could see earlier rows including that e-mails. But when I put it all rows are not wisable.
I have option for table only ADD. Rewrite and Delete are not used.

[hru]

In the emulator, you have to insert the user email, as if you are simulating as the users, and click Apply: