# How to Make My App User-Friendly

**URL:** <https://discuss.google.dev/t/how-to-make-my-app-user-friendly/57202>\
**Category:** AppSheet Q&A\
**Tags:** databases, users, account\
**Created:** [November 9, 2020, 2:54pm UTC](https://discuss.google.dev/t/how-to-make-my-app-user-friendly/57202 "2020-11-09T14:54:17Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![anonymous8](https://avatars.discourse-cdn.com/v4/letter/a/7cd45c/32.png) [@anonymous8](https://discuss.google.dev/u/anonymous8)\
**Post date:** [November 9, 2020, 2:54pm UTC](https://discuss.google.dev/t/how-to-make-my-app-user-friendly/57202/1 "2020-11-09T14:54:17Z")

</div>

Hello there,  
I am a high school student who has created an app to encourage my peers to recycle. The app design works great, but when I tried to share the app with others, it would not display their own profile, rather all of the profiles. Additionally, the data under the profiles shows to every user. In summary, I am really confused as to how to get my app to hold separate data for different accounts/profiles. I would appreciate any advice that you all have to offer. Thank you!

Here is the browser link for my app: [https://www.appsheet.com/start/c39f0a8b-f338-441b-9eda-bc9cee264daf](https://www.appsheet.com/start/c39f0a8b-f338-441b-9eda-bc9cee264daf)

---

<div class="post-metadata">

**Author:** ![LeventK](https://d3byx8b92xw3lq.cloudfront.net/user_avatar/discuss.google.dev/leventk/32/30587_2.png) [@LeventK](https://discuss.google.dev/u/LeventK)\
**Post date:** [November 9, 2020, 3:01pm UTC](https://discuss.google.dev/t/how-to-make-my-app-user-friendly/57202/2 "2020-11-09T15:01:07Z")

</div>

Please check these out. Your app is possibly a Public App where there’s no data security at all. You need a **Secure Sign-in App** which shall be either a Premium or Pro Plan subscription.

---

<div class="post-metadata">

**Author:** ![anonymous8](https://avatars.discourse-cdn.com/v4/letter/a/7cd45c/32.png) [@anonymous8](https://discuss.google.dev/u/anonymous8)\
**Post date:** [November 9, 2020, 3:12pm UTC](https://discuss.google.dev/t/how-to-make-my-app-user-friendly/57202/3 "2020-11-09T15:12:20Z")

</div>

Thank you so much for your quick reply! I will definitely check these things out!

---

<div class="post-metadata">

**Author:** ![Steve](https://d3byx8b92xw3lq.cloudfront.net/user_avatar/discuss.google.dev/steve/32/117807_2.png) [@Steve](https://discuss.google.dev/u/Steve)\
**Post date:** [November 9, 2020, 3:28pm UTC](https://discuss.google.dev/t/how-to-make-my-app-user-friendly/57202/4 "2020-11-09T15:28:10Z")

</div>

Alternatively to @LeventK’s good suggestion, you could avoid user sign-in by instead using `CONTEXT("Device")` to associate a user’s device with the user’s profile. The user would always have to use the same device, though, so there’s a downside. You’ll also want to use a slice or slices to work only with the current user’s data.

Congratulations on your app!

See also:

---

<div class="post-metadata">

**Author:** ![anonymous8](https://avatars.discourse-cdn.com/v4/letter/a/7cd45c/32.png) [@anonymous8](https://discuss.google.dev/u/anonymous8)\
**Post date:** [November 9, 2020, 5:43pm UTC](https://discuss.google.dev/t/how-to-make-my-app-user-friendly/57202/5 "2020-11-09T17:43:02Z")

</div>

Thank you for your suggestion as well! I will definitely look into this!  
I am a bit concerned, however, about one thing. All the formulas for my app are in the Google Sheets, not the app itself. I feel this might pose an obstacle for limiting data to each user, but I am not sure. Would it be preferable for the formulas to be in app sheet instead?

---

<div class="post-metadata">

**Author:** ![Steve](https://d3byx8b92xw3lq.cloudfront.net/user_avatar/discuss.google.dev/steve/32/117807_2.png) [@Steve](https://discuss.google.dev/u/Steve)\
**Post date:** [November 9, 2020, 6:09pm UTC](https://discuss.google.dev/t/how-to-make-my-app-user-friendly/57202/6 "2020-11-09T18:09:00Z")

</div>

Spreadsheet formulas are only recalculated when the app syncs, so the in-app values won’t change until that sync finishes. If the user uses the app while offline, the in-app values won’t update until the device is back online and syncs.

AppSheet expressions, though, are **more likely** to update within the app itself, though even that isn’t a given: some expressions are also only updated when a sync occurs. At the very least, an expression used to compute values **while in a form** will be updated as the form is used.

Some complex spreadsheet formulas aren’t supported by AppSheet, and may produce an error.

In general, best to use AppSheet expressions rather than spreadsheet formulas when possible.

---

<div class="post-metadata">

**Author:** ![anonymous8](https://avatars.discourse-cdn.com/v4/letter/a/7cd45c/32.png) [@anonymous8](https://discuss.google.dev/u/anonymous8)\
**Post date:** [November 9, 2020, 11:01pm UTC](https://discuss.google.dev/t/how-to-make-my-app-user-friendly/57202/7 "2020-11-09T23:01:31Z")

</div>

Alrighty, thanks for the suggestion!
