Hi everyone,
I’m working on a points-based system for my app and I’m hitting a wall. I need to update the point balance for two different users when a button is clicked in an ‘Ad’ detail screen:
The Author of the ad needs to receive/lose points.
The User who clicks the button needs to receive/lose points.
I have successfully captured the ‘Clicker’ email in the Ad row using a ‘Set column value’ action, but I am struggling to increment the points for both parties simultaneously without the action affecting the wrong row or causing conflicts.
I currently have relations set up, but the workflow keeps modifying the same row or failing to target the ‘Clicker’ user specifically.
I cannot use ‘User-specific’ columns for this, and I want to avoid complex ‘If-else’ conditions that break the button visibility.
Does anyone have a clean, scalable way to handle two-way point updates in a single workflow? Should I be using a separate ‘Transactions’ table for this, or is there a way to trigger updates across two relations effectively?
Any advice on the architecture would be greatly appreciated. Thanks!"
You could use a Manual Trigger server side workflow.
- pass it 4 values:
– User 1 email address
– User 1 points adjustment value
– User 2 email address
– User 2 points adjustment value - within the workflow:
– Query the users table, filtering by User 1 email address
– use Set Column values (or increment) to make the adjustment
– Repeat the above two steps for the second user