I’m setting an automation to copy a value from a lookup field (formatted as currency) to a currency field.
The tests run fine, but the automation doesn’t get the value from this lookup field when it goes live. It works if I set a manual value in the automation, so it seems something wrong with getting the value, the field type or something like that. Has anyone hit the same issue or has something to add to help?
My gut says that it’s because lookups return arrays most of the time, not single values, even if they’re only pulling from one linked record. The extra formula field is one way to force it to a single value. Another would be to not pass the value in the input variables, and instead grab it from the script itself using getCellValueAsString, converting to a number after that.