Recurring workflow update user monthly and add credit

Need help Database
1

Please help me, I don’t know how to build this.

I’d like to create a recurring workflow that triggered when 1 of the user login. After the recurring workflow scheduled and runs only 1 time daily.

The recurring workflow check all users and updates only those, who’s “next_payment_date” field is “current_date”. Change users 1 by 1 and change their credits.

I hope somebody can help me, I just can’t think… I am stucked :frowning:

I need help because of my mistake I used 60% of my workflows, so I need a help from pro users :slight_smile:

2

What is your question? If just general guidance, then :

Create a datatype “workflow_history” called that will be used to store an object everytime the workflow is run.
Then, everytime a user log-in : do a search for the last workflow_history object. Check it’s creation date, if it’s today do nothing.
If it’s not today : run your workflow.