# List of Column names and types for each table in App
**URL:** https://community.glideapps.com/t/list-of-column-names-and-types-for-each-table-in-app/59416
**Category:** Ask for Help
**Created:** [March 20, 2023, 4:54pm UTC](https://community.glideapps.com/t/list-of-column-names-and-types-for-each-table-in-app/59416 "2023-03-20T16:54:33Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@MattLB](https://community.glideapps.com/u/MattLB)
#### Post date: [March 20, 2023, 4:54pm UTC](https://community.glideapps.com/t/list-of-column-names-and-types-for-each-table-in-app/59416/1 "2023-03-20T16:54:33Z")
I am migrating a bunch of tables from Google to Glide.
Anyway to create a list of columns/fields with types for each table?
For example below would look something like this:
Table: ( W CRUD Baant )
Columns:
–\>Budgets - Text
–\>Approved - Text
–\>…
–\>@ Creator - email
… for all Glide types such as Templates, LookUps etc
Thanks
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 20, 2023, 5:04pm UTC](https://community.glideapps.com/t/list-of-column-names-and-types-for-each-table-in-app/59416/2 "2023-03-20T17:04:45Z")
You mean you want to categorize each column into groups? You can use the forward slash naming convention to do that.
For example: Budget/Text for the column heading.
---
### Author:  [@MattLB](https://community.glideapps.com/u/MattLB)
#### Post date: [March 20, 2023, 5:22pm UTC](https://community.glideapps.com/t/list-of-column-names-and-types-for-each-table-in-app/59416/3 "2023-03-20T17:22:09Z")
Actually, more like a DB dictionary or, dare-I-say, schema.
I am manually copying a number Google tables (which are used as ‘working/temp’ tables for custom form screens) to new Glide table versions of them and want to make sure I copy over everything exactly. Some of these working tables have 30-40 columns (lots of calculated columns which are _really_ slow in a google table).
Good lesson - use Glide tables wherever you can. They are much faster than Google syncing.
Thanks as always
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 20, 2023, 5:35pm UTC](https://community.glideapps.com/t/list-of-column-names-and-types-for-each-table-in-app/59416/4 "2023-03-20T17:35:43Z")
Ahh, so a better vertical representation of each column, it’s type, and configuration so it’s easier to visually scan through and see what you need to recreate in your new tables?
---
### Author:  [@MattLB](https://community.glideapps.com/u/MattLB)
#### Post date: [March 20, 2023, 5:44pm UTC](https://community.glideapps.com/t/list-of-column-names-and-types-for-each-table-in-app/59416/5 "2023-03-20T17:44:13Z")
Exactly…so I just manually created my own by ‘screenshot’ all the tables and put the pictures into a PPT and have migrated two smaller tables so far.
These are all working tables which I use to create things (events, meetings, etc) so after setting them up I do a: show detail (temp table).
Then the hard work - I have to replace everywhere I use the current google temp tables with new glide temp tables. Recreating the screens should be a quick copy/paste and if I keep all the columns the EXACT same name I hope they connect similarly. Going to test shortly. Fingers crossed.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 20, 2023, 5:51pm UTC](https://community.glideapps.com/t/list-of-column-names-and-types-for-each-table-in-app/59416/6 "2023-03-20T17:51:36Z")
That would be awesome to have something like that…and printable too…for documentation and a bit of a backup if you ever need to recreate a column.
> [@MattLB](#):
>
> Then the hard work
Good luck. A lot of work, but worth it in the end.
---
### Author:  [@MattLB](https://community.glideapps.com/u/MattLB)
#### Post date: [March 20, 2023, 6:06pm UTC](https://community.glideapps.com/t/list-of-column-names-and-types-for-each-table-in-app/59416/7 "2023-03-20T18:06:40Z")
I strongly believe this should be a requirement cause every corporate customer will want a “copy” of their schema. Hardcopy backup so to speak
It is just the way DBA’s are built - and in the end this is a product that will end up under the purview of DBAs in one way or another. It is a database after all is said and done.
FYI…@david
---
### Author:  [@MattLB](https://community.glideapps.com/u/MattLB)
#### Post date: [March 20, 2023, 6:51pm UTC](https://community.glideapps.com/t/list-of-column-names-and-types-for-each-table-in-app/59416/8 "2023-03-20T18:51:40Z")
Created a new Glide table exactly like the original google table - see the two images.
Weirdness #1:
Why is their an “Is Favorite?” boolean in the Glide table? Is this a default added column? Not clear from documentation. Also - no screens have been created for this table, it is brand new with no data.
Weirdness #2:
Why isn’t Row ID shown in the Glide table action sequence for the Add Row?
## My only concern is the Row ID…
Original google table:
New Glide table:
-
-
ORIGINAL Add Row from an action sequence:
-
NEW GLIDE TABLE Add Row from an action sequence:
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 20, 2023, 8:08pm UTC](https://community.glideapps.com/t/list-of-column-names-and-types-for-each-table-in-app/59416/9 "2023-03-20T20:08:11Z")
> [@MattLB](#):
>
> Why is their an “Is Favorite?”
That’s a built in column. Normally it shows up if you utilize the built favorites feature or display the favorites bar on a list style view in classic apps. If it’s not used, then usually it becomes hidden. Nothing you should need to be concerned about.
> [@MattLB](#):
>
> Why isn’t Row ID shown in the Glide table action sequence for the Add Row?
RowID is automatically populated. You shouldn’t need to fill it with an Add Row sequence. It may be different because you are using glide tables instead of google sheets, which technically would let you put anything you want into a RowID column. Are you trying build a process to migrate your data? You could instead export a CSV from your google sheet, and then import that CSV into glide, which would be quicker. Not sure how it will handle the RowIDs though. That may or may not get hairy because RowID’s are normally assigned automatically. Maybe it will handle it just fine since the column headings are the same. Haven’t tried it myself.
---
### Author:  [@MattLB](https://community.glideapps.com/u/MattLB)
#### Post date: [March 20, 2023, 9:04pm UTC](https://community.glideapps.com/t/list-of-column-names-and-types-for-each-table-in-app/59416/10 "2023-03-20T21:04:52Z")
> [@Jeff\_Hager](#):
>
> Normally it shows up if you utilize the built favorites feature or display the favorites bar on a list style view in classic apps
At one point I must have tried Favorites and now it is there. No biggie.
> [@Jeff\_Hager](#):
>
> Are you trying build a process to migrate your data?
Nope - just cleaning up slow google working/temp tables with fast glide tables. These happen to also be the most complicated screens (both screen layouts and post processing ‘Create’ actions) so I was waiting/hoping for a migration tool.
I do a lot of glide fun stuff (use unique IDs, create relations, lookups, etc) that hits the google table and it is slow. I replaced this technique (using google temp tables) with glide tables in other parts of the app to big improvement. Now I have to retro-fit.
Almost 1 down - 5 more to go.