Copy / paste google sheets data from glideapp

Hi, nice to meet you dear glider community,
I’m a french user of glide app. And fresh one !
Well, i’ve looked for answer in the forum but without success.
I would my users copy/paste data from a sheet to another one in google sheet with button in glide app.
is it possible ?
is there another way to do that ? Hope you understood :slight_smile:
Subsidiary question : is it possible to merge a new sheet in a google sheet with a function in glideapp ?
I wish you the best !!
Adrien

Hi @Adrien_Soviche welcome in this community.
Regarding your first question, yes it’s possibily with a button; simply you can associate an action “Add row” on your button.
With the Add Row action you can choice the sheet and feed the column with custom or existent data on your current table.

1 Like

Regarding the second question may be the merge function is not exactly what you need.
May be you need only a relation between sheets.
Please explain me your scenario with an example.

2 Likes

Well, thanks considering me !
This is so simple and complex together :wink:
it’s about construction.
My user create a new location, for example a kitchen.
in my google sheet, there is a list of topics corresponding to the kitchen (and other sheets : one for bathroom, one for WC, and so on)
Then, when he creates the kitchen I want to copy/paste the data from kitchen to the sheet “all data”.
Then when he creates a bathroom I want to copy/paste the data from bathroom added from bathroom in “all data”.
Have you get it ?? I hope so !

1 Like

Ok, if i understand, we can call your “All Data” sheet Home.
So, Home is composed of one or more bathroom, one or more kitchen, one or more room, and so on…
For example, whic data you need to copy from kitchen to Home (your all data sheet)? And from bathroom to Home?

In addition, why do you need an “All data” sheet though?

2 Likes

Or likewise, why do you need a sheet for each room instead of using the All Data sheet with a room column to separate the data as needed?

2 Likes

For example, a room will be compose with Topics as row : “Light” “Door” “window” “ceiling” “walls”… And each of this Topic will have about 15 columns : “description” “quantity” “Unit” “price”…
In the sheet “Room” all of this Topics will have values in there columns.
Then when I create a house, I will take as many room, bathroom, kitchen I need, and bring them in one big “all data”.
This “all data” allow me a lot of calculations
I copy the whole “room sheet” or the whole “kitchen sheet” anytime I need it.
I hope to be clear !

I think (maybe wrong) it should be easier to sum and calculate if it is in one single sheet.

I will make a video to explain what I do in excel that I would produce in glide :slight_smile:

1 Like