Clean up orphaned associated items

Vladi Gubler
Vladi Gubler
February 07, 2013 | Products

Hello,

Our Associated Tasks Field allows you to create related items for any item, directly from within the parent item itself. For instance, create tasks for a support ticket while editing the ticket. You can even create new related items from the New form of the parent item, even before saving the parent item.

What happens when you decide not to save the parent item, after having created several related items? Well, as they are separate items located in their own list, they are still preserved and become orphans. How can you clean up these orphaned items?

It's actually very easy using Smart Action Pro. By simply creating a timer-based Delete List Items action, you can identify and delete the orphans automatically.

Create the following action in the related list: 

General Settings – create a new Delete List Items action and set it to run 2 hours after creating the item (gives the user enough time to save the parent or cancel):  

General Settings

Action settings – delete the current item (item with ID field equal to the current item's ID)

Action Settings

Conditions – compares current item ID to itself minus the ID of the parent item. When the parent item does not exist, it equals to zero and condition is passed, otherwise it’s a positive number, condition fails and item is not deleted.Conditions

This is it, save the action and it's ready to work. 2 hours after creating a new related item, the action is executed. If the parent item cannot be found, the item is deleted automatically, cleaning up your system.

 

 

Loading...

Add your comment

Comments are not designed to replace support calls. If you have a specific issue with one of our products, please send an email to support@infowisesolutions.com to open a support ticket.

UltimateForms

Build powerful business applications in SharePoint using only your browser.
100% No-Code Solution

It's never been easier, to create, innovate and share, all you need is your web browser!

Cost-effective

Address business process pain points immediately. Save time and money.

Fantastic Support Team

Facing difficulties installing the application? Contact our fantastic support team.

support@infowisesolutions.com

Related Topics


Copyright © 2018 - Infowise Solutions Ltd
The awesome power of ULTIMATEforms

Quickly and easily turn time-consuming business processes into automated, efficient workflows.

100% No-Code Solution

It's never been easier, to create, innovate and share, all you need is your web browser!

Cost-effective

Address business process pain points immediately. Save time and money.

Fantastic Support Team

Facing difficulties installing the application? Contact our fantastic support team.

support@infowisesolutions.com
 Yes, send me Infowise Newsletter.

Request a Live Demo

Book an appointment for a one-on-one with an ULTIMATEforms expert trainer.

Test drive the awesome power of ULTIMATEforms

Learn how to quickly and easily turn time-consuming business processes into automated, efficient workflows.

Have a strong start

Only thirty minutes of well-coached time can translate into great future savings in time and money. So, sit back and enjoy the ride.

It's Free

Learn how to address business process pain points immediately. Save time and money.

Eastern time zone (GMT-5)

Request a Live Demo

Book an appointment for a one-on-one with an ULTIMATEforms expert trainer.

Test drive the awesome power of ULTIMATEforms

Learn how to quickly and easily turn time-consuming business processes into automated, efficient workflows.

Have a strong start

Only thirty minutes of well-coached time can translate into great future savings in time and money. So, sit back and enjoy the ride.

It's Free

Learn how to address business process pain points immediately. Save time and money.

Eastern time zone (GMT-5)