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