How can i edit USER DATA sheet

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

how can i do

??? GS or Glide?

what is GS? I use Glide

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

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

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

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

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:

Another way is a Relation/Lookup:

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:

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.


Thank you very much!

1 Like

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

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.

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


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

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

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.

1 Like

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”