Adobe Document Generation Yes/No in word Table
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
AdChoices