Basic math to update a thing in the DB

Need help Database
1

Hey all, this seems simple but I’m struggling.

I’m having trouble with the simple calculations 7 - x = y

y = the thing i want to update in the database.
7 = static, this number will not change.
X = a field in my database that is dynamic.

Using a button click, how can. I perform this function. To change the thing to y in my database.

2

Hello!
You can go as below:

  1. Select button → Start edit/workflow
  2. Data(thing) → Make changes to thing
  3. Select Data type
  4. Select field (x)=Text (7-x)
3

Got it, had to use an option set . Thanks.

1 Like