Hi, I’m software and database developer with more than 30 years experience. The past 20 years I worked (in-situ) for two international organizations (Inter-American Tropical Tuna Commission, in San Diego, CA, USA, and the Food and Agriculture Organizations of the United Nations, in Victoria, Seychelles). I also have many years of experience designing/implementing databases with Sybase/SAP SQL Anywhere. It's very possible that what you want to do can be developed with an insert trigger and an associated stored procedure, but we would need to discuss more about what are the other conditions that have to be met.
If you think you could be interested in my services, please open a chat. That way we can further discuss the project, requirements, the database schema, and if you want I can also provide a copy of my CV with verifiable references.
Sincerely,
Marco García
PS: