Filter embedded table with linked record field

Hello Tulip team,

I’m facing a lot of use cases where I would like to add a filter on a embedded table based on a linked record field. However at the moment I’m not allowed to select this type of field.

Ex of typical use case - Link type One to Many :
First step user selects work order/testing and second step user wants to select in embedded table a sub-assignment/sub-test

Patxi

2 Likes

Hey Patxi,
Yotam with Tulip Engineering here. I don’t think we currently have the feature set you’re looking for directly. However, what you could do is pull the “linking record”, parse out the ID (using the field itself or the expression editor) and then load the “linked record”. This might give you similar functionality.

2 Likes

Hello Yotam, this topic is still an issue in my daily app building activities. I’m doing this horrible workaround every time I use linked records. : One field to use filters and one to link the table (see below).

I even try to use the table API to create and display an object rather than embedded table but I cannot output the linked fields :sweat_smile: If you have more ideas you’re welcome :slight_smile:

image

I’d just like to throw in my two cents here that this would be an enormously useful feature. Just about every table link I have is copied over to a another column. I have a moderately complex data structure with 7 tables, all with linked columns, and all having dynamic linking within the app. I’m trying to avoid using a connector at this stage as I need interactive table sorting for future reporting.

2 Likes

@CPS_Chris_Winters I know you are interested in this as well! Will update this thread when we add the functionality.

Once we release it, it will work on both queries defined in apps AND the Table Queries feature.

2 Likes