hi, I am working to move users from Googlesheet (GS) to Glide table (GT) to take advantage of the speed. I plan to copy user’s email from GS to GT and then do relations from there to take just the information I needed from GS. I thought Add row might work, but could not find a way to do it. Kindly…

Maybe this? [image] Import Data From Excel & Sheets into Glide Table Feature Requests Hello, Failing to have an import function. I used a fairly simple method to import 3 tables of around 400 rows each, it’s not ideal, but it’s better than editing everything. For simpl…

If you need to move a substantial amount of data then you could consider getting help from a robot [image] robot Importing data to Glide by use of robot (RPA) Community Resources Challenge 1 In this moment of time it is not possible to import data (or paste chunks of data…

Nice and simple for me to handle. Thanks

thanks @Krivo . My data still small so I will use Manu’s method.

HI hi @Darren_Murphy How about duplicating the whole row in the Source Table Row to a destination Table via google sheet, when a certain value say Confirm is shown in Destination Table? The source table and destination table are in 2 separate Apps, and only way to link both is to use google sheet.…

Not exactly sure, but it sounds like you might be needing to use a filter formula. @Eric_Penn might be a good one to advise on this, I know he does some pretty advanced filtering techniques on his projects.

[image] ichilddev: We are using Arrayformula + Importrange + Query in Google Sheet, to get the row. But so far, manage to get only one row as Query does not work in Arrayformula (for a range) You should be able to combine Query with Importrange and return multiple rows. The syntax should look…

Thanks for your reply… Yes we use a trigger inserting the desired ID into the first column while a query in the second column shows the result ARRAYFORMULA(IF(ISBLANK(A2:A)," “,QUERY(IMPORTRANGE(“XXXX!A4:AY”),“Select * where Col1 Matches “&ArrayFormula(”'”&textjoin(”.|“,1,”.“&filter(A2:A,A2:A<>”“)…

Copy information from one sheet to another

Ask for Help

Krivo July 20, 2021, 6:18am 3

If you need to move a substantial amount of data then you could consider getting help from a robot

Topic		Replies	Views
Importing data to glide table Ask for Help	4	2330	August 2, 2021
Is Data from Glide Tables sync to Google sheets? Ask for Help	7	1651	February 25, 2021
Copy / paste google sheets data from glideapp Ask for Help	10	451	May 15, 2022
Complete form in Glide using a robot Ask for Help	2	772	February 18, 2021
Switch to Google Sheets Ask for Help	3	603	October 7, 2021

Copy information from one sheet to another

Related topics