ContributionsMost RecentMost LikesSolutionsMoving Existing Table To Connected TableHello, In order to optimize the available storage space, I'm attempting to move table records from a table in Quick Base to a new table in the cloud. What is an efficient way to do this using Google Drive or similar service? Background Info I have a table with two fields, the key and timestamp. Clicking on the key pulls up a large form (about 300 fields). Ideally, I would like to retain this behavior. Here is my thought process on solving the problem: Take the existing two-field table and expand it to include all of the fields needed from the form. The table would have the fields organized left-to-right in the order appeared in the form. Because the table has 10,000+ entries and about 300 fields, it can't be downloaded all at once. The data is broken up and then merged back into a single CSV file. The file is uploaded into Google Drive. A connected table is created in the app. I haven't completed the step below due to technical difficulty. 5. Creating a new form that is identical to the original. I suppose it should be noted that this table will only need to be read, editing the records shouldn't occur. It's a bit tricky making sure the steps are completed right. For instance, making sure the correct set of records is downloaded and duplications or exemptions are nonexistent. This might be an issue causing the technical difficulty stated above. When attempting to pull the data from the table, the error states that the source "contains non-unique key values". ------------------------------ Kyle Prince ------------------------------ Re: Populating Table With Existing Form FieldsHey Sam, Thank you for the response. I managed to format the report as needed. However, the system is stating that the table is too large to export. So it appears I need to use the API, which would have killed two birds with one stone if used in the first place. I can learn how to use the API, have some experience with them. Could you suggest an efficient way to parse the XML returned into a spreadsheet? ------------------------------ Kyle Prince ------------------------------ Re: Populating Table With Existing Form FieldsYeah, it appears that is the only way to do it. Thanks for the response. ------------------------------ Kyle Prince ------------------------------ Populating Table With Existing Form FieldsHello, I am attempting to export a table into a CSV file. However, the table only contains two fields when I actually need all of the fields displayed in the associated form shown in the table. The form contains the fields in a specific order that I would like replicated in the table form. The solution I've discovered is by going into "Customize This Report" > "Columns To Display". All of the columns I need to display are there, however, there are 300+ of them. I could do this one at a time, but this is obviously inefficient and makes room for of error. Furthermore, the fields are displayed in alphabetical order so I would need to search for the name of the field. The challenge is populating the table report with the fields from the forms report in the order shown in the form. What is an efficient way to do this? ------------------------------ Kyle Prince ------------------------------