Search - All new items entered into the system with specific custom form in use

Search - All new items entered into the system with specific custom form in use

Searching for Custom Data Form and Creating Widget

User Story

Client wants a widget that shows a count of all new items entered into the system where a specific custom form is used whether that custom form has data or not.  For the purpose of this exercise, I am building so that we are counting the item regardless of what is filled in on the form.


Criteria 

  1. Item is new
  2. A specific custom form is used regardless of the data used.  It’s possible that the custom form will not have any required fields.
  3. After I review the item, I want it to come off the list / count.


Setup

Create a new Statistic Widget or you can use an existing one.












Create a new Tag (Tags page)



Create a new Workflow (Settings > Workflow).




Name = KSP Workflow (or you can name it anything you want)


Type = Items


Attach / Detach Tags and make sure to attach the Tag you created above.


Execute Workflow When = Created



Before saving your workflow, add a Filter where you pick a field in your custom form (any field) and set parameter != to be 1234567890.  By doing this,  your saying that this workflow is fulfilled when that particular field in the form does not contain that value.  Unless the entering user inserts 1234567890 into that field, it will trigger the workflow.  The form could be completely blank or completely filled in, as long as our field does not contain that value, I get a result.


Result: The KSP_New_Item_Tag is applied when the KSP26 form is used and any field in the form is used or not. That is, as long as, the value 1234567890 is used in the field we set.


Go to Search > Items and build a new search where Tags = KSP_New_Item_Tag.  



Set Tags = KSP_New_Item_Tag


Save this search


Go to your Widget on the Dashboard and add this new search you saved making sure you Count the results.





I now have a new Widget window that counts any new item created when that KSP custom form is used.  


To get this item off the list, once the review is done, I will remove the KSP tag from the item(s).





    • Related Articles

    • How to Add Cases in SAFE

      This article will walk you through how to create a new Case from start to finish. In SAFE, you’ll create a Case first. Then you can add Items and Persons to that Case. A Case is the record that keeps everything for one incident, investigation, or ...
    • How to Pinpoint Locations on Google Maps from SAFE Cases

      How to Pinpoint Locations on Google Maps from SAFE Cases Search for all Cases you would like to pinpoint on the map: Select all cases, select “Export”, and select “All - CSV”, (If you are only mapping certain cases from your case search, then select ...
    • Creating a Currency Total Widget over a Date Range

      Creating a Currency Total Widget over a Date Range Nav Menu » Dashboard To create a Currency Total Widget begin by doing a Search on Items. Choose a date range. For a 2020 Total, we've chosen Created Date between Jan 1, 2020 - Dec 31, 2020. Choose ...
    • Settings User Admin

      Settings \ User Admin Nav Menu » Settings \ User Admin 1. From the Nav Menu on the left-hand side of the screen, select Settings then User Admin. You are now on the User Admin screen. From here, you can Add and Edit Users, or even check User Logs. 2. ...
    • Important: Cases Cannot Be Deleted Once Created

      This article will walk you through why case creation is permanent. Before saving, carefully verify the Case Number and details. Once a Case is created, it cannot be deleted or merged. This safeguard protects the integrity of your agency’s chain of ...