h_custom fileds not populating email templates

[Dave Longley]

Hello,

I am trying to map an email template to pull through some custom text. Below is an example of the email template:

and this is what comes through:

Cuatom31 and 32 is set up correctly in the PCF but nothings is pulled through

 

Also, how can i get the date field to just display the date in the UK format? 

[Steve Giller]

Firstly, specifically for Custom32:
 

Quote

• When specifying the column you wish to map to in your custom form id, this value is case sensitive. e.g. h_summary will acheive the desired mapping but h_Summary will fail to pull any values through. Ensure that the mapped value is written in lower case.

How have you entered the variables into the template?

Using the Variable dropdown Custom 31 & Custom 32 aren't listed as available - as you're using them for names I'd suggest using a VARCHAR/255 character field (h_custom_a - h_custom_o) - as I doubt that you're going to have a name longer than that.

[Dave Longley]

Thanks @Steve Giller, mapped custom 32 over to custom A and this is what i get:

 

it hasn't picked up the name.

[Steve Giller]

 
 

Quote

• When specifying the column you wish to map to in your custom form id, this value is case sensitive. e.g. h_summary will acheive the desired mapping but h_Summary will fail to pull any values through. Ensure that the mapped value is written in lower case.

H_custom_a is not a Custom Field. h_custom_a is a Custom Field.

[Dave Longley]

thanks @Steve Giller, managed to address everytihng now apart from the date. This is what i get:

 

Leaver End Date: 2020-12-03 00:00:00Z

 

and this is ideally what i want to see: Leaver End Date: 03-12-2020.  My regional settings are a UK

[Steve Giller]

 I can't remember off the top of my head but I know that info is on the wiki, probably under wiki markup or date formatting.

I'll check when I get back from lunch if you've not already found it.

[Jeremy]

@Dave Longley So we do this in the BPM (cloud automation):

Red box is the where the original date is from the PCF, BPM, task etc, with those parameters for the input/output and then you can use the info in the blue box to update a custom field and then add that custom field to the email.

[Dave Longley]

@Steve Giller - if you could take a look that would be great.

 

Thanks @Jeremy for your advise, i have added the node in at the beginning on my BPM but it still does not change the date, it is still displayed as: Leaver End Date: 2020-12-09 00:00:00Z

[Jeremy]

Did you map the custom field 22 to the 'date outcome' of the integration node or copy the bit in blue and paste into the custom field 22 in the bpm?

[Steve Giller]

I think this forum search result has the information you need.

[Dave Longley]

@steve@Steve Giller -I have looked at your suggestion but the date is still showing incorrectly. 

 

Thanks @Jeremy for your advise, i have added the node in at the beginning on my BPM but it still does not change the date, it is still displayed as: Leaver End Date: 2020-12-09 00:00:00Z and i did map it correctly (so i thought). 

[Steve Giller]

@David Longley

How are you populating h_custom_22 with the date? Is this a Custom Form in the PCF, a variable, a Task Outcome etc?

[Dave Longley]

I have managed to fix this, by selecting a custon field (255 CHAR) instead of DATETIME and then set up the following node in the BPM:

 

thanks for all your help