Jump to content
Sign in to follow this  


Recommended Posts

I am not sure what I need here for this to work, but I am assuming it is some type of validation criteria.

I have two fields in question here, one being dependant on the first

Field1 - for the most part will be blank but on some occasions will have info in it (a flag basically) When this flag is set Field2 needs attention.

Field2 - will only need info in it IF Field1 has the flag set. Otherwise NEEDS to be empty. The data that gets entered into Field2 comes from a value list.

My first attempt was to set filed2 to validate by "member of a value list" but this does not work since there is a good amount of time that this field will need to be empty.

So- I made a calculation

Field2= (If Field1 ="flag" ; "[color:red]need to enter in something for Field2) This was hoping to say that if Field1 had the flag set enter, it will enter in "ned to enter in something for field2" to 1)let the client know the field needs data, and 2) not validate since it does not match anything in the value list. Otherwise do nothing since the field needed to be left empty anyhow.

Does this all make sense?

I added in a field into the value list that is just a period"." and tried to auto-enter in the period"." on creation to field2 - this would satisfy the validating by value list, and through an auto-enter calculation if the flag on Field1 is set to "flag" then change field2 to "need to enter..." as was the calc orignally.

But when I add the validation for member of a value list, the auto-enter calc does not work nor does the valiation on the field.

Can anyone help me? Let me know if this is clear, or more info is needed.

Thanks in advance

Share this post

Link to post
Share on other sites

Validation calcs always trip me up but I think the calculation you are looking for is:


(IsEmpty(Field1) and IsEmpty(Field2)) or

Field1="flag" and not IsEmpty(Field2);


Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

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.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.