External Form update to acymailing list

tayling

Hi
I am using a contact form using Breezeforms and have added a snippet that adds the form details to a mailing list. The snippet does allow adding to multiple lists BUT I wold like the user to add to another list at another date but the routine does bot work if the email address already exists. I know that is how it should work but is there any chance if the email exists it should add the user to another list?

Regards

Tony

jvstratum

Hi,

The e-mail is a unique field in Acymailing. Your script is always adding the subscriber to the database, but it will not suvveed if the e-mail already exists in the database.

You should check if the user is already present in the database and if so it should update the user instead of trying to add it again.

Here's an example how it is done in RSForm: https://docs.acymailing.com/setup/subscription-to-your-lists/rsform-pro-integration

tayling

HI
Thanks for that - very useful - I created a script but got this error - any clues?
Cannot add or update a child row: a foreign key constraint fails (collectionconsul_joomla.cca_acym_user_has_list, CONSTRAINT fk_cca_acym_user_has_list2 FOREIGN KEY (list_id) REFERENCES cca_acym_list (id) ON DELETE NO ACTION ON UPDATE NO ACTION)

Thanks
Tony

tayling

Aha - I tried to add to a non existing list
Thanks Tony

jvstratum

I'm glad you were able to solve it. Enjoy your Acymailing!