Skip to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Problem with Repeating Field Calc

Featured Replies

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.

I cannot get any reps besides the first one to update.

Guess what Extend( is for???

--sd

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

)

)

  • 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

Important Information

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

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.