Solved: Add related table content to google doc template - Page 2

eldderri

Hi friends,

In my app , I am facing a small problem as I want to insert 3 columns content in my google doc template as the template is based on "Checklist" table and those 3 columns are in the child table "ChecklistDetail".This latter is ref to Checklist table with "ChecklistID".

The columns I want to insert in my template are named:

Descrepancy 1, Descrepancy 2,Descrepancy 3

The 3 columns in some cases ,should not be all filled .as we can find only one or two filled .

Best regards,

Suvrutt_Gurjar

You may need to do some testing for that error.

Please take the expression out of a table cell and check if it works.

Please try something like below outside the table cell.

<<START: SELECT( ChecklistDetail[DetailID],AND([ChecklistID] = [_THISROW].[ChecklistID],OR(ISNOTBLANK([Descrepancy 1]), ISNOTBLANK([Descrepancy 2]), ISNOTBLANK([Descrepancy 3]))))>>

<<IFS(ISNOTBLANK([Descrepancy 1]), CONCATENATE(" Descrepancy 1: ", [Descrepancy 1])) >>

<<IFS(ISNOTBLANK([Descrepancy 2]),CONCATENATE(" Descrepancy 2: ", [Descrepancy 2])) >>

<<IFS(ISNOTBLANK([Descrepancy 3]), CONCATENATE(" Descrepancy 3: ", [Descrepancy 3])) >>

<< END >>

View solution in original post