I would like to be able to trigger a workflow when a user logs in.
In my use case we have a requirement for users to update records every week. If they haven’t updated it in a week, based on a boolean value in a table, various UI elements become visible.
At the moment I’m planning out how a Zapier schedule trigger can update these values for all users once a week. However that’s going to require looping through all users in the system and setting the value to true.
There would be no need for this external zap if we could just do a check when they log in, and if it’s over a week since they last provided the update, set the value.
However, I can’t do that. I also thought I could stick a workflow trigger on the Last Active At field in the user table, but it’s a system field, and the workflow system doesn’t allow me to trigger on that field updating. (This would be less efficient as the workflow would trigger every time they are active, not only once when they log in.)