the only way to be able to filter which record's referenced record, is to use the domain, so i use the system.origin to filter the list, then need to access records on a referenced field
to be honest, this is not the only use case. I need to store many values from airtable to Global Data Variables, so I can use them in different ways. right now I can do is display the values in the page
store the things you need to make the resource query in the url as query parameters and do it in one fetch/resource
if you can't do the above because one piece of data depends on another piece of data and you need to have sequential requests fetching data one after another - you will need a separate backend that does those things for you. I could custom-code it in the cloudflare worker very easily. If that's not something you can/want use a nocode backend.