Forum Discussion

NoahBruner's avatar
NoahBruner
Qrew Trainee
7 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 g...
Quickbase Automations
Laura_Thacker's avatar
Laura_Thacker
Qrew Commander
7 years ago


All of these formats worked for me with a formula-numeric field.
Laura_Thacker's avatar
Laura_Thacker
Qrew Commander
7 years ago
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.