Store records for 30 days after deletion
Requirement
Deleted records must be stored for 30 days after deletion, after which they should be permanently removed from the database.
Use Case
A library management app is used to manage books, memberships, and other resources. When a membership is cancelled, it can be reclaimed within the next 30 days. After 30 days, customers need to purchase a new membership,
if required. So, cancelled membership records are stored for 30 days before before being permanently removed from the database.
Steps to follow
|
Form
|
Form Link Name
|
Field Type
|
Field Name
|
Field Link Name
|
|
Add Member
|
Add_Member
|
Single Line
|
Name
|
Name
|
|
Phone
|
Phone Number
|
Phone_Number
|
||
|
Email
|
Email
|
Email
|
||
|
Image
|
Photo
|
Photo
|
||
|
Auto Number
|
Member ID
|
Member_ID
|
||
|
Cancelled Membership
|
Cancelled_Membership
|
Name
|
Name
|
Name
|
|
Single Line
|
Member ID
|
Member_ID
|
Let's create a workflow to move deleted records from
Add Member
form to
Cancelled Membership
form
The workflow is to be triggered when a record is being deleted
,
so
we are selecting the
Form Event
as "Validations on record deletion".
3. Click
Add New Action
>
Deluge Script, and save the following
D
eluge snippet in the
Deluge editor:
- var = insert into Cancelled_Membership
- [
- Added_User=zoho.loginuser
- Name=input.Name
- Member_ID=input.Member_ID
- ];
The snippet uses the
add records Deluge task
to add
the member's details in
Cancelled Membership
form when a member's record is deleted from the
Add Member
form.
4. Next,
let's create a workflow in
Schedules
to delete the records in
the
Cancelled Membership form after 30 days.
5. Click
Add New Action
>
Deluge Script
and save the following script in the editor
- delete from Cancelled_Membership [ ID == input.ID ];
See how it works
Points to note
-
Form Event can also be set as "Successful record deletion" instead of "Validations on record deletion". However, it is safer to use the current method, since records are added to the other form before the records are deleted from the current form.
-
We can add a custom button to the Cancelled Membership form to add the member's record back to the Add Member form if a member decides to retain the membership .
Related Links
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Understanding delete record action
The Delete Record action in data access of workflows is a variant of the same action in deluge script. In the latter, you need to create the code for deleting a record in the script builder. Instead, you can use the predefined action available. When ...Add annotations
Add annotations Refer to this page to learn about the AR field You can add up to 30 annotations for each 3D model in your AR set. Navigate to the Edit mode of your app. Open the builder of the required form. Select the required AR field and navigate ...Perform end-of-month auditing using Audit Trail
Requirement Perform regular end-of-month auditing of a hardware company using Zoho Creator's Audit Trail feature. Use case All purchases and sales of a hardware company are maintained in a Zoho Creator sales management app. A record will be created ...Conditions to filter records based on Creator fields
In a nutshell Learn about the criteria that you can set to filter records and run workflows within the Creator application. 1. Overview Conditions help in filtering records from a Zoho Creator report. Based on the criteria set in a condition, actions ...Add AR Viewer
Add AR Viewer to your page Refer to this page to learn about the AR Viewer . Navigate to the Edit mode of your app. Open the page in which you want to add the AR Viewer . Click Viewer from the page builder menu on the left side. Drag and drop the AR ...
New to Zoho LandingPage?
Zoho LandingPage Resources