Doc template sub list

Hi

Not quite sure how to explain this but going to do my best.

I have created an app that has part of ref rows with ref rows within them.

What I am trying to do is put the 2nd level ref rows in a doc template.

1st level ref rows are fine but I need the ref rows that sit under 1st level to be in the template aswell.

I hope someone gets what i mean.

Thanks

Blake

Hi @BlakeHammond

Please have a look here:

What you are specifically looking for is in the second link, a template is provided in the article :wink:

2 Likes

Hi @Aurelien

Thank you for your reply.

I may be being stupid I can get the parent and grandparent working in standard expression.

but I can’t if I put it between <<Start>> and <<End>>. Am I being stupid?

Thanks
Blake

1 Like

I’m not sure of understand your question ?
Never say “stupid” anyway :slight_smile:

Your syntax must be, basically :

<<Start:[Related children]>> 
  <<[ColumnA]>> <<[ColumnB]>>
  <<Start:[Related grandChildren]>> 
    <<[ColumnXgrandChildren]>> <<[ColumnYgrandChildren]>>
   <<End>>
 <<End>>

(I may be wrong but I’m pretty sure that’s it)

1 Like

Hey :slight_smile:

I tried that as per picture below. :slight_smile:

But I get the following error when running.

Error: ‘New process’ task ‘Send LogBook’ Body template. Expression ‘[Areas schedules]’ is invalid due to: Unable to find column ‘Areas schedules’, did you mean ‘Zone Schedules’?. Error: ‘New process’ task ‘Send LogBook’ Body template. Start expression ‘[Areas schedules]’ should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the ‘Key’ column of the referenced table. Error: The webhook body is empty

The hierachy goes

  • Intruder commissioning Form
    Under Above) Ref Row Panel Tests
    Under Above) Ref Row Areas Schedule
    Under Above) Red Row Area Timers

Thanks

Blake

1 Like

OK, thanks for your inputs.

That kind of result you are trying to get is very tricky to build, especially because of the inconsistency of column widths.
You will need to use some workaround :crazy_face:

To my knowledge, you can only deal with one start statement in a table.
But, you can add a table inside another cell, and use a nested Start statement inside this one.
I don’t know the limit of this nesting.

I suggest you have a look to these posts:

Let us know if you succeed into your project :slight_smile:

EDIT
I just noticed the error message you got with area schedule.
The correct sentence should be:
<<Start:[ Related Areas Schedules]>> ...<<End>>
because the second Start statement is evaluated as nested in the first statement, so it’s like you are located in the Panel Tests Table (unless you renamed the default column name with Area Schedule…in this case, please ignore this remark)

2 Likes