Airtable: want to add a new related record into a new table

Ask for Help
42

Thanks a lot that was very helpful :pray:

Quick question: I managed to build what I want to do on detailed views, Iā€™m now wondering if this is also possible on filtered collections? In other words, is it possible to apply the combination of filters used to create the collection to the newly created record? I believe itā€™s not.

43

Can you explain more with some screenshots? What ā€œfilterā€ are you talking about here?

44

Hello @ThinhDinh

Iā€™m trying to build a Today section, sort of Dashboard aggregating items from Tasks, Resrouces etc.
I successfully managed to inline collections of specific items (Groceries that are Tasks filtered on X, Calls that are Tasks filtered on Y, etc).

  • When X or Y are regular properties of the object in the collection, no issue itā€™s easy to create an item and apply those criteria on creation
  • When X or Y are linked record, I find no way to create an item from the collection and setup the linked record on creation.

Screenshots:

Dashboard where is triggerred the form

image
image3000Ɨ1156 111 KB

Here Iā€™d like to automatically select :shopping_cart: Groceries and hide it from form (like I succesfully did for the other Choice in my form: Status which is single select field, not a linked record select).

image
image3022Ɨ1568 197 KB

The resource you mentioned above helped me achieving the desired bevahiour from a detail view within a parent collection, but here Iā€™m trying to apply a similar logic at a root level. Beside using Airtable automations upon record being created I found no solution.

Hope this clarifies things a bit

45

So do you mean that from the screenshot where you show a list of groceries, when you click the button to add a new grocery, it should automatically choose ā€œGroceryā€ in the area choice?

Sorry, I have no knowledge on linked records in Airtable, so might need more explanation here, maybe a dummy data sample to see your structure.

46

Hey, yes thatā€™s what I meant. I decided to give a try with Glide tables in replacement for Airtable, everything works like a charm, and speed is amazing. Too bad we have to make a choice here, as Glide tables also have a bunch of limitationsā€¦

1 Like
47

Can you specify them?

You should be able to specify a default value for that choice component, or even hide it with a default value still in play if needed.

48

Airtable comes from the data world while Glide started as an interface builder, and it makes a huge difference. While Glide is way much better than Airtable interface, the data part is far behind. Some of the things I noticed:

  • Relationships: after using glide tables I understand why it doesnt work well with airtable (I confirm you cannot set a default value for linked records if not in context of a parent object, too bad for me). Relations in Glide are basically vlookups in excelā€¦ what you can do with a single relation in airtable requires about 5-6 columns in Glide :upside_down_face:
  • No bulk actions on records, found some crazy threads on this website where people were doing javascript columns and other weird things to achieve such a basic thing.
  • No automations, everything has to start from an user input, I need automated triggers
  • No ability to manipulate my data as Iā€™d like to (create views, with filters, sorting etc for various use cases that do not need to live in an interface)

I realise I need so much from Airtable that Iā€™ll probably have to drop glide as the interface.
A bit disappointing after spending so much time to assess the tool but at least I learnt new stuff :slight_smile:

4 Likes
49

Thatā€™s insightful. Can you go into more details what a linked record can do in Airtable, and is there a way you can achieve those same functionalities in Glide, even if itā€™s a few more steps?

What ā€œbulk actionā€ does Airtable offer?

Time-based triggers might come later this year.