Adding fields from another module in My Assistant

The query "Contracts not billed in X days" runs regularly and works great, but I would like to add in a few fields from JC (in our world, the CN contract number = the JC job number).  How can I do this?  When I pull the fields in, they display but all are blank.  Something is not working right. 

Parents Reply
  • 0 in reply to Jesse Gordon

    It is the email form on the My Assistant task (pre-existing, was called "Contracts that have not been billed in specified days" and I modified it with date specific to 90 days).  It auto-generates an email with a table of information in it.  I can select various fields but don't know how to properly tie them so that they actually populate.

Children