1
0
-1

I have a time entry form in Joget DX7 for a day with a grid allowing to indicate several lines of reason and a quantity of hours which calculates a total number of hours.

Example:

date 01/04/2023

        project 1 : 2h

        project 2 : 3h

Total for the 01/04/2023 : 5h


I would like to display on the form, before the submission an information message if the total is lower or higher than a value stored in base for the day.

For example, for 01/04/2023 theorical value is: 8h.

The desired message should be : 

      if the total duration > theoretical duration message = "exceeded",

      if total duration < theoretical duration, message: "incomplete".  


I have done this in a datalist with sql but it is after submission.

How to do this before submission ?


    CommentAdd your comment...

    1 answer

    1.  
      2
      1
      0

      Hi, to do this before the form submission, you would want to make use of custom JavaScript. Insert a Custom HTML element, and place your custom JavaScript there. There should be many script examples out there, for example https://stackoverflow.com/questions/68967211/display-a-message-based-on-variable-value

        CommentAdd your comment...