Hello everyone, I was wondering if there’s a way to create a feature where the user input a number in the app which is a POSITIVE number but the output shown in the google spreadsheet would be a negative number ?? If it’s possible, how can I do it?
Yes you can do that with an event action. When the form is saved, it triggers an action that rewrites the value with an expression like [ColumnName]-1. If the user is able to write a negative value, you need to use ABS([ColumnName])-1. Though you could probably also set a rule to your column that the max value is -1.
Hi, sorry… thanks for commenting. Do you mind to explain again in simpler terms? I have a difficulty understanding your comment
Please check the sample app called “Change Value” from www.appsheet.com/portfolio/531778
Thank you so much