Jump to content

Problem with Repeating Field Calc


This topic is 5775 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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

)

)

Link to comment
Share on other sites

This topic is 5775 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.