To setting a default value to an information when we creating a new row, we can done that with using the if condition in the formula.
First, in to the Studio go to the table where I would like to add the default value for it`s new row. Select the formula icon.
Next, By using the If else … condition we can make it execute the column “Quantity”= 1 when the column “Quantity” is less than(<=) 1, there is because the default value when we added a new row is 0 for an integer information. So, after this we need to add the else is the column “Quantity”. If not, the column value will always become 0 or None.
After this configuration, the result will become as below:
Create a new row at the table
The column “Quantity” will be created with the value “1” as default instead of “0”