December 5, 200520 yr 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.
December 5, 200520 yr I cannot get any reps besides the first one to update. Guess what Extend( is for??? --sd
December 5, 200520 yr 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 ) )
December 5, 200520 yr Author 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!
Create an account or sign in to comment