Skip to main content
Johannes Bergmann が「#Formulas」で質問
Hello,

I am trying to find a solution for the above-mentioned problem. My colleague has asked me to create an automated email reminder to users who did not login for 30 days. As the "last login date" field is not accessible by formulas it is a bit of a struggle.

I already asked at the success community https://success.salesforce.com/answers?id=9063A000000pIPjQAM⌗ but It does not lead to a success.

Use process builder for sending user-based email alert on last login

User-added image

User-added image

User-added image

User-added image

I set everything up like in the pictures shown, but I do not get anything, I also tried setting it to 1 hour after last login, but it does not fire. I read there might be a solution with apex, but I am not really into coding to figure something out.

Anyone who has an idea how to solve it? Thank you for your help!
1 件の回答
  1. 2017年7月11日 22:14
    Hi Johannes,

    There is an obvious solution with a daily scheduled batch in apex (I wrote that kind of batch at work and I will post this kind of solution if the flow failed). The apex solution works fine without a lot of code but the most interesting challenge is to write a solution "zero code" which can replace the entire apex solution.

    The alternative for the apex scheduled batch is an autolaunch flow activated by a Time-Dependent Workflow Rule (must be tested).

    https://developer.salesforce.com/docs/atlas.en-us.salesforce_vpm_guide.meta/salesforce_vpm_guide/vpm_distribute_system.htm

    David Litton is a Visual Flow expert  (currently working as a Solutions Architect at Ad Victoriam Solutions) :

    He wrote very interesting "zero code" solutions:

    https://salesforcesidekick.com/2015/12/16/how-to-setup-a-recurring-scheduled-process-builder-andor-flow/

    https://salesforcesidekick.com/2016/05/02/how-to-send-an-email-in-visual-flow/

    This kind of solution are knew very little but Salesforce offers major tools for creating solutions "zero code".

    The problem is the mass email sendings by the flow. David Litton seems to confirm that he built a solution with a loop.

    Hi Johannes,There is an obvious solution with a daily scheduled batch in apex (I wrote that kind of batch at work and I will post this kind of solution if the flow failed).

    The solution could be as simple as that but I don't have the working solution currently ( I am a self-learner for the flows ).

    I will test it during the following days inspiring by the David Litton's works and post a solution here if that works fine.

    Best regards

    Alain
0/9000