Formula: IF()

Creating a dynamic Buy button based on stock inventory.

Let's say we have a stock for each product. And if a product is in stock, the button in 3DVista should say: Buy. But if the product does not have anything in stock it should say: Sold out.

Now how do we do that?

ProductPriceStockButton Text

Nice Water

€1

50

Buy

Hard Rock

€2

0

Sold out

Sharp Scissors

€4

3

Buy

Using the IF() formula.

IF({Stock}=0,"Sold out", "Buy")

Last updated