Thu, 24 Sep 2026
Login

Adding Revision number to the record ID

Confluence User - 04 Dec, 2016

Dear Expert,

Any way to add a revision number to the record ID when the user edit the record? As my requirement need to keep the version of the record which mean the old record need to keep and create a new record for the modified data.

Best Regards

Tony Chu

forms

2

Confluence User •
05 Dec, 2016 •
confluenceUser •
•
confluenceUser •

Hi, it sounds like you need to have a custom Form Store Binder with some custom logic. You could try to use a custom plugin or some BeanShell, maybe adapt from this article Store Form Field Data to Multiple Tables (v4)

Confluence User •
07 Dec, 2016 •
confluenceUser •
•
confluenceUser •

Hi Tony,

I had same requirement and I achieved it by creating two tables. One main table and another revision table with a field 'revisionnumber' in both the tables. At end of every edit/submit by user, copy the record to revision table and increment the revision by 1. You can use 'db update tool' in 'Post Form Submission Processing' to insert/update the revision table. Main table will always have the latest/current record and revision table will have all revisions including current record.

Hope this helps!

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Process not starting with Form submission.
Form Submission Performance Issue
Export As PDF
Select Box
one to many relationship
Can we create a dropdown field directly in a Joget List so that users can change the status of a record from the list view itself?
How to auto load client data after selecting it in a dropdown?
Retrieve image upload from form into PDF
Error storing data
How to generate unique ID using Textfield?
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print