Jump to content
  • 0
Mylene

Save history of the field

Question

5 answers to this question

Recommended Posts

  • 0

Hi Mylene, 

 

There is a way how this can be done, but you will need to create a Table for storing updated information. How it works: 

 

There will be 2 Forms, one for updating current information and one for storing old information to another table.

Let’s say you have 2 Tables:  Table 1 with all current information and Table 2-for changed information.

 

So steps to do: 


1) Create Single Record Update DataPage based on  Table 1 , and add Virtual Fields. You should have the same numbers of Virtual Fields as the original fields. ( Like “First name”. “ Last Name”," Age" etc)

This is the Form where users will update/change their information.


All Virtual Fields will be Hidden and will receive and pass external parameters of all original fields  on exit: 

http://howto.caspio.com/parameters/receiving-parameters/
http://howto.caspio.com/parameters/passing-parameters/

2) Create Submission Form based on
Table 2. All fields will  receive parameters of virtual fields on load. 
3) Add Header/Footer element and insert the following script there: 

http://forums.caspio.com/index.php?/topic/4314-js-auto-submit-a-datapage/

The script submit the page automatically, so this DataPage will be hidden.

7) On the destination page of the Single Record Update page, select "Go to the new DataPage" and select Submission Form from the list. 

 

I hope it's not too complicated and makes sense. 

 

 

Aurora

 

Share this post


Link to post
Share on other sites
  • 0
On 9/8/2016 at 7:26 AM, Aurora said:

Hi Mylene, 

 

There is a way how this can be done, but you will need to create a Table for storing updated information. How it works: 

 

There will be 2 Forms, one for updating current information and one for storing old information to another table.

Let’s say you have 2 Tables:  Table 1 with all current information and Table 2-for changed information.

 

So steps to do: 

 

 


1) Create Single Record Update DataPage based on  Table 1 , and add Virtual Fields. You should have the same numbers of Virtual Fields as the original fields. ( Like “First name”. “ Last Name”," Age" etc)

 

This is the Form where users will update/change their information.

 


All Virtual Fields will be Hidden and will receive and pass external parameters of all original fields  on exit: 

http://howto.caspio.com/parameters/receiving-parameters/
http://howto.caspio.com/parameters/passing-parameters/

2) Create Submission Form based on
Table 2. All fields will  receive parameters of virtual fields on load. 
3) Add Header/Footer element and insert the following script there: 

http://forums.caspio.com/index.php?/topic/4314-js-auto-submit-a-datapage/

The script submit the page automatically, so this DataPage will be hidden.

7) On the destination page of the Single Record Update page, select "Go to the new DataPage" and select Submission Form from the list. 

 

I hope it's not too complicated and makes sense. 

 

 

Aurora

 

 

 

This is exactly what I need! I followed the instructions here, but none of my virtual fields I created in the single-record update is being passed. It seems to be working fine, but when I look at my Table 2 for the auto-submitted submission form, there is no data being logged from the virtual fields. Does anyone know what I may be missing? Thanks!

Share this post


Link to post
Share on other sites
  • 0

This is how I did it by a triggered action.

Note, with this workflow, you would be able to keep the previous value of a field,  it will not save the value of newly inserted record.

first, duplicate the table which you want to have a history record. go to its table design and change its ID field to a text 255 and rename it "parent_id" or any  name you want. Your call, as long as it indicates that it is the records former ID. also, make sure that this field is not set to unique.

Add an Id field and name it "History_Id" this will be the records actual ID on its current table. this is not actually a necessity but just for... best practices I guess.

Now, on your main table, create a triggered action that will copy the previous value of the updated fields to the history field. You may refer to this picture:
701428552_Historytrigger.png.6c684018185ccf5c933cfe269c928b81.png

There you have it.

That is only the basics though.  As mentioned above, you may also want to create a timestamp field to record when a value is updated or transferred on the history field. If you have authentication, it will also helpful if you will have a dedicated field for capturing the ID of the user who made the changes.

Hope it helps, Quack
 

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

×
×
  • Create New...