Forum Discussion

NoahBruner's avatar
NoahBruner
Qrew Trainee
6 years ago

Adding two numbers together using an automation instead of just being text

How do you add two numbers together when using an Automation? For example I want to add (99000000 + [Record ID#]) But instead of coming out as "9900XXXX". It comes out as "99000000 + XXXX". How do I get them to actually add together?
    • NoahBruner's avatar
      NoahBruner
      Qrew Trainee
      That works in a formula-numeric field, but my problem Is that I am using automation like this
    • LauraThacker's avatar
      LauraThacker
      Qrew Captain
      If you build a formula; then that will generate a value for THAT record.  If you are then trying to push THAT RECORD's output value into a NEW record, then encoding the formula would make sense.  Otherwise, if the new record should have the unique value of the [Record ID#] plus 99,00000 then simply build a formula and you do not need to encode anything anywhere, since the [Record ID#] is unique to each record regardless of deletions.
    • NoahBruner's avatar
      NoahBruner
      Qrew Trainee
      Ok, so I got it working. Since Part # is a text field, and I only want it to assign a Part # if the user puts "todo" in the Part # box. I made another field that, like you said, is a Formula-Numeric field called "This_Part#". It then does the calculation. Then the automation will check every time an "Inventory" is added or modified. If it was then it checks if Part # = todo. If that checks out it then sets Part # to "This_Part#" This is how I did what you said. Is this a good way of doing it or is their a better way?