Is it possible to create reference using a multivalue property to use in a loop? If not, is there a way I can count the number a entries in the property and save it to a variable? Thank you.
Hello @Chuckman ,
Use the Sum
You can use the Sum function in a workflow to get the total for a set of values. For example, you can reference the Get List method for a SmartObject to retrieve a list of records, and then use a property from the list to calculate the sum. Below is a document with an example that calculates the sum of Sub Totals for invoices to arrive at a total outstanding amount , and then insert this total value into an email as part of a workflow. Find it here: https://help.k2.com/onlinehelp/k2five/userguide/5.3/default.htm#How-Tos/SumFunction/How-To-Sum-Function.htm
Use the Set Variables step to update process variables. You have the option of setting static values manually or setting dynamic values by using inline functions, SmartObject data, and context from the workflow.
You should only store the amount of data required for the workflow, such as using record IDs instead of storing all record data in fields. This helps minimize the amount of data that is stored on the server. You may also want to disable the audit log of variables in order to further minimize workflow size and server load. Find how to here: https://help.k2.com/onlinehelp/k2five/userguide/5.3/default.htm#k2-workflow-designer/use/toolbox/basic/SetVariables/Set-Variables.htm
Use fields and control values to build an expression on a control that performs an operation and returns a value. An expression can be a short expression that refers to a field, or a longer expression with complex logic and formatting based on fields or other items, such as control values or SmartObject data. Lok here on how to: https://help.k2.com/onlinehelp/k2five/userguide/5.3/default.htm#Create/Views/ControlExpressions.htm#Operators
All the best
I have a multivalue property setup to store multiple text entries. I studied each solution suggested, but I couldn't figure out how to use any of them to get a count of entries stored in this multivalue property. Will you be able to elaborate on how I can have it accomplished. Thank you.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.