{"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 »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"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":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/32224","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=32224"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/32224\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=32224"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=32224"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=32224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}