Jump to content
  • 0
Sign in to follow this  
JaredL

Copying Records from a report into new records

Question

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.

 

 

 

 

Share this post


Link to post
Share on other sites

4 answers to this question

Recommended Posts

  • 0

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]

Share this post


Link to post
Share on other sites
  • 0

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!!

 

Share this post


Link to post
Share on other sites
  • 0

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:

 

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×