How to pass "calculation field values" to hidden fields? on different forms

 
1
0
-1

this is the syntax I used to fetch values from "select box" and the same syntax we can use  for "check box" fields.


but what is the syntax to fetch values from "calculation fields"????

    CommentAdd your comment...

    2 answers

    1.  
      2
      1
      0

      I got the proper result.

      1.copy calculation field from form1 and form2 and paste it in to main_form.

      2. Now update form data tool in main_form by using hashvariable h1=  #form.main_form.ps# , h2= #form.main_form.ps2#

      This will work for sure : )


      If you  found any different solution please do share.


        CommentAdd your comment...
      1.  
        2
        1
        0

        Hi,

        consider using form data hash variable. #form.[form table name].[calculation field field ID]#

         https://dev.joget.org/community/display/DX7/Hash+Variable#HashVariable-FormDataHashVariable

        1. Sanjana KL

          no ,it is not working for the above syntax

        2. Ian

          maybe u can share what's the calculation field id? and the table name of the form? or more details so can have a clear picture of things.

        3. Sanjana KL

          #form.q_process.ps#
          tablename: q_process
          calculation field id: ps

          I am using "multipaged form"   and I am trying to call q_process (table name ) in that multipage form.

          table name of multipaged form is -"main_form"  
          I am using above syntax #form.q_process.ps# in main_form [here I am calling q_process in main_form why because calculation field id (ps) present in q_process.


        4. Sanjana KL

          above syntax will work for particular form 
          But I want to fetch calculation field values from form_1 and I need to store the same values into  the hidden_field of main_form.

        5. Ian

          a bit confused...just to clear things out:

          from my understanding, you have 3 forms

          1st form
          form id : main_form
          tablename: main_form

          2nd form
          form id: form_1
          tablename: q_process

          3rd form
          form id: form_2
          tablename: ???

          note-1: main_form has a Multi Paged Form element that will display 2 pages which is: form_1 and form_2

          note-2: form_1 contains a calculation field (id: ps)

          note-3: form_2 contains a hidden field where you want the value of #form.q_process.ps#


          main objective : get ps value into hidden field after form submission of main_form in form data update tool?

          is this correct? 

          just FYI form data hash variable won't work unless the value has been stored in database (meaning the form has been submitted)

        6. Sanjana KL

          note1, note 2 is correct and perfect .
          note3: main_form contain hidden value.

          and the scenario repeats for form2 also
          main_form contains two hidden field values h1,h2

          form1 have [calculation field id] i,e ps

          form2 have [calculation field id] i,e ps2

          and I am trying to assign the value  "ps" to h1  and same "ps2" to h2. by using form data update tool



        CommentAdd your comment...