Thu, 24 Sep 2026
Login

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

Confluence User - 25 Oct, 2017

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.

custome

1

Confluence User •
26 Oct, 2017 •
confluenceUser •
•
confluenceUser •

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

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print