Jump 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.

How to use repeating field in calculation

Featured Replies

I have a repeating field defined where the user can enter the number of hours worked. I need to take than entry and multiply it by a separate field that contains a standard hourly rate (non-repeating) to arrive at a total dollar figure. The first repeating field entry works, but none of the others do.

Use the Extend() function to reference a non-repeating field in a repeating calculation field.

Of course, you could just get the result directly in a non-repeating calculation =

Sum ( Hours ) * Rate

Strictly speaking can't users enter anything in repeating field, if you keep your self on the straight and narrow - watch the BTW in this post!

http://fmforums.com/forum/showpost.php?post/302551/

Reserve repeating fields for utility purposes only, as rule of thumb could they only be shown on any layout as a calc'field ... and then try to let anyone enter anything in them :)

The straight and narrow, is here 1NF!

--sd

Create an account or sign in to comment

Important Information

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

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.