Join drop-down element in email template

[medo]

Hello

I have one tabel join drop-down element in my form and I have also make e-mail template.
Drop-down works fine in form but in e-mail template apear just as ID value :-(
(I do not have same problem in default template - just in mine templates )

Have poroblem with date format in same template :-(

Please look attachment


Best regards
Medo

 

[cheesegrits]

I'm pretty sure both these issues are fixed in the latest SVN, see my sig for details.

-- hugh

 

[medo]

Same problem

I have updateed last SVN but I stil have same problem ( only with my e-mail template.)


E mail confirmation display corect label from join element but wrong date format from date element. ( "2008-09-27 00:00:00" )


Please find attched my e-mail tempalte

Best regarsd
Medo

 

[cheesegrits]

Hmmmm, not a lot I can do about that with Fabrik as-is, because by the time we get to sending the emails, we've already converted the date into standard MySQL format for saving into the db. And for reasons too convoluted to explain, the routine that replaces th placeholders with the dat has no clue what 'type' the element is, so can't automagically convert it back to your display ormat.

If it's really important that you format the date in the email, the only workaround I can think of is ...

Add a hidden text element (not date) called something like hidden_date.

Add a form submission script (as soon as form submitted, simple eval) to copy the date into your hidden element:

$aData['table_name___hidden_date'] = $aData['table_name___date'];

... and use the 'hidden_date' as your template place holder.

-- hugh


-- hugh

 

[medo]

join element

Thank you for replay.

Date format is not such a big problem as the fact that from drop-down join element apear ID but not value!!!. As I mention it's only hepend with my template!!
Please find attached result when I submit my form on defoult template and on mine template.

Can you help me with this case?

Best regads
Medo

 

[cheesegrits]

Try appending _label to the element name in your template (so aviser_label in this case).

-- hugh

 

[medo]

Works

It works

Thanks
Medo