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 Select Randomly between a range of numbers

Maclurv
in Calculation Engine (Define Fields)

Featured Replies

I have 20 fields, and I want to select one to highlight in a random manner.  (I'm trying to build a "wheel" of sorts to select a number of points to play a game). This will return up to a two digit number: Int ( random * 100) However, there are a lot of numbers greater than 20. How can I pick just between 1 - 20? Would it be easier to have 20 records versus 20 fields?

 

Many thanks for any great ideas!

30 minutes ago, Maclurv said:

How can I pick just between 1 - 20?

To select a random number between 1 and 20 (inclusive), use = 

Int ( Random * 20 ) + 1

 

30 minutes ago, Maclurv said:

Would it be easier to have 20 records versus 20 fields?

Very likely so. Hard to be sure without knowing the purpose (what happens after the selection).

 

Edited by comment

    • Like 2
    • Author

    Thanks! That worked.

    Create an account or sign in to comment

    https://fmforums.com/topic/99905-how-to-select-randomly-between-a-range-of-numbers/
    Go to topic listing

    Important Information

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

    I accept

    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.