How to collect information from different organization in a matrix question which has an auto calculation at the last column?

PALASH9698 · September 9, 2020, 4:18am

Dear Kal_Lam,
Good Day!
I am seeking your kind support regarding the collection of boxes and sizes from box size calculation different organizations.

looking forward to your kind response.

Best Regards
Palash

Kal_Lam · September 9, 2020, 7:45am

Hi @PALASH9698,

You could do the same by slightly modifying the matrix question type as outlined in the image below:

In the survey tab of your xlsform:

In the settings tab of your xlsform:

Data entry screen as seen in Enketo:

Reference xlsform:
Matrix Auto Calculation in Column (2020 09 09).xlsx (13.4 KB)

Have a great day!

PALASH9698 · September 9, 2020, 8:57am

Dear Kal_Lam
Thanks for your kind support.
if the box size is another measurement which we are don’t know before collect the information from other organization then how can we get the calculation .

Thanks again for your support
Best Regards
Palash

Kal_Lam · September 9, 2020, 9:23am

Hi @PALASH9698,

You could do it as outlined in the image below:

In the survey tab of your xlsform:

Data entry screen as seen in Enketo:

Reference xlsform:
Matrix Auto Calculation in Column (2020 09 09).xlsx (13.7 KB)

Have a great day!