Hi,
We are proud to announce the new action type we just added to Smart Action Pro, our "Swiss army knife" for building real-life integrated business applications based on SharePoint lists.
The new action will calculate a summary of column values in all items, corresponding to filter, located in any list of any site. This summary, which can be count, total, average and so on, can then be used to update the current item or you can validate it against a predefined condition to raise an error. You can even prevent saving the current item if the condition does not apply.
Just imagine building a conference room reservation system. You can check if reservations exist for the same (or overlapping) timeslot and prevent creating the reservation, you can even specify your own custom error message. Another example - calculate the average sales price of a house in a specific neighborhood, just as easily!
Get the fully functional 30-day trial version now!