Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Validate 6 fields each other


Recommended Posts

I have a database that at least 1 of 6 determined fields must have a value on it.


For Example: Price 1, Price 2, Price 3, Price 4, Price 5 and Price 6. At least one of these fields must have a value, but NOT two of them together or more can have a value.


Do I have to Validate each 'Number field' through 'options'? or should I use something more complicated?


Appreciate your comments on this issue!



Link to comment
Share on other sites

a) Why does each record have six price-slots, of which only one is allowed to actually have a price? There must have been a purpose behind this, but I can't help but suspect that there's a better way of attaining it.


b) Each field can have a validation formula consisting of the other 5 fields all being blank. That covers "only one can have a value". As far as "at least one of these fields must have a value", you have to ask yourself "must have a value in order for the user to be allowed to do WHAT?" No easy way of selecting six fields and making one of them (but not specifying which one) a required field, but you can require that not all six fields be blank as a validation formula on other fields, and as something you test for in scripts.


c) I can't think of a good "c" clause so I'll just repeat "a" again: what in the world led to their being six fields for the same purpose only one of which is allowed to contain data? Don't you want to rethink that?

Link to comment
Share on other sites

Hi, guys!

Now i tried such.

I crearted one Calc field Sum=Abs(f1)+Abs(f2)+Abs(f3)+Abs(f5)+Abs(f6)

Then each field f1,f2,... i validated by calculation Sum-Abs(f1)=0,Sum-Abs(f2)=0 and it seems works.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...

Important Information

Terms of Use