Create a Workflow that will set a default value (message) on a field if the preferred date field is set to today's date. The message must show on real-time update and on Edit mode of the record.
1. Navigate to Customization > Workflow > Workflows
2. Preferred Custom Workflow: Click Edit
3. Click State 1
4. Bottom right corner: Click New Action
5. Click Set Field Value
6. Basic Information:
○ Trigger On: Select After Field Edit
○ Triggering Client Fields: Select Name of Date Field
Example: Date
7. Condition:
○ Use: Select Custom Formula
○ Formula: Enter nlapiStringToDate(nlapiGetFieldValue('custbody171')).valueOf()==nlapiStringToDate(nlapiDateToString(new Date())).valueOf()
Note: Change the custbody171 to the internal id of the field you prefer to get the value of the date
8. Parameters:
○ Field: Select Name of Field
Example: Memo
○ Value: Select Static Value
○ Text: Enter Text
Example: Date is equal to today's date
9. Click Save
Feel free to share us about your thoughts and tips 😊