Hi all,
I’m doing a bulk mailing application.
One of fields in the form is the list of possible e-mail addresses to sent to the email.
That is a double select field that is filtered on a previous select field i.e. section_ID.
Everthing works nicely.
The problem I have, once populated the form and sended the mass mailing, when the application come back to form.
All form field are cleaned like it would be a new clean insert but the double select field that remains with the previous selected email addresses.
Is there a way to reset it and run the original select query ?
Original query of double select field.
SELECT e_mail FROM members WHERE e_mail <> ‘’
AND IF(’[glo_section_ID]’ <> 0, section_ID = ‘[glo_section_ID]’,section_ID >= 0)
ORDER BY e_mail
See image for different three step mentioned.
- first access
- selected email based on previous section field
- once finished the bulk mailing sending
OnAfterSuccess I’ve tried to insert the following lines but nothing happens ;-(( :
$sql_reset_email_to = “SELECT e_mail FROM members WHERE e_mail <> ‘’ ORDER BY e_mail”;
sc_select(reset_email_to, $sql_reset_email_to);
{email_to} = {reset_email_to};
