I need to save history of changes of the fields in my table.
For example, if a user changes his address I'd like to save his old address as well.
Thanks in advance!
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.