Hi,
I use an expression to set the value of a column using the values of other cells in the same row.
It works fine when I use Appsheet UI. But when I update using an API call, the value is miscalculated. It is not blank but, a wrong value is set. (To be more precise, in my opinion, the โifโ statementโs result is wrong )
I use the Appsheet app to check the new row added by the API call, the wrong value is seen. Then I open to edit the row without ever changing anything, the value is recalculated but this time value changes, and the right value is set.
The problem is that the expressionโs result differs when an entry is created by an API call or an Appsheet form.
Can anyone help with this problem?
Solved! Go to Solution.
Maybe this?
What is the expression?
Hi, Original expression was this
I simplified it to
[User Input Price]/((100+[VAT Rate])/100)
it did not work eitherโฆ
Maybe this?
Great !!
Thank youโฆ It worked
I forgot to say that, I use Google Sheets as databaseโฆ
User | Count |
---|---|
36 | |
33 | |
28 | |
23 | |
18 |