Hide Row in Table if Field is emty

Documents
1

I have records where some fields can be an empty string or null.
I would like to hide these table rows in a table. I do not want to hide the entire data record, but only the field in the table row.
This affects 2 fields in the data record (Bearbeitungsstatus, Bemerkung)
The JSON input and the template are attached.
I have already experimented with the alias formatting, but it does not work.
How can I implement this?
My goal: I want to hide all empty rows in the table to save space.
Thanks. Thomas
JSON-Meine_Manglliste.json (5.0 KB)
Template_Begehungsbericht_Bauabschnitte_Einheiten.docx (36.0 KB)
Result_Mangelbericht.docx (42.2 KB)

2

Hello Thomas! I am sorry for the delay in replying you. I consulted with developers and, unfortunately, there is no way to hide a separate cell in a repeatable block with our template engine. The only workaround we found is using a macro. Our developers prepared for you a sample template that you can use. Please check and let me know whether it will work for you.

Private Sub Document_Open()
    Dim tbl As Table
    Dim row As row
    Dim cell As cell
    
    For Each tbl In ActiveDocument.Tables
        For Each row In tbl.Rows
            For Each cell In row.Cells
                If InStr(cell.Range.Text, "isEmptyRow") > 0 Then
                    cell.Range.Tables(1).cell(row.Index, cell.ColumnIndex).Delete ShiftCells:=wdDeleteCellsEntireRow
                End If
            Next cell
        Next row
    Next tbl
End Sub

Please note that you need to use the template with a create DOCX from template action and then save the result file with a DOCM extension.
result.docm (35.5 KB)
template.docm (37.8 KB)

3

Hi Evgeniy,
thanks for the support and the workaround. I will check this with real data and will then give feedback.
I want to generate a PDF from the template and I need to check if the macro will be executed.
Best regards
Thomas

4

Alright, Thomas, I am looking forward to your feedback.

5

Hi Evgeniy,
can you have a look to this post

best regards
Thomas