Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Re: Data Auto Populates with Previous value

251 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Warehouse
4 - Data Explorer
4 - Data Explorer

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

4 Replies 4

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

Screenshot 2025-02-08 at 9.29.12 AM.png

Screenshot 2025-02-08 at 9.29.10 AM.png

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?

Sachin_191
8 - Airtable Astronomer
8 - Airtable Astronomer
Hey @Warehouse 
 
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.
 
 

 

The Idea is to type in one data set and if the information is logged elsewhere already itll populate the remaining information  Screenshot 2025-02-10 082440.png

 

Yeap, a lookup field would be ideal for that