Applying format & map to email delivery

I'm having a really hard time getting any value formatting to work in my docx creation, and the email delivery of that docx. Attached is a screen cap of the two I'm trying to work on first...I'm trying to format the DealRevenue field into currency and the NewLogo into either "New Logo" or " ". The NewLogo field is populated by true/false through a toggle control in my public form.

{{NewLogo}:map(True = New Logo, False = [ ])}

Any help would be greatly appreciated!!

Capture|690x416

Hello @dchapek,

Does the formatters work for the source template? I mean is the result docx shows the data correctly? If not please share the docx template and an example of the data (JSON). You can also send the data to support@plumsail.com, we'll keep discussing the issue in a support ticket then.

Best regards,
Petr
Plumsail team

Thanks, Petr!

No, the formatters are not working in either the created docx or the email delivered. I've emailed support with the content you asked for...but I'll post it here too.

Attached is the docx template I'm using and a copy of the JSON is below. Thanks for your help with this!

{
"ClientName": "value1",
"DealRevenue": "value2",
"AccountExecutive": "value3",
"Client Name": "value4",
"NewLogo": "value5",
"SalesVertical": "value6",
"CompetitiveWin": "value7",
"CompetitivePartner": "value8",
"SFDCLink": "value9",
"ClientDescription": "value10",
"GrowthAEC": "value11",
"RiskReduction": "value12",
"OperationalEfficiencyAEC": "value13",
"WinningBusiness": "value14",
"QualityOfWork": "value15",
"Scheduling": "value16",
"GrowthMFG": "value17",
"OperationalEfficiencyMSD": "value18",
"CompetitiveAdvantage": "value19",
"Innovation": "value20",
"Opportunity": "value21",
"Results": "value22",
"AdditionalOpportunities": "value23",
"Team": "value24",
"ExtendedTeamsUtilized": "value25"
}

IMAGINiT_Wins.docx (13.7 KB)

1 Like