Airtable & Excel Early Adopters Wanted

Thanks Jeff. Most of them are lookup columns of Airtable but has only single value (it does not have array of multiple values).

1 Like

They are array columns, as @Jeff_Hager says, but I’m not sure I understand why, or why they have commas inside the array items - I would expect them to be split up. If it’s not sensitive data, could you send me an invite to your Airtable base? mark@glideapps.com

3 Likes

Thank you Mark. I have added you to the Base.

I have one sync table from another base which has multiple values in it, hence it is showing comma. You can see the screenshot.


I hope this helps.

1 Like

I see. We’ll fix that. Thank you!

2 Likes

Love that Airtable MC column converts to array column in Glide:

:point_down:

6 Likes

@Mark Please see this thread.

While adding an action of showing Form Screen, I was not able to add any form field while testing with Airtable. It perfectly works on other modes. Looks like a bug or probably some restriction as of now ??

Thanks

That’s odd - this should be working now. Could you share a support link, please?

1 Like

Thanks @Mark It is still not working, just tried. Here is support link.
https://go.glideapps.com/support/93ab6fed-5e31-46a8-ba55-8b0169e89190

@Mark Is editing and adding records already available in the integration with Airtable?

@Pratik_Shah Could you please try adding a new column to the Companies table in Airtable, wait about 5 minutes, and then check again in Glide if the table has become editable? I believe the “readonly” flag is stuck until the Airtable schema changes.

1 Like

Hi @Mark I added a column as well as a row in the Airtable. Glide Table did not update with any of the changes. Entire Glide table is uneditable. I am not able to add or edit anything in glide table.

Yes. For bases that are already connected to Glide you’ll have to change the table schemas in Airtable (add a dummy column for example) for them to become editable, and wait about 5 minutes for it to sync to Glide.

Thanks @Mark. I did change the schema and edition is working fine. Great! Any idea about when multiple attachments would be available? We use .pdf in our corporate Airtable bases and this is absolutely needed.

Do you mean editing attachments? That will take a while.

1 Like

Ok. I understand we have to wait for multi attachments Airtable columns edition but I can’t find the way to render a .pdf attachment neither. The attachments column does not appear in the dropdown menu to set the component value.

I see, yes, I agree that we should support setting “single attachment” columns (Airtable doesn’t have a notion of that - Glide is just guessing whether your column is a single or multi attachment column).

Yes, yes, yes! A thousand times, YES!
Been waiting for Excel integration.

2 Likes

@Mark would it work a collection Glide component to render the multi attachment Airtable columns and an option to upload more than one file with the Glide file picker to this kind of Airtable columns? Just wondering…

Hi, I am trying to work with the Excel (Onedrive), and I attached an Excel with fewer than 500 rows, but the “limit” is 10 per sheet rather than 500 total for a free app.

Since this is a Beta, and I’m trying to give feedback, that seems like an odd and arbitrary limitation. Can this be like Google and Glide restrictions (500 total rows) so that my relationships will work?

This is data that I had in Glide/Google combination from a pro app but currently has fewer than 500 rows. I thought it would be a perfect beta because it’s a working app, and I don’t want to go pro under beta.
image

3 Likes