Creating a default value for a rich text box
If you save to the database a record with the timestamp of 2000-09-20 06:00:00.000
for that specific InputID, it will populate that rich text box with that value.
Here’s an example.
INSERT INTO tblInput_Data8 (dDate, TemplateID, InputID, DataFormattedText, UserID) VALUES (N'2000-09-20 06:00:00.000', 1, 22, N' <h2>Shift Notes</h2>
<p>Operator: </p>
<p>Production Tech: </p>
<br/>
<h3>Process Changes</h3>
<table style="border-collapse: collapse; border: 1px solid black; width: 50%;">
<tr style="background-color: #f0f0f0;">
<th style="border: 1px solid black; padding: 8px; text-align: left;">Time</th>
<th style="border: 1px solid black; padding: 8px; text-align: left;">Separator Speed</th>
<th style="border: 1px solid black; padding: 8px; text-align: left;">Separator Change</th>
<th style="border: 1px solid black; padding: 8px; text-align: left;">Feed Rate</th>
<th style="border: 1px solid black; padding: 8px; text-align: left;">Feed Change</th>
</tr>
<tr style="background-color: white;">
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
</tr>
<tr style="background-color: #f0f0f0;">
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
</tr>
<tr style="background-color: white;">
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
</tr>
<tr style="background-color: #f0f0f0;">
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
</tr>
<tr style="background-color: white;">
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
</tr>
<tr style="background-color: #f0f0f0;">
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
<td style="border: 1px solid black; padding: 15px; text-align: left;"></td>
</tr>
</table>
<br/>
<p>00:00 | Plant is running both polys.</p>', -1);