Hello

I have a form for requesting two different reports (user can only choose one), the relevant field is called 'Report' and the two possible values are ReportA & ReportB

How can I determine the name of the HTML template used based on the report selected?

eg
<input type="hidden" name="mail_options" value="HTMLTemplate=ReportA.htm,KeepLines,TemplateMissing= " />
OR
<input type="hidden" name="mail_options" value="HTMLTemplate=ReportB.htm,KeepLines,TemplateMissing= " />
(I have already created two templates called ReportA.htm and ReportB.htm which work OK if specified individually in mail_options)

The templates have exactly the same fields in but different styles & information

I think it's probably a job for derive_fields - I've already used this feature to send the info to different csv files but I just can't figure out the formatting to change mail_options...

Thanks
lucy