Moving data from table1 to table2 using a datapage

[marinij]

I would like to use a datapage to gather a record from table1, then create a new record in table2, populated with one or more fields from table1.

In this specific example, an administrative user is looking at a new entry provided by a customer. The customer has populated an email field. When the administrator "approves" the entry, the email is added to a separate table (table2), which generates a password (delivered to the customer via email notification).

I don't know how to trigger the creation of the new entry in table2 and use parameters to populate the email field.

Can someone help?

Thanks...

[croixcop]

I had a similar situation; unfortunately, you can not trigger automatic new records with Caspio at this time. I developed a workout; however, it requires the user to click a submit button, then information is copied to another table.

[JolliBeng]

Hi marinij,

You can now easily insert the data from table 1 to table 2 using triggered actions.

You may also want to check this video tutorial.

 

-JolliBeng