February 6, 200718 yr Newbies 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
February 6, 200718 yr 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
February 6, 200718 yr 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.
Create an account or sign in to comment