Data Points Appear in Table but Do Not Appear in Email Notification

Hello all, 

Context: I am a new hire patching holes in an existing QB system. 

Situation: Currently, we have a table that holds all job records that we have taken on. This table uses formulas to create a Rich Text field that will contain high level information about the job. 

List("/n","<span style=\"color: #3A55A5\"><b> Name: </b></span>" &[Customer Database - First Name]&" "&[Customer Database - Last Name],

"<span style=\"color: #3A55A5\"><b>Job Number:</b></span>" &[Job Number #],

"<span style=\"color: #3A55A5\"><b>Loss Date:</b></span>" &[Loss Date],

"<span style=\"color: #3A55A5\"><b>Job Address: </b></span>" &[Job Address: Street 1],

[Job Address: City]&", "&[Job Address: State/Region]&" "& [Job Address: Postal Code])

On the table, these values populate no problem. When there is a new job added an email is sent out containing the information from this column for that record. However, in the email notification that users are receiving, the data does not populate with the exception of 'Loss Date'. Additionally, if I try to reference the data specifically in the email template they do not populate either...

<div class="InfoContainer" id="JobInformationContainer" style="height: 100%; width: 70%; border-bottom: 2px dashed #3A55A5; display: flex; flex-direction: column; align-items: start; justify-content: space-around;">
<h1 class="Container__title" id="JobInformation_title" style="font-size: 18px; font-weight: 800; color: #3A55A5;">Job Information</h1>

<div class="Container__pointContainer" style="height: 100%; width: 100%; margin: 1% 0 1% 0; display: flex; align-items: start; justify-content: space-evenly;">
<p class="pointContainer__label" style="width: 35%; font-weight: 800; color: #3A55A5; text-decoration: underline; text-align: start;">Customer Name:</p>

<p class="pointContainer__data" style="width: 65%; font-weight: 600; color: #000000; text-decoration: none;">[Customer Name]</p>
</div>

<div class="Container__pointContainer" style="height: 100%; width: 100%; margin: 1% 0 1% 0; display: flex; align-items: start; justify-content: space-evenly;">
<p class="pointContainer__label" style="width: 35%; font-weight: 800; color: #3A55A5; text-decoration: underline; text-align: start;">Job Number:</p>

<p class="pointContainer__data" style="width: 65%; font-weight: 600; color: #000000; text-decoration: none;">[Job Number #]</p>
</div>

<div class="Container__pointContainer" style="height: 100%; width: 100%; margin: 1% 0 1% 0; display: flex; align-items: start; justify-content: space-evenly;">
<p class="pointContainer__label" style="width: 35%; font-weight: 800; color: #3A55A5; text-decoration: underline; text-align: start;">Loss Date:</p>

<p class="pointContainer__data" style="width: 65%; font-weight: 600; color: #000000; text-decoration: none;">[Loss Date]</p>
</div>

<div class="Container__pointContainer" style="height: 100%; width: 100%; margin: 1% 0 1% 0; display: flex; align-items: start; justify-content: space-around;">
<p class="pointContainer__label" style="width: 35%; font-weight: 800; color: #3A55A5; text-decoration: underline; text-align: start;">Job Location:</p>

<p class="pointContainer__data" style="width: 65%; font-weight: 600; color: #000000; text-decoration: none;">[Job Address]</p>
</div>
</div>

Weirdest of all, the data will partially populate for the Job Number # field, listing something like "JOB-000-WTR" where the type (WTR) appears appropriately at the end, but the actual ID number is consistently all 0's? 

Any help or guidance on where else to look that could cause these issues would be much appreciated. 

 

------------------------------
Alex Couts
------------------------------