Skip to main content

Hello! Ive been looking all over youtube and the forums to find something that matches the automation I have in mind but to no avail unfortunately. 

Im attempting to create an inventory list that pulls from an item master list.

Currently every detail of items being stored on shelves is being manually typed out, I would like to improve the process but typing in the details once into the item master and whenever a part is being put away the PN is typed in, the remaining data would be pulled from a separate table and auto populate in their respective fields. With the possibility in the future integrating into an RFID system

Hmm, may I know what issues you faced using a lookup field for this?

Is it that you want the data to be historical?  If so, you could try using an automation to paste the data into the appropriate fields?

 
Inventory management in Airtable set up an automation that retrieves item details from the master list whenever a Part Number (PN) is entered. Here’s how to implement this setup:
 
1. The user inputs the PN in the inventory table.
 
2. An automation looks up the associated details (such as description, location, supplier, etc.) from the master list.
 
3. The fields auto-populate, eliminating the need for manual entry, Which reduces errors and saves time.
 
4. Additionally, future integration with an RFID system is possible by linking Airtable with Make.com or Zapier for seamless tracking.
 
 

 

Hmm, may I know what issues you faced using a lookup field for this?

Is it that you want the data to be historical?  If so, you could try using an automation to paste the data into the appropriate fields?


The Idea is to type in one data set and if the information is logged elsewhere already itll populate the remaining information  

 

The Idea is to type in one data set and if the information is logged elsewhere already itll populate the remaining information  

 


Yeap, a lookup field would be ideal for that

Reply


Terms & Conditions