I have a question, in a database I have a column named “STATUS” which I want to modify when registering a payment value in my PAYMENTS table. That is, suppose we add a person and the STATUS of the person appears as INACTIVE, and once the payment is registered, it appears as ACTIVE as long as the person’s payment is in the current month, and until the first day of another month starts, it returns to INACTIVE until another payment is made.
You could do both of these using a bot. The first to trigger on the data action of adding a person. This calls an action to change the status. The latter you’d trigger on a schedule have had a different action to update the status.
1 Like