Records of Data making it negative as default

[ayxxn]

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?

[Aleksi]

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.

[ayxxn]

Hi, sorry… thanks for commenting. Do you mind to explain again in simpler terms? I have a difficulty understanding your comment

[Aleksi]

Please check the sample app called “Change Value” from www.appsheet.com/portfolio/531778

[ayxxn]

Thank you so much

[Aleksi]

You’re welcome