Copying Records from a report into new records

[JaredL]

I have a list report where i can edit records.  I would like to be able to edit the records, but when I save them, I don't want to update the previous ones.  I would like to save them as a new set of records.

In a way I would like to be able to "transform" a report table into a submission form.  The reason I am doing it this way is because a submission form has a fix number of fields, and it submits one row at a time.  In my case I may already have defined some events, and some of them may have a few records or rows in the report and others may have more.  Once I make changes to the rows I would like to submit them at the same time.

 

 

 

 

[LWSChad]

I don't think this isn't directly possible with a Caspio Form.

 

I think what you need here is two DataPages

1 - a report that lists the records you want to duplicate. Add an HTML Block that links to another page with a submission form. Pass the params you want in the link.

<a href="someOtherPage.html?Param1=[@field:DataField1]&Param2=[@field:DataField2]&Param3=[@field:DataField3]&Param4=[@field:DataField4]">

2 - a submission form that gets values from "External Data" Field1 = [@Param1]

[JaredL]

That was quick... thank you... I made some editing to my question before I was able to see your answer.... I'll take a look.  If you get a chance read the additions to my question thanks!!

 

[MayMusic]

Then you want to keep the last updated record in a table and history in another table. Then the URL EIQ suggested can be the destination after record update. And you can have auto-submit code in your submission page:

 

 

[JolliBeng]

Hi JaredL,

You can also create triggered actions  that will copy the data that was submitted on your 1st table to your 2nd table. Then, you can also create a 2nd DataPage where you will modify your 2nd table.

Here's a video tutorial on how to set up triggered actions.

 

-JolliBeng