Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?
SaaS
What do you need help with?
Can you help someone/noob like me with less expeirence with databases to use filter very basic thing like matching a helper program year of one with the program year of another table’s year field I can’t seem to do this with AI studios help also->
Understanding the Goal
You want to create a panel (Table or Gallery view in your Application Builder) that shows a logged-in Matchmaker (MM) only the Match Requests (MRs) where the Helper’s Program_Year is the same as or within one year of the MM’s Program_Year.
Simplified and Corrected Approach (Using Application Builder Filtering):
Data Source (Targeted_MRs):
Fetch all available MRs without any Program_Year filtering.
Filters in the data source itself should only be:
Status is “New” (or your “unassigned” status).
Assigned MM is empty.
Current MM Data Source (Current_MM_Profile):
Make sure this data source is correctly configured and fetches the logged-in MM’s full record from the Alumni table, filtered by their email/ID. This is where
Please attach screenshots or videos if they help illustrate your question.
@olgatrykush@cwinhall
Now i have learnt a little bit about dynamic filtering So I think I will be able to explain my problem properly i am currently learning how to use page parameters to dynamically fetch my current logged in user’s based on that
Can you help write a formula Where The Table should only Show Me the rows Which fulfill the condition in the picture
So ideally if you want to filter data for this user only, your data source must return one of Id or Email of the user as they are unique way of identify it.
So in your case, you could create a “Get row” Data source that returns by default the first row of table “Current_MM_Details” if you don’t set a row_id and use the “ProgamYear_ComparableText” from this data source to filter the second data source but unfortunately this feature is not available yet, you can’t reference a data source from another data source. You can check this issue to keep track on this feature Allow to reference data source in another data source (#3711) · Issues · Baserow / baserow · GitLab
In the meantime, may be you could change the structure to add something to the data source 2 in order to have the information directly? May be a link row field or a formula? You might need to use an external automation tool to deal with it.
Yes, thanks for clarifying about this issue as I am now completing my Baserow Academy Advance certification, I also came to a similar decision like changing the structure or using an external automation tool .
