Im using these formulas in initial value but i need a formula that search the table and retrieves the information and if not found leave blank.
LOOKUP([UPC/Barcode],“Products”, “UPC/Barcode”,“Product Name”)
Lookup([UPC/Barcode], “Products”, “UPC/Barcode”, “Brand”)
LOOKUP([UPC/Barcode],“Products”,“UPC/Barcode”,“Category”)
Right now its prepopulating the form with the first entry made and the add button works like an edit.
if I understand correctly, you are trying to assign 3 fields - Product Name, Brand and Category - when the Product row with the Barcode exists. correct?
You would actually want to take advantage of REF columns here and using “dot” notation to retrieve values.
The short of it would be, add a “Product” as a Ref column. Assign it with an expression like:
LOOKUP(\[UPC/Barcode\],“Products”, “UPC/Barcode”,“ID”)
Then in the table you are currently setting up you can use “dot” notation like this:
Product Name - assign the Formula column as - [Product].[Product Name]
Brand - assign the Formula column as - [Product].[Brand]
Category - assign the Formula column as - [Product].[Category]
If the Product column is blank - i.e. row does not exist, then the fields remain blank. If Product is populated, then the fields will be assigned whatever values are in the Products table. If the Product is changed, the fields will update accordingly.
I hope this helps!!
Hello @Precious1,
Welcome to the AppSheet Community!
If this helped answer your question, please consider marking it with the ✓ (Solution) icon below the post! Marking a solution helps other community members with the same issue quickly find the right answer.