I would like Ragic to auto populate some fields after I input a information in another field.
I have one sheet called PRODUCTS, with all my products details, like
And I have another sheet that is called ORDER where I organize the orders from clients.
In this form I will inform the products that where sold to clients.
In this ORDER sheet I will have 2 fields: Item Number and Item Name.
I will link the Item number field to the PRODUCTS sheet so I can choose the Item Number from thr PRODUCST sheet.
After I choose the Item Number I would like Ragic to auto populate the Item Name in the Item Name field.
How could I do that?