But even more I hope that Mautic is gonna fix this in the future, as I believe this a very essential task when it come to enterprise Websites. So we can then use Owner of the Lead (in my case a Department) to send him a E-Mail. Every time a new Lead is created or updated and our custom field “Owner (form)” is not null and has a valid entry (User ID), the trigger copies the value from our field to the original Owner Field of the lead. It’s basically all about the MySQL Triggers. Select for example “Send form results” in Actions and set “Send to owner” to yes.So you have to create an user for every Select- oder Radiobutton-Option. Note: Values of the Radiobuttons / Selectboxes need to be set to the User IDs of your Mautic Instance. Create a form with a Radiobutton or Selectbox and set the “Contact Field” to our custom field “Owner (Form)”.
#TYPO3 POWERMAIL TUTORIAL UPDATE#
IF (SELECT count(id) FROM users WHERE users.id=NEW.owner_form) > 0 THENĬREATE TRIGGER `set_lead_owner_from_radiobutton_on_update` BEFORE UPDATE ON `leads` FOR EACH ROW Create 2 MySQL Trigger as follows (just copy the code 1:1, should work out of the box):ĬREATE TRIGGER `set_lead_owner_from_radiobutton_on_insert` BEFORE INSERT ON `leads` FOR EACH ROW.Create 1 custom field and label it “Owner (form)” - set Type to Text.Here’s what you can do, for everyone also looking something like this: Solution is tested and worked like a charm for me. So here is my solution, as I was looking for simple solution for me as well as the customer. Not talking about the problem when the user overwrite his records before the data being send.Īs mentioned this is so easy to do in TYPO3 with Powermail and so I was thinking about creating a plugin, but the documentation on this is really bad. For me it just feels so wrong and like a big error by design, when you have to create fake fields to handle formfields for such a simple task. It’s just a great and powerful tool.īut at this point it totally misses the market. I really love Mautic and its extensiveness.
0 kommentar(er)
