Having a lot of fun creating automations between notion and our various software using Notion, but unfortunately we’ve run into a huge issue!
Whenever a multi-select property option is automatically assigned to a record, it overwrites all existing values.
As you might imagine, this is hugely unhelpful if we are trying to use the multi-select to keep track of literally anything.
In our use case, we have purchases automatically related to a customer and a product but, additionally append the product as a multi-select property to the customer record so that we can filter for customers who bought a certain product.
This would be an excellent way for us to manage records of students for our various online programs, if it worked that is…
Is there a solution here? So far, all I can think of is creating a new property for every product and giving it a boolean value instead of using one property for all products.
But maybe the notion API has a workaround to this we can solve using webhooks?
Any help would be greatly appreciated!
Thanks,
Luke