ContributionsMost RecentMost LikesSolutionsOutlook Pipeline We need to be able to send multiple documents, if they are attached or not. I have this working, but if the middle document is blank, it will error out. If the first two have attachments but the 3rd doesn't, it's fine. Any thoughts? Attachment Name: {% if a.well_report_document.file_name is not none %}{{a.well_report_document.file_name}}{% endif %} {% if a.mud_report_attachment.file_name is not none %}{{a.mud_report_attachment.file_name}}{% endif %} {% if a.survey_attachment.file_name is not none %}{{a.survey_attachment.file_name}}{% endif %} {% if a.additional_attachment.file_name is not none %}{{a.additional_attachment.file_name}}{% endif %} URL: {% if a.well_report_document.file_transfer_handle is not none %}{{a.well_report_document.file_transfer_handle}}{% endif %} {% if a.mud_report_attachment.file_transfer_handle is not none %}{{a.mud_report_attachment.file_transfer_handle}}{% endif %} {% if a.survey_attachment.file_transfer_handle is not none %}{{a.survey_attachment.file_transfer_handle}}{% endif %} {% if a.additional_attachment.file_transfer_handle is not none %}{{a.additional_attachment.file_transfer_handle}}{% endif %} ------------------------------ Jeff Hughes ------------------------------ Re: Table to Table with math Ok this sounds perfect and I follow! I'll try it out. Really appreciate your insight. Jeff Hughes Founder PointFlow Companies, LLC Phone: 918-693-1835 Email: jeff@pointflow.co www.pointflow.co Re: Table to Table with mathOk, let's name them. I have these four tables: Buildings, Building Cost Records, Sites, Site Cost Records Sites to Buildings is one to Many So, I spend $50,000 at the Site. Which has 5 Buildings. I add that $50,000 to Site Cost Records. I want that $50,000 to go look up the buildings it's tied to, and divide evenly out to the the buildings. So 5 $10,000 records are added to the Building Cost Record table. ------------------------------ Jeff Hughes ------------------------------ Table to Table with mathFirst post here! Been working with QB for awhile. We have a table, call it table A with some costs. Table A has a child table, table B. Costs are entered in table A. There's another table, table C that has costs for the items in table B. I'm racking my brain trying to figure how to build a pipeline (I assume this is what it needs to be, because we need table C to be the final "source" for costs) that will take the costs in table A, divide by how many child records are in table B and linked, and then create new records in table C. Example, I put $100 in an allocation group (table A). There are three sub items in that allocation group (table B). I need my user to be able to pull an item report with costs that shows $33.33 (okay bad example with the repeating) per item. ------------------------------ Jeff Hughes Founder pointflow.co ------------------------------