Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Nov 10, 2020 08:23 AM
Inglés
HI.
I need to convert the following:
I insert a number in a record, for example, 155.
I need to convert or divide 155 into multiples of 40, 30 and 5.
That is, I need the following result in a column: (3 + 1 + 1) …
3 * 40 = 120
1 * 30 = 30
1 * 5 = 5
Is it possible to get it?
I need it very urgently!
THANKS!
Nov 10, 2020 10:12 AM
Sure, anything’s possible, however, doing this in a formula field could be pretty dicey. The better [mathematical] approach is to use javascript in a script action that senses the product (field) is empty and performs the computation.
As a string?
Like this?
Nov 12, 2020 11:09 AM
Hello, I already have the solution … luiggi cuozzo in the forum…(AND AEROTABLISTAS) passed it to me.
Nov 12, 2020 11:11 AM
Nov 12, 2020 11:55 AM
Yep, that’s one way to do it if you don’t mind lots of fields.