workflows

[saikumarkak]

I have a requirement that, i have a table "XYZ" and have some fields. need to query that table and the query is active is true and active status date is today. and here the main task is i need to send the mail to the users for every 2 minutes  which shows the table numbers in mail dynamically which are created on today. how can i achieve this by using workflow.

[Mark Manders · Accepted solution]

Don't use workflow for this. Go with the flow designer, because that's the current way (workflow is deprecated). 

You can run a flow on a schedule, do a look up to the records/fields and return that through a 'send email' or 'send notification' action.

Just get back to the person requesting this, because sending an email every 2 minutes is absolutely the worst thing you can do. People won't be checking on that email. They will create an inbox rule to move it to a different folder or to the trash. This requirement should be challenged.

[Mark Manders · Accepted solution]

Don't use workflow for this. Go with the flow designer, because that's the current way (workflow is deprecated). 

You can run a flow on a schedule, do a look up to the records/fields and return that through a 'send email' or 'send notification' action.

Just get back to the person requesting this, because sending an email every 2 minutes is absolutely the worst thing you can do. People won't be checking on that email. They will create an inbox rule to move it to a different folder or to the trash. This requirement should be challenged.

[saikumarkak]

in which conditions or situations, we can use workflows?

[Mark Manders · Accepted solution]

Only use it for what you are currently using it for. Workflow is the 'old way' of doing things and ServiceNow has deprecated it with the Yokohama release. When you are creating new functionality, use Flow designer. If you need to update something existing in workflow, keep it there (or move everything to flow designer). 

[saikumarkak]

Thanks @Mark Manders