Newbies doostin Posted May 17, 2007 Newbies Share Posted May 17, 2007 I think this might be a strange one, or a simple one, I have no idea. Lets say I have two fields: Payment Amount and Payment Type These fields aren't always used so I can't make either one of them a requirement to fill out. However I would like if they enter a "payment amount" that payment type becomes required. Is there a way to do this? I was thinking a validation calculation? I'm not even sure how to approach this. Thanks for the help! Dustin Link to comment Share on other sites More sharing options...
Newbies doostin Posted May 17, 2007 Author Newbies Share Posted May 17, 2007 I should probably say I posted here under Value Lists because the "payment type" field is validated by a value list. If it makes sense to be posted elsewhere please let me know, thanks! Link to comment Share on other sites More sharing options...
John Mark Osborne Posted May 17, 2007 Share Posted May 17, 2007 This should work: Case( IsEmpty(Payment_Amount); 1; not IsEmpty(Payment_Type); 1 ) Make sure to uncheck the option "validate only if field has been modified". Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6161 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now