I have added a custom widget that is a dropdown that allows me to select a record inside a table.
I want that record to be used to filter another table and only see the fields that share a country with the selected one.
Just as an example:
Table 1 is:
- country
- name
Table 2 is:
- country
- metric
When I select country Argentina from table 1, I want to only see the metrics related to Argentina.
Is there any way to accomplish this?
I was imagining that with access permissions some of this could be sorted out, but I was thinking of a more holistic approach, something I might be missing of the way Grist works.
Thanks!