Thu, 24 Sep 2026
Login

is it possible to do calculation with data from other form?

Confluence User - 15 Mar, 2024

is it possible to do calculation with data from other form?


i have about 3 forms, i want to take total score from all the 3 forms and calculate the percentage. help

forms

1

Confluence User •
17 Mar, 2024 •
confluenceUser •
•
confluenceUser •

Many ways to do it. If you can share your form design or table structure, it would be better.

If at database level, you can write SQL to get all of them. For example.

UPDATE mainTable SET total_score = (SELECT SUM(score) FROM
(
SELECT score FROM table1
UNION
SELECT score FROM table2
UNION
SELECT score FROM table3
UNION
) a )
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