Jump to content
  • 0

Modify Task Table or hide Header


Question

I'm using Tasks to generate an automated email that shows data from a table based on various parameters. image.png.74421a026771d64a8194fdb31df18da8.png

Message HTML:

<h1><span style="color:#0000ff;">Engineering Open Jobs Report</span></h1>
<h2><span style="color:#0000ff;">Jobs in Progress ([@variable:InProgressCount]</span></h2>
[@variable:JobsInProgress]

When the task runs, I get:

Engineering Open Jobs Report

Jobs in Progress (

Expression1

9

 

Job_ID

Request_Type

Submit_Date

Submitted_By

Cust_PO

Account_Text

Model_Number

Processed_By

Workflow_Number

Status

54889

Drawing (Proposal)

7/8/2020 2:58:57 PM

JFK

dafasdfasdfa

AccountTextHere

100

someone

 

In Progress

 

I want to be able to modify the header labels or hide them and use HTML to label the cells.  I'd also like the value of "Expression1" to not be in a table and be formatted per the HTML code.

 

Any suggestions?

 

Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0

Hello @ChristopherNORD,

As an option, you may apply your custom styles to the th tag to change the view of the table headers.

Just add the code at the top of in the message body and render Email as HTML.

<style>
th {
 //your custom values for the CSS properties
}
</style>

Screenshot for visualization:

 lkXVupT.png

In order not to display "Expression1", please replace the Table Variable with the Variable to store the count. 

In this case, you will receive the count as an integer instead of the table with the title "Expression1" and value below it.

Hope this helps.

 

Link to post
Share on other sites
  • 0
On 8/5/2020 at 9:43 AM, CoopperBackpack said:

Hello @ChristopherNORD,

As an option, you may apply your custom styles to the th tag to change the view of the table headers.

Just add the code at the top of in the message body and render Email as HTML.


<style>
th {
 //your custom values for the CSS properties
}
</style>

Screenshot for visualization:

 lkXVupT.png

In order not to display "Expression1", please replace the Table Variable with the Variable to store the count. 

In this case, you will receive the count as an integer instead of the table with the title "Expression1" and value below it.

Hope this helps.

 

Both of those worked.  Thank you!  Now need to figure out how to change the table header values.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...