On ‘workstation’ doctype i have one child table
how to create a system notification on this table if ‘current_shots’ > ‘maximum_no_of_shots’ then trigger a notification
how to create a system notification on this table if ‘current_shots’ > ‘maximum_no_of_shots’ then trigger a notification
You can create a Notification with the “Send Alert On” option set to Custom. Then, in the on_update, on_change, or any relevant hook of the Workstation Doctype, add your condition and use code to manually trigger the Notification when needed. This gives you full control over when the alert is sent.