Calculated Database

So i have a table with a field called “CLICK”. This field gets the number of clicks of a particular button made by all users.
I also have a field called “CLICK COST”. I want CLICK COST to be the value of the field CLICK * 2.

How can i do this?

There are more than a couple of ways to go about this. The key point is that when the button is clicked, in its “is clicked” workflow Make changes to the affected thing, setting CLICK to its value + 1 and set CLICK COST to its value + 2. Assuming CLICK COST is always kept up to date, this should work.

If your scenario were more complicated, I’d step back and figure out how to calculate CLICK COST based on the original value of CLICK.

1 Like