First I’m not english, sorry if my english is bad
I’m a new appsheet user and I’m trying to develop an app which allows you to enter what you’ve done (an operation), the date, who’ve done it and the price.
But, all operations have a fixed price, and there is a last operation called “Other” which has no fixed price (it’s in a calc, let’s say there is op1, op2, op3 with a value in euros and “Other” with no value).
When you add an operation, the price is fixed (the formula is [Operation].[Price]). But, when you choose the operation “Other”, you can’t manually enter a price and if you add the row you just have no price.
What I want is when you choose for example op1, it suggests you the price of op1 but you can still change it, and when you choose other, it suggests no price and you have to enter one (eventually it suggests 0, if necessary).