Forum Discussion

RussellBeaubien's avatar
RussellBeaubien
Qrew Cadet
6 years ago

Automations copying percentages, doesn't copy correctly

I have an automation that creates a new record and copies the current percent and puts it into the previous percent.

example:
[Current percent] = 15%
(When the automation runs becomes)
[previous percent] = 0.15%
I need it to be 15%

both [current percent] and [previous percent]  are numeric-percent

I am hoping there is a solution to this that is not to have duplicate fields of the number not as a percentage.
Quickbase Automations
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    If that is how it behaves, then make a new field called [Current Percent used by Automation] as a formula numeric field.  Make the formula be [Current Percent] * 100

    Then use that in the Automation.
  • EOMDevelepors's avatar
    EOMDevelepors
    Qrew Captain
    6 years ago
    If the current percent changes while the automation is triggered, you need to copy the old value of the triggered record. This can be done by scrolling down to the bottom of the copied value options and click on old values.