Hi. i'm wondering how could it be possible to create new record if it is not on the list using the trigger. i got confuse when it comes to the formula. let just say i have an inventory and delivery, on the delivery field there is a new item, how can i automatically add it to the inventory field using trigger? should i use if statement or so? if it is possible kindly help me. thanks a lot :)
It is hard to understand the use case you are trying to achieve. Request you to attach the application XML file or maybe attach screen shots explaining your scenario.