I am trying to do the same thing.

The integrator seems like a very complicated solution, I wouuld have to figure out which fields do what in the acajoom tables.

(& then figure out the php to send the confirmation email)

using fabrik I was able to do this with the 'jump page option - acajoom has a 'remote-subscription' feature, in fabrik I would just put the code '' in the 'jump page' field and acajoom would do the rest.

Is it possible to designate a jump page with breezing forms?

using the integrator option there are two tables for acajoom which need to be filled out - the subscriber table (where the name & email address is stored) and the queue table (where the list information is stored.)

most of it seems fairly straightforward until you get to the id (in the subscriber table) and subscriber_id (in the queue table)
- both need to be the same value
- and both need to be unique to the subscriber

is there a way to set an element to create an incremental value?

eg if I fill out the form I create a value of '1', if someone else submits the form they create a value of '2'

etc

or is it possible to reference the database id of the submitted form?

everything else is working
- the person submitting the form is being added as a subscriber - and is automatically being given an id in the subscriber table

-the queue table is being updated with the correct list #
HOWEVER the subscriber id is coming up as '0' (needs to be the same value as the id field in the subscriber table)

is there a way to run an sql update query to update the subscriber_id field in the queue table with the id value which is created in the subscriber table automatically upon submission?

I`m getting closer here - I`ve worked it out so that the query


updates the queue to add the subscriber to at lease a master mailing list (without a sequential element it`s the best we can hope for)

How ever, I haven `t been able to get the php 'Finalize Code' working - could you please advise how to wrap the sql syntax so that the php works?
I`ve tried

and

as you can see I`m just shooting in the dark here - any suggestions would be greatly appreciated

Hello has anyone been able to do this? I am looking to do the same thing?

I was able to get it working.

Because the acajoom uses 2 tables - 1 for user info & 1 for mailing info it`s a bit tricky.

What I wound up doing was running a query in the finalize code part of integrator that updated the 'jos_acajoom_queue' table with some info from the 'jos_acajoom_subscribers' table
* note
-in these tables subscriber_id = id
-to assign the user to a list (in this case list 1) I assigned the 'receive_html' field (which I gave a value of 1 and set as hidden) to the list_id field

here `s the code I put into the finalize code section of integrator

// Connects to your Database
mysql_connect("localhost", "user_name", "password") or die(mysql_error());
mysql_select_db("db_name") or die(mysql_error());
$data = mysql_query("INSERT IGNORE INTO `cross_acajoom_queue` ( `subscriber_id`,`list_id`)
(SELECT id,receive_html FROM `cross_acajoom_subscribers` )")
or die(mysql_error());

hope this is helpful

***REMINDER***
always make a backup of your sql db before trying anything like this!

Hello I have watched the video on integrator and tried this I can't see anything about the finalize code and can only see the options for insert or update but since we only want to insert a record if there isn't one there already I can't see which one to use. Since you are writing the code out anyway why would you even use the integrator? Why wouldn't you just put the code into the PHP that executes when you submit the form? I notice also there is a solution on Acajoom where you can subscribe via an external form www.ijoobi.com/help/acajoom/subscription...ernal-form.html#form however it only works for the pro version.