Choice component can now be used with Airtable link columns. You will be able to choose from records in the linked table: [CleanShot 2022-07-05 at 12.19.32@2x] For now this is for Glide Pages only.

Yeah, can’t write to them, thus can’t create new relations, just new rows.

@jacobgorthy I think you want to pass the existing Job record as a value in the form. @Mark can we enable link columns as form values?

I think we just need the ability to write to link fields…not sure how that’s going to work though because Glide interprets them as relations.

Just need to be able to write to a linked record column in Airtable via a form. That will let me link new records that are being created by the logged in user. Which is pretty much the main feature of any serious airtable base, linking records from multiple tables together. Please let me know if you need a PM for the day, we can spec this out in like 30 mins with a zoom.

This is exactly my problem. It is disappointing. Hope the integration will be done soon.

@Tgattlen Have you seen this? Not sure if it solves your problem (I don’t use airtable), but it appears there is an update. [image] tada Airtable Linked records now supported in options component Airtable linked records are now supported using options menu!!! Congrats Glide Team! clapclapclapclap @david What we need now is a filter search in options component for Pages as linked records to choose can be a lot!! [image] Absolutely loving Glide as my Airtable front end.

Not seen, I will have a look. Thanks for sharing T.

[image] david: Choice component can now be used with Airtable link columns. You will be able to choose from records in the linked table: First, thank you @david for listening to the community and working on this!! We are close to the finish line, so let’s get the last few meters done together. The problem here is that Glide treats the concept of a Relation aka linked record completely different than Airtable (and other regular databases). Normally you have a field (Relation) that is writable and its value is (mostly) the ID of a row of another table. This is the behavior of a regular database and also how Airtable is handling its “Linked Record”. For this reason, Glide would just need to allow us the write to that specific field. In the Glide world, a “Relation field” is basically a “Look up” field that only needs to be read-only. When configuring the field you select “Look at column X and see if the value of X is present in table Y”. As @jacobgorthy and @Robert_Petitto mentioned we “just need to write to the fields”. The Airtable API treats these fields as arrays, so as long as Glide wraps the value that is going to be written, as an array, this should be a relatively simple change. Happy to support you guys for free to get this done for Pages and Apps. This missing feature is one of the few last pieces to make Airtable a first-class citizen. Thank you!

[image] laszlo: its value is (mostly) the ID of a row of another table. This is the behavior of a regular database and also how Airtable is handling its “Linked Record”. Not ever having used Airtable, I will say that Glide relations are not fields. If a linked record is a field, then to Glide (right now), that would just be an ID column (which could be linked via relation to an ID column in another table). From your description, it sounds as though AIrtable just makes the relationship behind the scenes, and in Glide, it would be a separate computed column. The difference I’ve had to wrap my head around is that it can be a relationship of one to many. So it really is not a field. It is a computed column. When using Sheets or Excel, we’ve come to expect that computed columns (like relations) only exist on the Glide side of things. So even in “regular” databases, the relation is just an index into an existing column – a field that can be written to and even modified. Glide puts that “index” into a separate computed column which is called a “relation” column. But it doesn’t mean the same thing as what Airtable is calling a “linked record” column – which from your description is an ID or Index. It seems that the Glide implementation is trying to treat it as a relation column, when it should just be a regular column with (perhaps) a relation column added automatically by Glide. Then your App or Page could choose which column (the regular column or relation column) it was needing in any particular circumstance. Not sure how they are going to address it – I’m just speculating based on my years of experience with databases in general.

[image] Robert_Petitto: Glide interprets them as relations Yes, I responded in another spot that perhaps Glide should just treat them as normal columns and then auto-add a corresponding relation column (rel-SameName) so the developer can choose which column is used in which scenario.

🆕 Choice component now works with Airtable link columns

General

Jeff_Hager July 8, 2022, 4:37pm 13

@Tgattlen Have you seen this? Not sure if it solves your problem (I don’t use airtable), but it appears there is an update.

Topic		Replies	Views
🎉 Airtable Linked records now supported in options component Ask for Help	1	1437	July 21, 2022
Airtable: want to add a new related record into a new table Ask for Help	47	3729	August 18, 2023
Screen Value to Relation column in Airtable Ask for Help	11	441	April 20, 2023
Airtable & Excel Early Adopters Wanted Ask for Help	117	5097	May 25, 2022
Airtable linked tables question Ask for Help	6	276	December 15, 2023

🆕 Choice component now works with Airtable link columns

Related topics