on 02-03-2016 2:19 PM
Hi,
Is there a way to create one validation rule for all fields of the transaction or I have to create 1 rule for every field?
EXAMPLE (all string field mandatory):
EQSTR
<value field> (I have no idea how to do this from Validation Rules Panel of Transaction)
<Application.Blank>
Hi,
If you want to put a validation for mandatory fields, I would recommend to make it mandatory at the object level.
i.e. set the minimum length of the property of that Transaction to 1.
It will be more user friendly as it highlights in red.
Thanks,
Sudhir.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You don't need to create multiple validation rules.
You can write one validation rule to check all the fields.
For example...
AND
NOT
EQSTR
field1
Blank
NOT
EQSTR
field2
Blank
Regards,
Abhishek Wajge
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
// Use an And to make sure all the sub checks are true
AND
// To make sure it set to a set value
- EQSTR
- - Field Name
- - <Value>
// This is a way to check to make sure the field isn't blank
- NOT
- - EQSTR
- - - Field Name
- - - <<Application.Blank>>
// Use a OR, to make sure that at least one of the conditions is true
- OR
- - EQSTR
- - - Field Name
- - - <Value 1>
- - EQSTR
- - - Field Name
- - - <Value 2>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.