Reminder of Min. Inventory Requirement

With Ragic's current available tools, we can set a minimum inventory requirement value with two methods.

Here, we use the "Inventory" sheet in the "Inventory Management" template as an example.

Daily Reminder

Step 1. Create a "Min. Requirement" Field and a "Notify Date" Field

"Min. Requirement": Set the Field Type to Numeric.

"Notify Date": Set the Field Type to Date field with IF(A6>A5,TODAYTZ(),"") formula applied.

The formula will return today's date when the "Min. Requirement" field value is larger than that in the "Total Qty" field. Otherwise, it will return an empty value.

Step 2. Configure a Reminder Based on the "Notify Date" Field

Step 3. Set up Automatic Daily Recalculation

Step 4. Arrange the Order of the Workflow in the Job Schedule

Note: Make sure that the execution time of the daily workflow is earlier than the reminder.

With the above settings, the system will send Reminders if the inventory is below the "min. Requirement" value at the time configured in the Job Schedule.

Real-time Reminder

Step 1. Create a “Min. Requirement” Field and a "Check" Field

"Min. Requirement": Set the Field Type to Numeric.

"Check": Set the Field Type to Selection field with IF(A6>A5,"Yes","No") formula applied.

The formula will return "Yes" if the "Min. Requirement"(A6) field value is larger than that in the "Total Qty"(A5) field. Otherwise, it will return "No".

Step 2. On the Listing Page, Apply a Shared View Based on "Check" Field

Step 3. Apply a Notification for Shared View Based on the View Created in Step 2.

With the above configuration, you'll receive a notification email of:

1. New records that match the query conditions (either by creating a new entry or modifying an existing entry).

2. Records that previously matched the queries but no longer do.