Newbies dmaloney Posted February 6, 2007 Newbies Posted February 6, 2007 I need to make a simple set up of a statement ie X + Y = Z. I would like to just have three blank fields for X,Y and Z. If the user enters any of the two, it solves for the third. The only way I can think to do this is to run an action to detect which fields are not blank and then, calculate the result of the third. Is there an easier way to do this. (I would like to use 6 variables and it gets a bit messy) Thanks
Stuart Taylor Posted February 6, 2007 Posted February 6, 2007 example attached not quite sure how to clear the fields after populating them would take a bit more work but could be done. xyz.fp7.zip
Genx Posted February 6, 2007 Posted February 6, 2007 I just tried this: Let( [a = 1 ; b = 2 ; c = 0 ; d = 0 ; e=5 ; f = 0 ]; Case( not(a) + not(: + not© + not(d) + not(e) + not(f) > 4 ; 0 ; 1 ) ) Returns 0 if more than four of the number fields are empty (i.e. if at least two aren't full). Returns 1 or true if two or more fields are filled.
Newbies dmaloney Posted February 6, 2007 Author Newbies Posted February 6, 2007 Can't seem to download your zip file.
Recommended Posts
This topic is 6561 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