Yes. I know how. The API.
I trust that this “list” is the CSV you speak of. I also sense that it contains items with “codes” like product codes or an ID of sorts that you’d use to perform lookups into the various monthly tables.
I want to restate your quote to see if we can put a finer point on the requirement. Correct my compass heading if I’m getting this wrong.
Each week I receive a list that may include items from 5 or more different tables of inventory items that we’ll be receiving from suppliers. This list is notification concerning items that impact the monthly inventory lists.
This is where the thread confuses me -
Do you need to take the 150 to 200 entries contained in the weekly CSV file and distribute them across the various monthly tables? This seems to be exactly the opposite of the title of the thread.
Do you need to simply pull a single summary report (perhaps into a new table) from the monthly tables where those items match the items in the weekly CSV file dump?
I suspect it’s the latter but I want to be sure I understand the requirements clearly.
If it is the latter, I must [therefore] assume there’s a matching lookup code in the monthly tables that corresponds to the codes in the weekly CSV list, right? If so, let’s call this the product “key”.
Last question (for now).
You mention manual data input. Are you referring to using the CSV data to update the monthly tables in some way? Please describe.
Regardless of the process details, it’s abundantly clear that nuances of your business and information flow require a process that is not as simple as we all wished it were. Furthermore, there appear to be business logic aspects that need to be applied in a contingent or dependent fashion as the data moves through your workflow. Simply put - the system has to exhibit some intelligence and decision-making as the data is processed for reporting purposes.
This suggests (to me) that you need to codify your process externally to Airtable itself. To do this requires some code - custom reporting software - that is designed to ingest all the information, organize it for the report, and then deliver either the data in a report-ready format (perhaps back into Airtable), or in the report format itself (perhaps a PDF) that is dispatched to workers who need the report.
The reason such custom reporting software must be built external to Airtable is because Airtable has no integral scripting feature. Ergo, we must resort to an inexpensive (or free) scripting environment such as Google Apps Script.
Does your company use G-Suite by chance?
I would love to get a glimpse of one of the monthly tables and a sample CSV file. Also, we should understand how the weekly CSV is compiled and conveyed to you.
The key to getting you to a reliable and fully automated solution hinges on good requirements and a thorough awareness of the adjacent processes.