Hi Community.
I am looking for a funtion in Application Studio that restrict negative numeric data entry. My custom report must only allows posive numbers. Is this possible?
I appreciate your comments.
Regards,
Mauricio
You can use the on cell edited action mode + cellwrite function to do the writeback. There you can use a condition for what values the action is allowed.
Hi,
i do not know if this can be restricted, but
you can put (ABS in to the cellwrite action. That way any entered number will be always saved positiv, even if user types a negativ number.
BR
Hi Mauricio,
as Filip mentioned use an action on edited cell, with a condition if(a1 > 0, wbc(...), ""). Make sure to change the formula within the cell from rwc to roc
Here is an example where the user types into C11. Copy the RWC formula that was there into the WBC formula at the bottom - same refs except that it begins C11.C11 is also tested to be greater than 0 to work. You can of course also react to a negative or 0 value with say a pop message for instance.
Thank you for all comments. I am fine now with this requirement.
