1
0
-1

Dear Joget team, 

I have created a form with I need to retrieve a specific field ID into the email tool. Please support me how to link them to the email. 

Thank you 

    CommentAdd your comment...

    4 answers

    1.  
      1
      0
      -1

      Hi Thang

      For hash variables to work, the following must be true:

      1. The hash variable #form.table.fieldname# must match exactly the database table name as defined in your form and the fieldname must also match exactly. Realize that the values are case sensitive.
      2. Your email tool is accessing the same table that is storing the process id. In other words, if your run process form table name = myTable, accessing the fields in the Email Tool = #form.myTable.fieldname#. If the Email Tool is referencing another table, you need to provide an index to point back to the process form, example: #form.hisTable.fieldname[{form.myTable.id}]#.

      You can get more information on hash variables from Hash Variable in Joget Knowledge Base.

      1. thang

        Hi Matthew, I made it. Thanks for your support.

      CommentAdd your comment...
    2.  
      1
      0
      -1

      Hi, 

      I could not retrieve the output from the email. 

      Here are steps I have done:

      1. Form designed
      2. Define fom field in Email:

      But the result is not show as expected.... Please advise.

       

      Thank you

       

        CommentAdd your comment...
      1.  
        1
        0
        -1

        Hi Thang

        For example guide on your question above, do download and explore the free app for Service Help Desk which uses hash variables in email (Process>Map to Tools).

        There are an amazing number of free apps in Joget Marketplace which you can learn from and that will meet your programming needs.

          CommentAdd your comment...
        1.  
          1
          0
          -1

          Use Form Data Hash Variable - Hash Variable#FormDataHashVariable

            CommentAdd your comment...