# How can i edit USER DATA sheet

**URL:** <https://community.glideapps.com/t/how-can-i-edit-user-data-sheet/53857>\
**Category:** Ask for Help\
**Created:** [November 11, 2022, 4:33am UTC](https://community.glideapps.com/t/how-can-i-edit-user-data-sheet/53857 "2022-11-11T04:33:32Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![Higher\_Purpose](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/higher_purpose/32/39645_2.png) [@Higher\_Purpose](https://community.glideapps.com/u/Higher_Purpose)\
**Post date:** [November 11, 2022, 4:33am UTC](https://community.glideapps.com/t/how-can-i-edit-user-data-sheet/53857/1 "2022-11-11T04:33:32Z")

</div>

I want to insert some function to the user data sheet.

how can i do

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [November 11, 2022, 4:40am UTC](https://community.glideapps.com/t/how-can-i-edit-user-data-sheet/53857/2 "2022-11-11T04:40:39Z")

</div>

??? GS or Glide?

---

<div class="post-metadata">

**Author:** ![Higher\_Purpose](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/higher_purpose/32/39645_2.png) [@Higher\_Purpose](https://community.glideapps.com/u/Higher_Purpose)\
**Post date:** [November 11, 2022, 4:51am UTC](https://community.glideapps.com/t/how-can-i-edit-user-data-sheet/53857/3 "2022-11-11T04:51:43Z")

</div>

what is GS? I use Glide

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [November 11, 2022, 4:52am UTC](https://community.glideapps.com/t/how-can-i-edit-user-data-sheet/53857/4 "2022-11-11T04:52:51Z")

</div>

do you have Google Sheets as your base? and what functions you need.

---

<div class="post-metadata">

**Author:** ![Higher\_Purpose](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/higher_purpose/32/39645_2.png) [@Higher\_Purpose](https://community.glideapps.com/u/Higher_Purpose)\
**Post date:** [November 11, 2022, 5:08am UTC](https://community.glideapps.com/t/how-can-i-edit-user-data-sheet/53857/5 "2022-11-11T05:08:39Z")

</div>

Right. GS. for example, today or now function in user data sheet

---

<div class="post-metadata">

**Author:** ![Higher\_Purpose](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/higher_purpose/32/39645_2.png) [@Higher\_Purpose](https://community.glideapps.com/u/Higher_Purpose)\
**Post date:** [November 11, 2022, 5:10am UTC](https://community.glideapps.com/t/how-can-i-edit-user-data-sheet/53857/6 "2022-11-11T05:10:09Z")

</div>

Or, I want to get data from USER DATA SHEET to another sheet

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [November 11, 2022, 6:25am UTC](https://community.glideapps.com/t/how-can-i-edit-user-data-sheet/53857/7 "2022-11-11T06:25:27Z")

</div>

> [@Higher\_Purpose](#):
>
> today or now function in user data sheet

You can simulate the Today or Now function by creating a math column in glide and set it up like this:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/b/bb09d4cbb9ec2be00dcaca38228ca9426151a2cf.png)

* * *

> [@Higher\_Purpose](#):
>
> get data from USER DATA SHEET to another sheet

If you want to retrieve data from the user sheet and make it available in other sheets, there are several various ways to do that. One way is Template column that pulls values directly from the user table:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/a/dabe98bc675bd97d1ec2b1c23db03fddf0e03c6d.png)

Another way is a Relation/Lookup:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/8/1893cfb7a9090557fc23922daea504cf27135d99.png)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/9/09b9fa388e1970d065e491d96d433e8deb6d12b2.png)

If you are using Row Owner in your user table, then you can also get away with using a Single Value column to retrieve values from the first row in a table:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/f/cffa6f3ef4c0889238c4e7152dcc843fb290196a.png)

* * *

If instead you meant that you want to permanently write user data to other tables, then that also depends. You can use a Set Column action, or you can use a Form, or you can use an Add form, or you can use and Edit form, etc. In all cases, you have access to the data in the user row.

It all depends on what you are trying to do, so it helps if you are more specific and detailed on what you are trying to accomplish.

---

<div class="post-metadata">

**Author:** ![Higher\_Purpose](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/higher_purpose/32/39645_2.png) [@Higher\_Purpose](https://community.glideapps.com/u/Higher_Purpose)\
**Post date:** [November 11, 2022, 8:05am UTC](https://community.glideapps.com/t/how-can-i-edit-user-data-sheet/53857/8 "2022-11-11T08:05:13Z")

</div>

Thank you very much!

---

<div class="post-metadata">

**Author:** ![Higher\_Purpose](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/higher_purpose/32/39645_2.png) [@Higher\_Purpose](https://community.glideapps.com/u/Higher_Purpose)\
**Post date:** [November 24, 2022, 6:38am UTC](https://community.glideapps.com/t/how-can-i-edit-user-data-sheet/53857/9 "2022-11-24T06:38:10Z")

</div>

I want to copy all data of one column in user data sheet.  
‘If a data is added to user data sheet, another data sheet bring that data automatically.’  
how can i do that

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [November 25, 2022, 5:53pm UTC](https://community.glideapps.com/t/how-can-i-edit-user-data-sheet/53857/10 "2022-11-25T17:53:03Z")

</div>

I’m still not clear on what exactly you want, but as I outlined in my previous posts, there are several ways to do it. It just depends on what exactly you are trying to do.

---

<div class="post-metadata">

**Author:** ![Higher\_Purpose](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/higher_purpose/32/39645_2.png) [@Higher\_Purpose](https://community.glideapps.com/u/Higher_Purpose)\
**Post date:** [November 26, 2022, 7:02am UTC](https://community.glideapps.com/t/how-can-i-edit-user-data-sheet/53857/11 "2022-11-26T07:02:14Z")

</div>

> [@Higher\_Purpose](#):
>
> ata is added to user data sheet, another data sheet bring that data au

2 tables are here. one is ‘USER’ table, another is ‘관리’ table

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/7/375e42e98f217f6d19232c5ec354f114bcfe16c3.png)

In case of ‘박성’ data (No.54) is added to ‘USER’ table,

I want that the name ‘박성’ is added to ‘관리’ table also

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [November 26, 2022, 2:17pm UTC](https://community.glideapps.com/t/how-can-i-edit-user-data-sheet/53857/12 "2022-11-26T14:17:52Z")

</div>

Can I still ask for more details? Explain what your app does. It helps to understand your problem and the best way to fix it. I want to make sure I’m giving the best advice. What is the purpose of placing all user names into a Management table? Would it be better to use the user table instead?

Whenever a new user signs in, a row will automatically be created in the user profile table. Since you have a name column, you must already have some kind of onboarding process for the user to enter that name after they sign in. At some point in that onboarding process, you could have an action to add a row into the management table.

I can’t be more specific or tell you the best way to do it because I don’t know anything about your app. All I can say is that it’s possible.

---

<div class="post-metadata">

**Author:** ![Higher\_Purpose](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/higher_purpose/32/39645_2.png) [@Higher\_Purpose](https://community.glideapps.com/u/Higher_Purpose)\
**Post date:** [November 27, 2022, 7:42am UTC](https://community.glideapps.com/t/how-can-i-edit-user-data-sheet/53857/13 "2022-11-27T07:42:35Z")

</div>

OK. i explain what our app does

Private user logs in and write diary daily.  
then, some information processed about the diary is wrote to ‘management’ table.  
for example, “several days in a row”, “whether or not write”
