| Forms multi-row validation [message #431508] |
Tue, 17 November 2009 17:06  |
vamsij
Messages: 1
Registered: November 2009
|
Junior Member |
|
|
Forms Multi-row validation
I have a requirement to show a validation error 'At least one reviewer should have more than zero amount limit'.
So we need identify highest amount limit entered in multiple rows, that highest amount limit should be >=1 if not show an error.
Level Reviewer Amt limit
1 ABC 0
2 MNP 0
3 XYZ 0
In the above case I need show an error msg. I tried pre-insert. It didn't work because built-in not supports pre-inserts.
Pls advice the best methodology to has shown error in this kind of scenario.
|
|
|
|
|
|
|
|
| Re: Forms multi-row validation [message #433371 is a reply to message #431508] |
Wed, 02 December 2009 00:06  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Create a new item, make its 'Calculation mode' 'Summary', make its 'Summary Function' 'Max', and then test that it is greater than zero.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
