# Airtable & Excel Early Adopters Wanted **URL:** \ **Category:** Ask for Help\ **Created:** [January 24, 2022, 6:28pm UTC](https://community.glideapps.com/t/airtable-excel-early-adopters-wanted/37619 "2022-01-24T18:28:57Z")\ **Posts on this page:** 20\ **Page:** 3
**Author:** ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)\ **Post date:** [January 29, 2022, 12:09pm UTC](https://community.glideapps.com/t/airtable-excel-early-adopters-wanted/37619/42 "2022-01-29T12:09:59Z")
Yep. As Glide import numeric computed Airtable fields as a Text field It’s not possible to create a Rollup Glide column with Sum totals, only shows Count option. ![Captura de pantalla 2022-01-29 a las 13.06.16](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/e/8ebc478408124785421d8a0437f40702199849d4.png) and currency € format ![Captura de pantalla 2022-01-29 a las 13.07.47](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/3/4337da0a3ea6100e35ba3a749231633c7a6c976e.png) ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [January 29, 2022, 12:24pm UTC](https://community.glideapps.com/t/airtable-excel-early-adopters-wanted/37619/43 "2022-01-29T12:24:41Z")
@darder That issue will be fixed next week on Wednesday, at least for new columns that you add. You should also be able to just change the type of the column to number, or at least you will be next week if not now. ---
**Author:** ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)\ **Post date:** [January 29, 2022, 1:02pm UTC](https://community.glideapps.com/t/airtable-excel-early-adopters-wanted/37619/44 "2022-01-29T13:02:07Z")
> [@Mark](#): > > You should also be able to just change the type of the column to number, or at least you will be next week if not now. Yep. Perfect. I tried it and it is now possible to change Airtable computed numeric fields to number format in Glide, and also perform Rollups. My Airtable data look gorgeous in Glide. 😋 I can’t add uniquely related fields to a Glide collection. I guess this will be possible when Glide “inherits” Airtable relationships. ---
**Author:** ![mmgt2005](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mmgt2005/32/965_2.png) [@mmgt2005](https://community.glideapps.com/u/mmgt2005)\ **Post date:** [January 29, 2022, 2:18pm UTC](https://community.glideapps.com/t/airtable-excel-early-adopters-wanted/37619/45 "2022-01-29T14:18:25Z")
I tried to connect my airtable base this morning everything worked fine until I clicked on the Create App button. After clicking create app, this screenshot below appears and times out. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/6/7692b07d76c2cd4501859430b15209a93cc37efe.png) ---
**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\ **Post date:** [January 29, 2022, 2:56pm UTC](https://community.glideapps.com/t/airtable-excel-early-adopters-wanted/37619/46 "2022-01-29T14:56:14Z")
Have the same issue, I believe it’ll be fixed next week according to Mark ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [January 29, 2022, 5:44pm UTC](https://community.glideapps.com/t/airtable-excel-early-adopters-wanted/37619/47 "2022-01-29T17:44:10Z")
> [@darder](#): > > I can’t add uniquely related fields to a Glide collection. I guess this will be possible when Glide “inherits” Airtable relationships. Sorry, what do you mean by “uniquely related fields”? ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [January 29, 2022, 5:44pm UTC](https://community.glideapps.com/t/airtable-excel-early-adopters-wanted/37619/48 "2022-01-29T17:44:21Z")
> [@PabloMFalero](#): > > Have the same issue, I believe it’ll be fixed next week according to Mark What’s the issue you’re having? ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [January 29, 2022, 5:44pm UTC](https://community.glideapps.com/t/airtable-excel-early-adopters-wanted/37619/49 "2022-01-29T17:44:57Z")
> [@mmgt2005](#): > > After clicking create app, this screenshot below appears and times out. If it’s possible, could you invite me to your Airtable base? [mark@glideapps.com](mailto:mark@glideapps.com) ---
**Author:** ![mmgt2005](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mmgt2005/32/965_2.png) [@mmgt2005](https://community.glideapps.com/u/mmgt2005)\ **Post date:** [January 29, 2022, 6:34pm UTC](https://community.glideapps.com/t/airtable-excel-early-adopters-wanted/37619/50 "2022-01-29T18:34:17Z")
What Airtable permission level would you need to identify the problem? ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [January 29, 2022, 7:05pm UTC](https://community.glideapps.com/t/airtable-excel-early-adopters-wanted/37619/51 "2022-01-29T19:05:50Z")
Just read permission. ---
**Author:** ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)\ **Post date:** [January 29, 2022, 8:23pm UTC](https://community.glideapps.com/t/airtable-excel-early-adopters-wanted/37619/52 "2022-01-29T20:23:38Z")
> [@Mark](#): > > Sorry, what do you mean by “uniquely related fields”? I’ll try to explain myself better: **A Short description:** Some Airtable linked columns do not show any content in Glide in the “one” column of the related table. Glide LookUp columns for those “empty” relations doesn’t work as well. **A detailed description:** Artable: This is the expense relation which have just one “proveedor” ![Captura de pantalla 2022-01-29 a las 20.42.54](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/2/d20926dab2f5c6568fb779749af133a634a52abe.png) ![Captura de pantalla 2022-01-29 a las 20.43.20](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/a/2a701e5e94a2d72c23fcd333bfc593d218f4f067.png) And this is what I see in Glide. ![Captura de pantalla 2022-01-30 a las 1.48.22](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/9/190205e022f22eddd519852c050634ae6d57d10d.png) Yeah, it’s empty. Close to this related to “proveedor” field I have created a Lookup formula column in Airtable to show the related “proveedor” and then, yes, Glide shows it. I’n not sure if this is due to the 100 rows limitation in Glide as I’m using a personal version for this test, but all “one side” of the relations columns appears “in some cases” empty in some tables By the way, relationships from one to many are already working perfectly in Glide, and it is possible to show related collections of a record. Congratulations for all the work. I’m sure that, specially for Glide Pages, which is more oriented to corporate users, the integration with Airtable will change the game. @Mark I’ve edited this issue as soon I realized this doesn’t happen in all cases but frequently… ---
**Author:** ![mmgt2005](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mmgt2005/32/965_2.png) [@mmgt2005](https://community.glideapps.com/u/mmgt2005)\ **Post date:** [January 30, 2022, 2:02am UTC](https://community.glideapps.com/t/airtable-excel-early-adopters-wanted/37619/53 "2022-01-30T02:02:05Z")
done ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [January 30, 2022, 5:28pm UTC](https://community.glideapps.com/t/airtable-excel-early-adopters-wanted/37619/54 "2022-01-30T17:28:56Z")
> [@darder](#): > > Some Airtable linked columns do not show any content in Glide in the “one” column of the related table. Glide LookUp columns for those “empty” relations doesn’t work as well. This shouldn’t happen. If it’s not sensitive data, could you please invite me to your Airtable base? [mark@glideapps.com](mailto:mark@glideapps.com) ---
**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\ **Post date:** [January 30, 2022, 5:34pm UTC](https://community.glideapps.com/t/airtable-excel-early-adopters-wanted/37619/55 "2022-01-30T17:34:54Z")
> [@Airtable & Excel Early Adopters Wanted](https://community.glideapps.com/t/airtable-excel-early-adopters-wanted/37619/16): > > Hey guys, so I’m testing the Airtable connection, I’ve successfully connected to the API, but when I enter the URL to the table the app doesn’t generate, here’s a video showing the issue: This, Is it related? ---
**Author:** ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)\ **Post date:** [January 30, 2022, 7:30pm UTC](https://community.glideapps.com/t/airtable-excel-early-adopters-wanted/37619/56 "2022-01-30T19:30:18Z")
thanks @Mark send me a message with your Airtable login mail and I will share this base with you. It’s a copy of the production table just to this test so I can give you edition permissions if needed. ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [January 30, 2022, 8:56pm UTC](https://community.glideapps.com/t/airtable-excel-early-adopters-wanted/37619/57 "2022-01-30T20:56:53Z")
> [@mmgt2005](#): > > done Thank you! Your issue should be fixed by Wednesday. ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [January 31, 2022, 12:41pm UTC](https://community.glideapps.com/t/airtable-excel-early-adopters-wanted/37619/58 "2022-01-31T12:41:36Z")
@darder Your problem is that you’re over the row limit, so Glide doesn’t load all the data. You’ll see that you don’t have all your rows in “Acreedores”, but for the rows that you have the relation works. Lookups in Airtable will come over to Glide because they’re computed by Airtable, not by Glide. ---
**Author:** ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)\ **Post date:** [January 31, 2022, 1:07pm UTC](https://community.glideapps.com/t/airtable-excel-early-adopters-wanted/37619/59 "2022-01-31T13:07:21Z")
> [@darder](#): > > I’n not sure if this is due to the 100 rows limitation in Glide as I’m using a personal version for this test, but all “one side” of the relations columns appears “in some cases” empty in some tables Yes, I was already assuming that this would be the reason. I think that the limit of 100 rows in Pages, if Glide really wants to focus this tool on corporate users, is perhaps too low to evaluate its possibilities. Thanks @Mark ---
**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\ **Post date:** [February 1, 2022, 4:29am UTC](https://community.glideapps.com/t/airtable-excel-early-adopters-wanted/37619/60 "2022-02-01T04:29:20Z")
I am testing the Airtable with Glide Pages. Just wanted to get one clarification, in my Airtable, I have two relation column, one formula columm, one text column and rest are look up columns. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/f/ff9df23b46a34e6bb8a2e8e3521fba0c2850a80c.png) In Glide Tables, I am able to see all of these, but I am not able to **use** any of these columns in Editor (please see screenshot). I understand that I can not edit Airtable data, but atleast I assume I can use these data to show it in my app. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/3/f3e02073f146b66b570e327fe8a9fa6ff177e571.png) Is there something I am missing? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 1, 2022, 5:10am UTC](https://community.glideapps.com/t/airtable-excel-early-adopters-wanted/37619/61 "2022-02-01T05:10:46Z")
I don’t use airtable, so I can’t help too much, but I see a lot of array columns, which I’m guessing are your airtable lookup columns. Arrays can potentially contain multiple array values. Because of that you cannot use an array of values in a component that can only display a single piece of data. [Previous page](https://community.glideapps.com/t/airtable-excel-early-adopters-wanted/37619.md?page=2) [Next page](https://community.glideapps.com/t/airtable-excel-early-adopters-wanted/37619.md?page=4)