Jump to content
  • 0

Customise table variable (task) output in email


Roosta
 Share

Question

Hello fellow Caspio users!

I have been trying to solve a bit of a problem whislt using the "Set Table Variable" function in Tasks, I can get the Task and the actual output I want to work fine which is below:

 

This emails a table that looks like this:

GSR_Card_Task.thumb.png.addae9fa88c983eaac7237b3f803551f.png

 

Email_Table.thumb.PNG.75c1d9f63bf70bbab4ec414f9074e5a5.PNG

I would like to be able to customise the table headers as at the moment it uses the table field names but the biggest issue is the date format, this is for use in the UK so the date format needs to be dd/mm/yyyy (preferably without the time component). I have tried creating formula fields to convert the date such as CONVERT(date, [@field:Aud_Date], 103) but still end up with the mm/dd/yyyy output in the table that is emailed.

Obviously localizations do not work on tables only datapages and I can't use something like CONVERT(varchar,[@field:FIELDNAME],106) in a tbale formula field that I could in a datapage. I would like to be able to use the Table Variable feature as it means I can inclcude multiple records in one email that meet the given criteria rather than sending seperate emails and formating the date to long date to get round this issue.

Any suggestions or help would be greatly appreciated!

Many thanks, Roosta

 

 

 

 

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

  • 0

In addition to @NiceDuck reply. You can also use an "expression" on your select statement and edit the name of the expression to your desired name. take note that this will still not allow spaces since it is still considered as a variable.

Task:

image.png.0fa101bb90ff5c085b07abc8c0fe896c.png

 

Email:

image.png.4d850efd44b3221b5d56af2cac3d9388.png

Link to comment
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...
 Share

×
×
  • Create New...