Forums

Hello everyone,

I'm using two forms. After a user fills out form 1, the onSubmit will call form 2 using the Show Form event. The debug information from form 1 looks like this (obviously I'm using bogus data).

Data Array:
Array
(
    [chronoform] => add_equipment
    [event] => submit
    [Itemid] => 521
    [option] => com_chronoforms
    [view] => form
    [State_Tag] => 4EF4Q4F
    [Equip_Type] => Server
    [Brand] => Dell
    [Model] => 34Q4GQ34GQ34
    [Serial_No] => Q34GR4GQ34GQ3G4Q
    [Memory] => 6 GB
    [Prod_Key] => Q34Q4GQG4
    [DOP] => 
    [Warranty] => 
    [Notes] => 
    [Surplus_status] => a
    [submit] => Submit
    [a00dfc49bfb0b3a79c47758f371bbebc] => 1
    [user_id] => bi01d35
    [date_created] => 12-18-2012
    [equipinfo] => Array
        (
            [cf_uid] => f27ec53912ed4a51a64212c7ae747ad4
            [cf_created] => 2012-12-18 02:19:24
            [cf_ipaddress] => 127.0.0.1
            [cf_user_id] => 346
            [chronoform] => add_equipment
            [event] => submit
            [Itemid] => 521
            [option] => com_chronoforms
            [view] => form
            [State_Tag] => 4EF4Q4F
            [Equip_Type] => Server
            [Brand] => Dell
            [Model] => 34Q4GQ34GQ34
            [Serial_No] => Q34GR4GQ34GQ3G4Q
            [Memory] => 6 GB
            [Prod_Key] => Q34Q4GQG4
            [DOP] => 
            [Warranty] => 
            [Notes] => 
            [Surplus_status] => a
            [submit] => Submit
            [a00dfc49bfb0b3a79c47758f371bbebc] => 1
            [user_id] => bi01d35
            [date_created] => 12-18-2012
            [cf_id] => 155
        )

    [equipinfo_cf_id] => 155
)

Validation Errors:

Array
(
)

Form 2 is displayed just fine, but I put a debugger in the onLoad to see what is being passed. Here is the debugger for form 2's onLoad:

Data Array:

Array
(
    [chronoform] => add_equipment
    [event] => submit
    [Itemid] => 521
    [option] => com_chronoforms
    [view] => form
    [State_Tag] => 4EF4Q4F
    [Equip_Type] => Server
    [Brand] => Dell
    [Model] => 34Q4GQ34GQ34
    [Serial_No] => Q34GR4GQ34GQ3G4Q
    [Memory] => 6 GB
    [Prod_Key] => Q34Q4GQG4
    [DOP] => 
    [Warranty] => 
    [Notes] => 
    [Surplus_status] => a
    [submit] => Submit
    [a00dfc49bfb0b3a79c47758f371bbebc] => 1
)

Validation Errors:

Array
(
)

I need to capture the [user_id] => bi01d35; [date_created] => 12-18-2012; and [cf_id] => 155 from form 1 to save in a table form 2 uses. The cf_id will be used as a foreign key in form 2's table.

I've tried using custom code but if this is the way to go, I can't seem to get the script correct. I've also tried using a db record loader but can't seem to get the where statement correct.

What is the best way to capture this form data. If it is a custom code, can you give me some help in how it should be scripted?

Many thanks in advance.

Hi Chris0258,

You probably need to move the MultiPage or Date to Session action in the first for after the DB Save action.

Bob