Formatting HTML Email Tables
Note: Client may need their SQL automation engine upgraded to use html email formatting.
Header
[!DOCTYPE html][html lang=”en”][head][title]Email[/title][/head][body]
[p]
TEXT PARAGRAPH 1
[/p]
[p]
TEXT PARAGRAPH 2
[/p]
[table]
[tr]
[td colspan=”2″ style=”text-align:center;background-color:#d2c295″][/td]
[td colspan=”6″ style=”text-align:center;background-color:#8c1515;color:#ffffff”]Before Change[/td]
[td colspan=”6″ style=”text-align:center;background-color:#d2c295″]After Change[/td]
[/tr]
[tr]
[td style=”text-align:center;background-color:#d2c295″]Room Identifier[/td]
[td style=”text-align:center;background-color:#d2c295″]Modification Specifics[/td]
[td style=”text-align:center;background-color:#8c1515;color:#ffffff”]Period Dates[/td]
[td style=”text-align:center;background-color:#8c1515;color:#ffffff”]Area[/td]
[td style=”text-align:center;background-color:#8c1515;color:#ffffff”]Room Type[/td]
[td style=”text-align:center;background-color:#8c1515;color:#ffffff”]Departments[/td]
[td style=”text-align:center;background-color:#8c1515;color:#ffffff”]PIs[/td]
[td style=”text-align:center;background-color:#8c1515;color:#ffffff”]Functions[/td]
[td style=”text-align:center;background-color:#d2c295″]Period Dates[/td]
[td style=”text-align:center;background-color:#d2c295″]Area[/td]
[td style=”text-align:center;background-color:#d2c295″]Room Type[/td]
[td style=”text-align:center;background-color:#d2c295″]Departments[/td]
[td style=”text-align:center;background-color:#d2c295″]PIs[/td]
[td style=”text-align:center;background-color:#d2c295″]Functions[/td]
[/tr]
Body
[tr]
[td][a href=”<SELECT trans_to FROM rsc_translation WHERE trans_type = ‘SERVER’>/archibus/schema/rsc-room-alloc-edit.axvw?bl_id=<SELECT bl_id FROM rsc_rm_period_notify WHERE notify_id = {notify_id}>&fl_id=<SELECT fl_id FROM rsc_rm_period_notify WHERE notify_id = {notify_id}>&rm_id=<SELECT rm_id FROM rsc_rm_period_notify WHERE notify_id = {notify_id}>”]<SELECT rm_identifier FROM rsc_rm_period_notify WHERE notify_id = {notify_id}>[/a][/td]
[td]<SELECT date_modified FROM rsc_rm_period_notify WHERE notify_id = {notify_id}> <SELECT modified_by FROM rsc_rm_period_notify WHERE notify_id = {notify_id}>[/td]
[td]<SELECT pre_period_summary FROM rsc_rm_period_notify WHERE notify_id = {notify_id}>[/td]
[td]<SELECT pre_area_rm FROM rsc_rm_period_notify WHERE notify_id = {notify_id}>[/td]
[td]<SELECT pre_rm_type FROM rsc_rm_period_notify WHERE notify_id = {notify_id}>[/td]
[td]<SELECT pre_dept_list FROM rsc_rm_period_notify WHERE notify_id = {notify_id}>[/td]
[td]<SELECT pre_pi_list FROM rsc_rm_period_notify WHERE notify_id = {notify_id}>[/td]
[td]<SELECT pre_function_list FROM rsc_rm_period_notify WHERE notify_id = {notify_id}>[/td]
[td]<SELECT post_period_summary FROM rsc_rm_period_notify WHERE notify_id = {notify_id}>[/td]
[td]<SELECT post_area_rm FROM rsc_rm_period_notify WHERE notify_id = {notify_id}>[/td]
[td]<SELECT post_rm_type FROM rsc_rm_period_notify WHERE notify_id = {notify_id}>[/td]
[td]<SELECT post_dept_list FROM rsc_rm_period_notify WHERE notify_id = {notify_id}>[/td]
[td]<SELECT post_pi_list FROM rsc_rm_period_notify WHERE notify_id = {notify_id}>[/td]
[td]<SELECT post_function_list FROM rsc_rm_period_notify WHERE notify_id = {notify_id}>][/td]
[/tr]
NOTE: Body can also use simple fields:
[tr]
[td]<to_location>[/td]
[td]<date_to_perform>[/td]
[td]<em_id>[/td]
[/tr]
Footer
[/table][/body][/html]
Was this helpful?
0 / 0