# Save scale values as user preference

**URL:** <https://connect.superhuman.com/t/save-scale-values-as-user-preference/19970>\
**Category:** Ask the Community\
**Created:** [December 7, 2020, 12:25pm UTC](https://connect.superhuman.com/t/save-scale-values-as-user-preference/19970 "2020-12-07T12:25:36Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Balint\_Drahota](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/balint_drahota/32/10969_2.png) [@Balint\_Drahota](https://connect.superhuman.com/u/Balint_Drahota)\
**Post date:** [December 7, 2020, 12:25pm UTC](https://connect.superhuman.com/t/save-scale-values-as-user-preference/19970/1 "2020-12-07T12:25:36Z")

</div>

I let viewers to play with scale values, to display another table view based on their personal preferences:  
 ![image](https://global.discourse-cdn.com/coda1/original/3X/6/8/6811a880299a9b0b7fb8ff4ee90852c11a3341a0.png)  
[Find the live version here.](https://coda.io/@together/solution-based-economy)

Can you recommend a way to let users log in with a Google/Coda account to save their preferences? (i.e. no need to start from blank values next time?) Also, I would see the saved preferences for demand and newsletter purposes.

I thought sg like IF(User().email.isblank then get values from the free-to-edit column, else from stored values that were generated as new rows. The problem here is how can I elegantly display currently stored values for the user and let edit them…

Thank you so much!

---

<div class="post-metadata">

**Author:** ![anon72651389](https://avatars.discourse-cdn.com/v4/letter/a/7ab992/32.png) [@anon72651389](https://connect.superhuman.com/u/anon72651389)\
**Post date:** [December 7, 2020, 1:42pm UTC](https://connect.superhuman.com/t/save-scale-values-as-user-preference/19970/2 "2020-12-07T13:42:52Z")

</div>

@Balint_Drahota you could totally use the “filter table” approach seen here:

> [@\[Video\] User-specific filters (each person tweaks controls independently)](https://connect.superhuman.com/t/video-user-specific-filters-each-person-tweaks-controls-independently/17623):
>
> Yet another question that has been asked and answered so many times: How do I let multiple people use the doc at the same time and change filters just for themselves? Time to have the ultimate answer in one place. I recorded the video explaining how to do that using a helper table. I call this approach the Flows Table pattern. [[Coda trick: User-specific filters] ](https://www.youtube.com/watch?v=k3BFoQm5RJA) TL;DR: Create a table where each row is linked to each Coda user. Set up its columns to act as controls (checkboxes,…

I’ve used this judiciously in the documents I work with, and it’s been an extremely useful tool.

Just set up a table where the rows are people, and the columns are their selections. Then later you could create a table where the rows are preferences, and reference the selections they made via formulas. Alternatively, you could present the user with the actual filter table, filtered to only see their preferences.

---

<div class="post-metadata">

**Author:** ![Mario](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/mario/32/12232_2.png) [@Mario](https://connect.superhuman.com/u/Mario)\
**Post date:** [December 7, 2020, 10:58pm UTC](https://connect.superhuman.com/t/save-scale-values-as-user-preference/19970/3 "2020-12-07T22:58:29Z")

</div>

Hi @Balint_Drahota, i confirm you that the approach suggested by @anon72651389 is good!  
I’ve built an entire app based on who is using coda in that moment 🙂  
If you need some more suggestion or help to craft it into your doc just write here or share your doc and i (probably we) can help you 🙂

Update, i’ve seen later the doc link, sorry 😅  
Nice thematics btw! After seeing it i can confirm that filter that table based on currentuser (i suggest you to use a custom formula to check who is using the doc for future modifications if needed) is one of the best choice!  
You can create those with an “initialize for me” button that add all the needed row!
