Thu, 24 Sep 2026
Login

How to do an auto calculation of grid 2 based on values from grid 1 ?

Confluence User - 09 Oct, 2017

How to do an auto calculation of grid2 based on values from grid 1? Also, I need this grid 2 as editable.Can anyone help to solve my situation?

forms;datalists

3

Confluence User •
10 Oct, 2017 •
confluenceUser •
•
confluenceUser •

Hi, you should be able to make use of custom JavaScript to perform such calculations. Found a similar question and answers at Make calculations and update in real time fields

Confluence User •
10 Oct, 2017 •
confluenceUser •
1 •
confluenceUser •

Hi,

This is an interesting question. I tried and make a sample app with advanced grid with some custom javascript. It looks like it is working as you requested. Please refer to my sample app. APP_gridCalc-1-20171010115825.jwa.

note: I am using v6 beta3. But I believe you can use in v5 as well.

Confluence User •
10 Oct, 2017 •
confluenceUser •
•
confluenceUser •

Thank you, Anders, for your input. 

I thank Owen Ong to do this sample for me. It works as expected. 

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Process not starting with Form submission.
Form Submission Performance Issue
Export As PDF
Select Box
one to many relationship
Can we create a dropdown field directly in a Joget List so that users can change the status of a record from the list view itself?
How to auto load client data after selecting it in a dropdown?
Retrieve image upload from form into PDF
Error storing data
How to generate unique ID using Textfield?
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print