derive_fields for mail_options

[tvulucy]

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

[asket]

..perhaps you've already read it... if not, maybe it's an approach to your problem (topic called "Conditional Derivation"): http://tectite.com/fmhowto/derived.php

[tvulucy]

I did spot the conditional derivation option but I think that's based on whether a given field is empty or not, rather than the contents of the field.

I'm getting stuck because the HTML template is like a field within a field...