I need to ADD at the end of a linked field, not replace
Images to make it easier to understand.
When a record gets the single select category “Investment from private”, this automation triggers.
This is synced directly from my business bank account every day.
This is the record i want to update:
Thought i had it covered with this automation:
Buuuuut the automation overwrites the linked records instead of adding to the end of it.
Is there any simpler way to deal with this? Do i have to use a script instead? This is for a client that deals with tons of transactions and i have to make a separate table categorizing cashflow.
Accepted Solutions
Found a solution that works if i edit each transaction at a time.
I basically had do add a find record to be able to refer to something inside the Cashflow table. Impossible to do from the trigger event because that only exists within the transaction table.
That or i didn’t understand how to do it :grinning_face_with_sweat:
Had to also add 2 if and one else statements also in order to work in all available conditions.
Think i might just solve this with a script next time as i’m adept at Javascript :nerd_face:
What i’m pulling from does not have the existing data available, only what i’m writing to has that. So how do i get that available?
Found a solution that works if i edit each transaction at a time.
I basically had do add a find record to be able to refer to something inside the Cashflow table. Impossible to do from the trigger event because that only exists within the transaction table.
That or i didn’t understand how to do it :grinning_face_with_sweat:
Had to also add 2 if and one else statements also in order to work in all available conditions.
Think i might just solve this with a script next time as i’m adept at Javascript :nerd_face:
