Commission payout on the timer and update on real time

Need help Database
1

Hi i have build a commission system, when every midnite 12 am it will count the commission of the company total sales and spilt to all the users that contribute, but it only update the data when the user login the account. how can we make it paid when time is up and paid to the users that make contribution.

2

Hey @kcwee3 :wave:

You would need to run a backend workflow so it will run without you needing to be on the page. The backend workflows are run on the server, not in the browser. Does that help? :man_shrugging:

3

oh yes i got it working using API workflow but it only can read the first person commission and it pay to all the people using the same formula how to make it pay according to the same formula but from the different results of their sales

4

1
11609×790 38.8 KB

2
21605×646 32 KB

3
31601×788 34.6 KB

4
41601×805 41.4 KB

5
51600×852 29.7 KB

6
61597×875 38.9 KB

7
71599×826 32 KB

this my workflow not sure is there anything wrong

5

image
image1765×743 64.7 KB

this is the schedule API workflow that trigger the backend