Use data validation basis multiple columns

[iamhvj]

Hello community,

I am creating an inventory management app on appsheet. I have assigned unique product code basis Product Category, Product name, Product size and product colour. 

Now i want to auto generate the product code on the output google sheet when any one enters the product category, product name, product size and the colour on the app.

Basically get the exact product code basis multiple inputs of category, name, size and colour

thank you for your help in advance

[VOLODYMYR_TYROL]

Hello, I’m not sure that I understand exactly what you mean, can you please provide screenshots or example of your data

[Swoopy]

You said "unique" product code basis, so I assume it's used as table's "key".

Please check out UNIQUEID() which return unique random mix of digits & letters. Try placing it in 'INITIAL VALUE' of product code basis. It auto-runs on form when users add new rows.

UNIQUEID() - AppSheet Help 

[Steve]

FILTER() - AppSheet Help