We would like to dynamically retrieve information from Airtable that is not directly linked to the primary record (e.g. a Purchase Order). Our current workaround involves creating links and using multiple "Lookup" fields, but this approach is not ideal for maintainability and performance.
Examples of desired functionality:
Retrieve general company information from a separate "Settings" table (without linking it to each Purchase Order).
Retrieve a list of all related orders from a "Purchase Order" table, potentially based on a condition or external reference.
Goal:
Allow DocsAutomator to access data from unrelated tables or global settings within Airtable, without requiring explicit links for every document template.