Adobe Document Generation Yes/No in word Table

Question

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 tableOption 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 identifierAuthoritity for repairs, maint'nce, cleaningCouncil ratesUtility connection feesWater, sewerage + drain ratesWater usage charges1YesYesYesYesYes2NoNoNoNoNo3YesYesNoYesYes4YesYesNoYesYes5YesYesYesYesYes6YesYesYesYesYes7YesYesYesYesYes8YesYesYesYesYes9YesYesNoYesNo10YesYesNoYesNo Below is the table in the word file. Repairs, maintenance and cleaning costs:☐ Yes    ☐ NoCouncil rates: ☐ Yes    ☐ NoUtility connection fees:☐ Yes    ☐ NoWater, sewage and drainage rates:☐ Yes    ☐ NoWater usage charges:☐ Yes    ☐ No I was able to follow the video below to populate the word templatehttps://www.youtube.com/watch?v=H8Txc7Sa8Ts&ab_channel=AdobeDevelopers  ThanksJag

Raymond Camden · Answer

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.

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

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

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.