1. Fabrik 3.9 has been released. If you have updated Joomla to 3.9, this is a required update.
    Dismiss Notice

Email List Plugin Update Rows

Discussion in 'Standard Support' started by griffin, Mar 10, 2019.

  1. griffin

    griffin Member

    Level: Standard

    I want to Update Row after email sent by Email List Plugin. The element I wish to update is a TextArea Element for notes - register__notes. I wish to add a note to the TextArea that says something like "Registration Email Sent dd/mm/yy". I can get this to work, albeit without the date being added automatically, however it deletes any previous notes entered. How do I Update Row to add a new line of text to the TextArea Element so that adds the note, preferably at the top and on separate line, without deleting previous notes and include the date?

    Thanks in advance
  2. troester

    troester Well-Known Member Staff Member

    Level: Community
    You can use the "update value" field for any SQL you need (See the tooltip
    So you can do something like
    notes = concat('Registration Email Sent',curdate(),'<br>',notes)

Share This Page