How do I get the amount value from setup based on Total Hours?

 
1
0
-1

Dear Experts,

How do I get the amount value from Profile setup based on Total Hours?

How do I put SQL statement if Im using custom HTML?

 

Thank You.

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Hi Rosadilla

      What do you mean by "Total Hours"? Do you mean total hours the user logged in?

      You can use javacripting in customHTML but it is not recommended to run SQL statements (reference: https://stackoverflow.com/questions/857670/how-to-connect-to-sql-server-database-from-javascript-in-the-browser)

      The Joget Marketplace has plugins you can write SQL statement to populate some form field, see https://marketplace.joget.org/jw/web/userview/mp/mpp/_/vad?id=jdbc_options_binder-v1

      Similarly, you can use JDBC plugin to populate a form on load, see https://marketplace.joget.org/jw/web/userview/mp/mpp/_/vad?id=jdbc_load_binder-v1

        CommentAdd your comment...