CASE WHEN {systemnotes.date} >={now} – INTERVAL ’30’ MINUTE AND {systemnotes.field} = ‘Total Picked Quantity’ THEN ‘T’ ELSE ‘F’ END
Here’s how the formula works:
{systemnotes.date}: It represents the date and time of the system note entry.
{now}: It refers to the current system date and time.
INTERVAL ’30’ MINUTE: It represents an interval of 30 minutes.
{systemnotes.field}: It specifies the field you want to check for changes. Replace ‘YourField’ with the actual field name.
{systemnotes.date} >= {now} – INTERVAL ’30’ MINUTE: It checks if the system note entry’s date is within the last 30 minutes.
AND {systemnotes.field} = ‘YourField’: It verifies if the field in the system note matches the field you want to check. Replace ‘YourField’ with the actual field name.
THEN ‘T’: If both conditions are true, it returns ‘T’ (true), indicating that the field was changed within the last 30 minutes.
ELSE ‘F’: If either condition is false, it returns ‘F’ (false), indicating that the field was not changed within the last 30 minutes.
By using this formula in a NetSuite saved search, you can filter transactions based on whether a specific field was changed in the system note within the last 30 minutes.