Hi Everybody,

I need some help / hint to solve my problem.

1. Currently i'm using joget v3 community edition, can i doing some calculation? because in the enterprise edition have field called calculation field if i not mistake. for example:-

if field a value is 0.10 and field b value is 0.49 = 0 day

else if field a value is 0.50 and field b value is 0.74 = 1/2 day

else if field a value is 0.75 and field b value is 1 = 1 days 

2. Using Text field, can i get the data from database. for example i create a staff details table, and then in the other form i want to obtain data from staff details table that i created before.

* sorry, my english is not good.

Regards,

  • No labels

3 Comments

  1. Hugo

    Hi there,

    I think you can implement it using javascript. You may want to read up on jQuery framework. For example, if you want to sum up all fields with the class "amount" and store the total in a text field with the id "total".

    var total = 0;
$('input.amount').each(function() {
    total += parseFloat($(this).val());
});
$('#total').val(total);

    Hope this will get you started. Good luck.

    1. Muhammad

      Hi Hugo,

      Thanks for your reply..im working on it..at least i learn something new :)

      1 more question, how i want to obtain data from database department? i try to use hash variable and put 'currentUser.department.name'  in the text field value, but then its not working.

      Can u / somebody help me to solve this problem.

      Regards,

      1. Muhammad

        the community edition don't have that function..coz i try the enterprise edition..and just put 'currentUser.department.name'  in the value field and its working.

        Regards,