I understand what you are saying with the functionality of an airtable database, but airtable is a bit more complicated that google sheets and essentially it’s a hybrid between a database and an app. If you had a Relation that linked to a million rows in a different sheet, would you want one cell to contain the entire row contents of all one million records?
A relation is to create a link (like a URL)…not to pull in the contents of that link. I think I understand what you are asking for, but that is not the function of a Relation.
#Export airtable to excel update#
Eventually I would like to update it with all of the new functionality that Glide is releasing. I’m currently using the old method in several places in.
Setting them up in the Data tab is functionally the same as using the header syntax. There’s nothing too magical about relations. I have no idea how this relation setup would translate to another platform as it may be only syntax that’s unique to Glide. Just keep in mind that you are tasked with keeping the column values populated using arrayformulas or some other method, so that the links work properly between sheets.
To create a relation using the old method, you need to structure your column heading like this: Sheet1Heading=Sheet2:Sheet2Heading:Multiple I don’t know if the old method will be supported indefinitely, but for the time being, it does work great and allows for relation visualization within the spreadsheet. The old method still works, but the new method is easier for many to understand and potentially offers performance improvements over the old method. First of all, you would always have the data as it’s in your own personal Google drive, so there’s really nothing to export.Īs for relations, I still use the old method (header syntax) of relations in several places, but I plan to slowly migrate to the new method whenever I can (relation column in data tab).
0 kommentar(er)
