Relation Filter

Ask for Help
1

Hi!

I’m building an app for my company. One of the app’s features is to create and assign shifts that need to be covered. These shifts then count as overtime hours.

I’ve created a separate table to manage overtime, where I want to see how many overtime hours each person has worked per month and whether those hours have been paid or not.

The problem is that I can’t get the tables to relate properly. Glide doesn’t seem to give me the option to add filters in table relations, and I’ve tried unifying the data by creating a composite key using a template (ID–month–year), but the relation still doesn’t work.

I’ve checked that the values match and I’ve tried different approaches, but I still can’t get the tables to relate. I think the issue might be caused by using Template or Math columns, which don’t seem to work correctly when used in relations.

Could anyone give me a hand with this?

2

Have you tried a Query column instead of a relation? Query columns allow you to add inline filters.

3

Yes, but I still can’t get it to work. I’m sharing some screenshots so you can review it. Sorry if some parts are in Spanish.

image
image1920×750 152 KB

image
image3820×584 147 KB

4

Questions I would have before getting into technicalities:

  1. It would be useful to see the structure of your database: tables (we see them in your screenshot) and basic columns in each table. If your database structure is off, then the the rest will be too.

  2. I noticed you are using Glide Big Tables (GBT). They behave slightly differently compared to the normal Glide Tables. Are you aware of this?

1 Like