Matrix View creates duplicate draft records when entering multiple measures

General
1

Hello,

I am building a proof of concept for an annual education data collection using a parent form with an Education Results subform.

Each Education Results record should be uniquely identified by:

  • Indicator

  • Education level

The same record contains three quantity fields:

  • Male

  • Female

  • Submitted total

I configured a Matrix View with:

  • Rows: Indicator

  • Columns: Education level

  • Measures: Male, Female and Submitted total

The Matrix View looks correct during data entry. However, when I return to the standard Table View, ActivityInfo has created separate partial draft records for some cells instead of updating one record. This generates invalid records and therefore submission of records cannot be completed.

For example, for the same key combination:

Indicator 1 × Secondary (Education Level 1)

I see three draft records:

Indicator Education level Male Female Submitted total
Indicator 1 Secondary 100 blank blank
Indicator 1 Secondary blank 100 blank
Indicator 1 Secondary blank blank 200

These records are then marked invalid because they have duplicate keys and missing required fields. As a result, the drafts cannot be submitted, even though the Matrix View appears complete.

My expectation was that entering the three measures in the same Matrix View intersection would create or update a single underlying record:

Indicator Education level Male Female Submitted total
Net enrolment Secondary 100 100 200

Is this expected behaviour, a configuration issue, or a limitation/bug in Matrix View when creating new records with multiple measures?

There are some screenshots:
Matrix view:

Table view :

image
image1854×627 81.9 KB

I would also be interested to know whether the recommended approach is to pre-create all Indicator × Education level records before using Matrix View for data entry.

Thank you.

2

Hi Walid,

Thank you for the detailed explination of the issues.

With the details provided I was able to replicate the same issue on my side.

We are currently working on fixing the bugs and I will let you know when a new version containing the fix will be released.

Thank you,

Andrei Galusca

1 Like
3

Hi Walid,

We have addressed the issues you mentioned with the Matrix view in one of our previous releases.

Can you check to see if everything is working well on your side?

Thank you,

Andrei Galusca

1 Like
4

Thanks Andrei for your update. I tested the original issue and it seems to be fixed. Entering values directly in the Matrix View no longer creates the duplicate/ghost draft records we previously observed. Thanks for the fix

I did however notice another issue related to bulk entry. Copying a block of cells from Excel and pasting it into the Matrix View does not seem to work correctly and creates conflicts, while the same copy/paste works normally in the Table View.