{"id":32224,"date":"2022-07-25T12:57:15","date_gmt":"2022-07-25T07:27:15","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=32224"},"modified":"2022-07-25T12:57:15","modified_gmt":"2022-07-25T07:27:15","slug":"how-to-generate-a-random-number-using-rand-and-randbetween-function-in-canvas-app","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2022\/07\/how-to-generate-a-random-number-using-rand-and-randbetween-function-in-canvas-app\/","title":{"rendered":"How to generate a random number using Rand() and RandBetween() function in Canvas App"},"content":{"rendered":"

Introduction<\/strong><\/h2>\n

In this blog, we will learn how we can create one random color in RGBA format by generating random numbers.<\/p>\n

Problem:<\/strong><\/p>\n

We have a Canvas App, where we have created one Display Form. Here, we have displayed the list of categories of All Accounts in the color-coded format as shown in the below screenshot. In the below screen we want categories of all Accounts to be shown in color-coded format, so it is necessary to display all categories of Accounts in Unique colors. For this, we want to generate random colors for each industry and assign them to a specific category.<\/p>\n

\"Canvas<\/p>\n

Solution:<\/strong><\/p>\n

We can generate the random color using Rand() or RandBetween()<\/strong> function in Canvas App. Please find the below syntax for the above function.<\/p>\n

Syntax:<\/strong><\/p>\n

Rand() = <\/strong>This function will generate one random number greater than 0 but less than 1. For example 0.26786, 0.65784.<\/strong><\/p>\n

RandBetween(START_RANGE, END_RANGE) = <\/strong>This function will return the whole number between the range that we provide to the function.<\/p>\n

Where,<\/p>\n

    \n
  1. START_RANGE<\/strong> \u2013 It is a numeric value that states the starting range of the random number which we want to generate.<\/li>\n
  2. END_RANGE<\/strong> – It is a numeric value that state the ending range of the random number which we want to generate.<\/li>\n<\/ol>\n

    Note: After applying the above Power Fx function, one whole number will be generated between the range that we provide to the RandBetween() function.<\/em><\/strong><\/p><\/blockquote>\n

    Please find the below Power Fx formulas that we have used to generate the random color for each category checkbox.<\/p>\n

    UpdateContext({red:RandBetween( 0, 99 )});<\/em><\/strong><\/p>\n

    UpdateContext({green:RandBetween( 0, 99 )});<\/em><\/strong><\/p>\n

    UpdateContext({blue:RandBetween( 0, 99 )});<\/em><\/strong><\/p>\n

    In the above code we have generated the three random numbers for each industry and assigned a color to that category legend by using generated numbers in RGBA format as shown in the above screenshot:<\/p>\n

    RGBA(red,green,blue,1) <\/em><\/strong><\/p>\n

    Conclusion:<\/strong><\/h2>\n

    In this way, by using Rand() or RandBetween() function we can create or generate a random number to process any operation in Canvas App.<\/p>\n

    \"\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

    Introduction In this blog, we will learn how we can create one random color in RGBA format by generating random numbers. Problem: We have a Canvas App, where we have created one Display Form. Here, we have displayed the list of categories of All Accounts in the color-coded format as shown in the below screenshot.\u2026 Read More: How to generate a random number using Rand() and RandBetween()\u2026 »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1954,18,2361],"tags":[1867],"class_list":["post-32224","post","type-post","status-publish","format-standard","hentry","category-canvas-apps","category-dynamics-365-v9-2","category-technical","tag-canvas-app"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t