Adobe Document Generation Yes/No in word Table

[jsbev]

Hi,

I have been ableto use adobe document generation to map the fields from an excel data source into a word template. The excel file has columns with Yes/No values which needs to reflect on the word template in a table.

Option 1 - Check the correct option in the table

Option 2- if option 1 is not possible show the correct value in the template. i.e if the excel row has a value of Yes, hide No and vise versa

Excel data:

Unique identifier	Authoritity for repairs, maint'nce, cleaning	Council rates	Utility connection fees	Water, sewerage + drain rates	Water usage charges
1	Yes	Yes	Yes	Yes	Yes
2	No	No	No	No	No
3	Yes	Yes	No	Yes	Yes
4	Yes	Yes	No	Yes	Yes
5	Yes	Yes	Yes	Yes	Yes
6	Yes	Yes	Yes	Yes	Yes
7	Yes	Yes	Yes	Yes	Yes
8	Yes	Yes	Yes	Yes	Yes
9	Yes	Yes	No	Yes	No
10	Yes	Yes	No	Yes	No

Below is the table in the word file. 

Repairs, maintenance and cleaning costs:	☐ Yes    ☐ No
Council rates:	☐ Yes    ☐ No
Utility connection fees:	☐ Yes    ☐ No
Water, sewage and drainage rates:	☐ Yes    ☐ No
Water usage charges:	☐ Yes    ☐ No

I was able to follow the video below to populate the word template

https://www.youtube.com/watch?v=H8Txc7Sa8Ts&ab_channel=AdobeDevelopers

Thanks

Jag

[Raymond Camden]

Unfortunately, conditional statements do not work now in table cells. You could, dynamically, create a column in your data with the right values, YES or NO, and just use the column when generating the table. 

[Philip33248621napi]

Hi, 

Just checking if the statement  "Unfortunately, conditional statements do not work now in table cells. " is still true?

On this page: 

https://developer.adobe.com/document-services/docs/overview/document-generation-api/complextablecons...

which is dated "Last updated 4/18/2023" it suggests that it is still possible to do conditional rows in a table. (I copied the JSON code and the example, and I can't make it work.)

Many thanks,

Philip 

[Raymond Camden]

It is not supported yet, but I can say a proper fix is _very_ close to being released. I'll be honest and say I probably won't remember to post here, but in general I've been posting to the forum here on updates to let folks know.

[Philip33248621napi]

Oh! I am starting a project that relies on this capability, and assumed that, because it was posted as possible, then the product would do what was stated. How close is "very close"? 

[Raymond Camden]

Can't say right now. Thar being said, the somewhat lame solution of just adding a new property to your JSON for your value based on the condition would work right now of course. 

[Philip33248621napi]

Ok, many thanks for your reply. Will work with that. Kind regards,