{"id":36226,"date":"2023-10-16T15:20:41","date_gmt":"2023-10-16T09:50:41","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=36226"},"modified":"2023-10-16T15:49:16","modified_gmt":"2023-10-16T10:19:16","slug":"pro-tip-how-to-use-updateif-in-canvas-app","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2023\/10\/pro-tip-how-to-use-updateif-in-canvas-app\/","title":{"rendered":"Pro Tip – How to use UpdateIf() in Canvas App"},"content":{"rendered":"

Let us explore the use and functionalities of the UpdateIf()<\/strong> Function using some simple examples.<\/p>\n

Requirements<\/strong><\/h2>\n

Suppose, we have created a data table in our canvas app, where we have some records. We have created an option set field on the Account form with the name \u2018Preference\u2019 where we have different options i.e. Basic, Premium, etc. We need to set Premium<\/strong> as the value of the preference field for the records that have annual revenue of more than $5,000,000. The value for preference should be set for all records present in the table at the click of a button.<\/p>\n

To achieve the above customer requirement, we have created a Canvas App and tried to implement it using the UpdateIf() Function.<\/p>\n

UpdateIf Function<\/strong><\/h2>\n

To change one or more values in one or more records that match one or more conditions, use the UpdateIf function. Any formula that returns a true or false result can be used as the condition, and it can explicitly refer to specific columns in the data source. Each record’s condition is evaluated by the function which updates any records for which the result is true. UpdateIf, return a table using the changed data source.<\/p>\n

Syntax<\/strong><\/h2>\n

UpdateIf<\/strong>( DataSource, Condition1, ChangeRecord1 [, Condition2, ChangeRecord2, ….])<\/p>\n