Forum Discussion
- LauraThackerQrew Captain
All of these formats worked for me with a formula-numeric field.- NoahBrunerQrew TraineeThat works in a formula-numeric field, but my problem Is that I am using automation like this
- LauraThackerQrew CaptainIf 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.
- NoahBrunerQrew TraineeOk, 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?