Storing a Value Retrieved from Resource as a Variable
Storing a Value Retrieved from Resource as a Variable
At a glance
The community members are discussing how to store a value retrieved from a Resource as a variable. Some suggestions include using a collection with a single item, storing the parameter in the URL, and using a separate backend for complex server-side data manipulation. However, the community members note that reusing expressions and creating request waterfalls are not allowed. The main challenge seems to be accessing a referenced field from an Airtable table, especially when building a multisite application with different information displayed based on the subdomain.
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.
