How can I ref with multiple ref table in 1 row in the table

merpoj
New Member

0 5 164
5 REPLIES 5

Aurelien
Google Developer Expert
Google Developer Expert

Hi @merpoj

Welcome to the community.
Can you elaborate ? What are you trying to achieve ? Where are you facing an obstacle ? What did you try so far ?

As you see my picture, I cannot generate with 3 ref table in the google doc in one row of the table

And the result is shown like this.

3X_6_9_690c637d7dae89459b73cae9e8039b085276acad.png100%75%50%image

Please note that you have syntax errors that are affecting the document generation.

Error 1 - no table able to be identified. START expressions need to provide a List of rows to operate on. Common STart expression would look like this:

<<START: TableName[Key Column]>>
OR
<<START: SELECT(TableName[Key Column],  [Some Other Column] = "Criteria")>>
OR
<<START: [Related Child Rows Column]>>

Error 2 - It seems the specified column name โ€œ[W1โ€ is missing a closing bracket

Errors 3 and 4 - Cannot find columns. These could be due to the improper START statement

Error 5 - End statements must be enclosed like this - โ€œ<>โ€

Aurelien
Google Developer Expert
Google Developer Expert

Yes, thank you for further explanation.
Nested tables are not always correctly supported the way you built it.

I suggest:

  • merge white cells taht are relating to the same information
  • insert a new table in it, with 3 column
  • set your start/end statement within this โ€œinside-tableโ€

Something looking like this:
3X_b_1_b1db4bab8435f311220095c8c18496f8a0851d1f.png

I know it can work on a specific way (I made it work few month ago, for testing purpose), but I donโ€™t know if that will match the way you are trying to make it.

Top Labels in this Space