calculated column to create a dynamic number

Unknown

calculated column to create a dynamic number

Unknown

Hi,

I need help creating a calculated column to create a dynamic number based on input fields. Can you help me about below questions?

1) Create unique number based on form inputs and "current date"

2) Need to assign numeric values to string dropdown selections

3) Create a dynamic calculation that will update while the "Status" of the form != "Closed"

4) Calculation will include a log function

Thanks

Unknown

[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]Hello,[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]
[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]Question-1. You can generate a Unique Id by using the Generate GUID Step. If you want it to be based on form inputs you can create a Data Flow in your form and use the same step in the Data Flow. Please check below documentation for more details.[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]
[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif][b][url=https://documentation.decisions.com/docs/generating-a-unique-id]Generating a Unique ID[/url][/b]
[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif][b][url=https://documentation.decisions.com/docs/using-flow-data-form]Using Data Flow In a Form[/url][/b]
[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]
[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]Question-2. You can switch the input type of a drop-down list component on the properties panel of that step. If you need to convert data please check below documentation.[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]
[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif][url=https://documentation.decisions.com/docs/using-converter-flows][b]Building and Using Converter Flows[/b][/url]
[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]
[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]Question-3. Please check below forum post about basic dynamic calculation example.[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]
[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif][b][url=http://support.decisions.com/forum/topic1602-how-can-i-show-totals-of-numbers-on-the-same-form.aspx]Dynamic Calculation on the Same Form[/url] [/b]
[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif][b]
[/b][/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]Question-4. Please check below documentation for supported calculations including Logarithmic and Exponent Functions.[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]
[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif][b][url=https://documentation.decisions.com/docs/evaluate-dynamic-expression]Evaluate Dynamic Expression[/url][/b]
[/font][/color]

[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]Regards[/font][/color]