Skip to main content
Nintex Community Menu Bar

Set the value of a number field based on another value

  • April 15, 2019
  • 2 replies
  • 21 views
Forum|alt.badge.img+1

I have a list where I have field1 called “number of items” and I have a field2 called “number of items to buy”. I would like to only have the user enter the number in field1 and then run a calculation where field2 updates with the value of first field multiplied by 2. 

 

I tried running a query to get the field1 number and store in a variable, then I set the value of field2 to be this value and then run a calculation to multiply by 2. Finally I then update the field to be the new variable. 

 

For some reason it keeps coming back with number 4, regardless of what I entered. 

 

Anyone have a sample of what this workflow should look like ? Unfortunately, I don’t have access to my work computer at the moment to show the workflow. 

 

Thanks ! 

 

Jen

    2 replies

    Forum|alt.badge.img+17
    • eharris04
    • April 15, 2019

    @JenelBen 

     

    Are you aware that you can use a calculation control in Nintex forms to achieve this in two steps. Simple add the single line of text control and ensure its set to integer to allow for numbers only.1542iB32E104907472E31.jpg

     

    Secondly, add a calculated control to the form to and the formula would be the (number field * 2). This would get the value immediately for the user upon entry. 1543iF57BDAA6800AFD99.jpg

     

    For the workflow, you can use the math calulation to get the value and multiply by 2. Its super easy and I wouldn't recommend adding a workflow variable for that but just grabbing it straight from the list via list lookup. See image below and replace title with whatever the number field is for the user. You will store that into a variable as I did which is "newvalue", then use the update list item action to update the field2 from your list as needed. 

    1544iD1648EA292C6F1D4.jpg

     

    Should be simple to get that done. 

     

     

    Forum|alt.badge.img+1
    • JenelBen
    • Author
    • April 19, 2019

    @eharris04 thank you! Very simple indeed! 

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement