Passing values from two fields to Calculation widget

  • forexnakedtrading
    Asked on April 25, 2015 at 7:47 PM

    Make Auto Price from last 3 digit from number Handphone

    I want to make auto price with add last 3 digit from number handphone 

    how to make this sir? this Screenshot

    Passing values from two fields to Calculation widget Image 1 Screenshot 20

    thnk

  • BJoanna
    Replied on April 26, 2015 at 3:36 AM

    It is not possible to do exactly what you want but you can make something similar. After checking your form I noticed that you already are using Calculation widget and you can reuse that field in order to make logic that will represent something similar you want to achieve.

    Here are the steps how you can achieve that.

    1. Inside of your Dropdown list you need to set calculation values which will be used in Calculation Widget. 

    Passing values from two fields to Calculation widget Image 1 Screenshot 40

    Passing values from two fields to Calculation widget Image 2 Screenshot 51

    2. Inside of your Calculation widget you need to set calculation logic which will pass No Handphone field value and Dropdown value to calculation widget. In case that you choose option 3 Decimal places in numerical results it will pass first three numbers from No Handphone field. It is not possible to pass last three numbers. 

    Passing values from two fields to Calculation widget Image 3 Screenshot 62

    Here is my demo form:

    http://form.jotformpro.com/form/51151339176958? 

    You can clone it in order to see all conditions I made. 

    Hope this will help. Let us know if you need further assistance. 

  • forexnakedtrading
    Replied on April 26, 2015 at 5:42 AM

    Nice its work :D

    I have any issue again 

    But this Status is Hidden when fill the form but its sent to my spreadsheet

    Passing values from two fields to Calculation widget Image 1 Screenshot 20

  • BJoanna
    Replied on April 26, 2015 at 11:08 AM

    Considering that your last question is not related to the original question I have moved your last question to the separate thread and we will provide you an answer there:

    http://www.jotform.com/answers/559238