its a sheet of google
there should be no problem copy in google sheets… do not copy in glide editor, in glide you can copy only one cell
but if i can give you a professional advice… keep all data in one sheet, just add a column that indicate which floor it is, you can always sort this sheet by floors to keep them together, is much easier to work on data if it is in one sheet
yes I have a column that says the floor is,(Piso)
create another column that will just have a floor number, so it will be easy to refer to
ok, thanks for the tip
when you have just numbers, than is easy to sort, filter, import… than you don’t need separate sheet for each floor
OK. Another question, how can I get information from other sheets, and copy it to other sheets, it’s possible?
if on the same spreadsheets… use FILTER formula, if on deferent… use IMPORTRANGE formula, if in Glide use reference column
the reference column is RELATION right?
yes, for instance… if you wanna copy values from 7th floor, open a sheet call 7th floor, name one column 7th floor, and in all rows put number 7, than relate that column to source sheet with floor numbers
ok but when I edit a details, it doesn’t allow me to copy the data, or in the show form
edit only a source sheet, and changes will automatically appear on floor sheet
you dont even need floors sheets, you can filter source sheet by floor number and only this floor will show
ok and copy that same information in another row right, just changing the floor?
1 Like
do that in google sheets not in glide
ok, the last question, I have to change the status of a row after a certain time, it is possible perhaps with a script, you have some experience in that part, it has to be automatic
if the values are the same , you can use find and replace function, if not… only script
for example I have 10 row’s if a column is true, I check the time that was created and I wait a while and it should only change state
yes, you can write a scrip to check if value is true, than action, ok… i have to go… sorry