Hi,
I've been trying to send automated invoices, but my bot changes unintended values. Specifically, it seems like it rounds down the values to zero decimals of the invoice that is to be sent. It is supposed to trigger when checking all rows if some column is blank at a certain time. It sets some values for that row, send the email and changes some values again. Problem with this is, that it changes all decimal values of that row to zero decimals.
Because I was trying to fix the problem I've narrowed the process down to only setting the invoicedate, expiry date and to send the email. If I change the process to not change these values, but only to send the email, no unintended values change. Also important, this only occurs if I use the schedule event type, but not when it's a data change event type.
I really don't see the link to why the values would be rounded down to zero decimals for that certain row, when another column is just changed. Anyone who has experience with this?
Basically when changing a random value with a bot that is set on a schedule with ForEachRowInTable set to True, all decimal values of that filtered row change to zero decimals.
I forgot to mention that the columns that get rounded down are price columns.
LinkedIn
Twitter
