Add a value to column in other table, but also other columns are updated, like date, etc

Hello, from the “Invoice Status” table (form), I update the status value with a BOT in the “Invoice” table (excel sheet), so change the status from “not paid” to “paid”. This works but at the same time the column with the original invoice date (with expression TODAY()) is changed as well, and also the in formula generated invoice number “CONCATENATE([Company debtor ID],”-",COUNT(Invoice[_RowNumber])+1)". So my question is how can I update the status column without the other columns are automatically being updated?
Hope you can help!
Muk

0 4 176
4 REPLIES 4
Top Labels in this Space