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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...