Zero Tolerence Posted December 5, 2005 Posted December 5, 2005 Here is my set up. I have clients that insist on going with IWP. And, rather than use FM's built in field validation, I was just wanting red text to appear next to things that get entered wrong. Rather than have 1 "Error" field for every field, I thought I'd use a Repeating Field. After Reading up a bit on this: http://fmforums.com/forum/showtopic.php?tid/121153/post/121517/hl/%22Repeating+Field+Calculation%22/#121517 I got the fields set the way I wanted them. It works great, However, I cannot get any reps besides the first one to update. I've tried numerous things, (Evaluate in the Choose function, putting the If statments in the Choose function, Evalueate the whole thing when either of the fields change) But haven't been able to get anything to work. Hopeing someone can help me out. Here is the last thing I tried. Evaluate(Quote(Let([ result1 = If(tProblem = ""; "You must select a Problem"; ""); result2 = If(tPage_Number = ""; "You must enter a Page Number"; "")]; Choose( Get(CalculationRepetitionNumber) - 1; result1; result2 ))); [tPage_Number; tProblem]) I'm just trying to get this test run working before I move to all the fields. Thanks for any help.
Søren Dyhr Posted December 5, 2005 Posted December 5, 2005 I cannot get any reps besides the first one to update. Guess what Extend( is for??? --sd
Raybaudi Posted December 5, 2005 Posted December 5, 2005 hi try this: Let([ result1 = If(Extend ( tProblem ) = ""; "You must select a Problem"; ""); result2 = If(Extend ( tPage_Number ) = ""; "You must enter a Page Number"; "") ]; Choose( Get(CalculationRepetitionNumber) - 1;result1 ;result2 ) )
Zero Tolerence Posted December 5, 2005 Author Posted December 5, 2005 Hey thanks a lot to both of you. This is actually my first attempt at using Repeating fields, because, until now, I didn't need to use them. Thanks to both of you!
Recommended Posts
This topic is 6993 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