How to put a serial/pholio numer to the opportunities created?

This can easliy be done via a Logic Hook; if you are working with a partner, please contact them to discuss your requirements. If you want to tackle this yourself, you'll need to understand the Sugar framework and PHP. The developer information on building a Logic Hook can be found at support.sugarcrm.com/.../

Hi Ángel Ruiz

Once the Number of the Opportunity will be defined in the db layer (perhaps as an autoincrement field), then you should set such calculated field in a logic_hook after_save.

The logic hook code may looks like that:

function setTag(SugarBean $bean, string $event, array $arguments) {
    $bean->tag_c = substr($bean->business_center_name, 0, 1) . date('y') . substr($GLOBALS['current_user']->first_name, 0, 1) .  . substr($GLOBALS['current_user']->last_name, 0, 1) . $bean->opp_num_c;
}

Regards

Hello Ángel Ruiz

Welcome to the Sugar community club!

In many cases, there is no need to be a developer to perform Sugar configuring.
If you are a Sugar admin or Sugar Partner consultant, you can use Logic Builder for Sugar to draw logic hook and get ready-to-use extension in a click

Here is how your task implementation may look like (to read follow the white line):


As you can read from Logic, it works whenever new Opp is saved
Createuser Firstname, createuser Lastname , createuser Business Center and year of the current date of opp created are used to concat new Tag name for the newly created opp.

The autoincrement field that would fit generate Opp number demand is not avaliable right now - it is announced in Q4 2020 Sugar release  (you may read about it here https://sugarclub.sugarcrm.com/dev-club/b/dev-blog/posts/nearly-everything-you-need-to-know-about-the-q4-2020-release)
So far, for example, the Opp.Description may contain the Opp number added by user manually. 

Anyway, the Tag will be always unique for each Opp, therefore it should be created prior assigning to the Opp then linked to Opp -you may see it in the flowchart

Here is zip extension generated by Logic Builder for this flowchart
You may install via Admin -> Module Loader:

z20200923_flowchart_lb5f6b136e527e68_11358065.zip

Please let me know if any questions

And one more thing
As a Sugar Consultant I have doubts if setting unique Tag is a solution - Tags are used for referencing records of different modules  to some commonality, which is expressed in the Tag name.

Therefore creating unique tags one per Opp record does not correspond to the idea of the Tag

Consider adding a custom "Opportunity Code" field for the Opportunity for search purpoces and filling out it with the value according to the logic  you requested avoiding Tags usage

If you have questions , feel free to write to dch@integroscrm.com

All the Best, 
Dmytro

Thank you for the helping hand! Appreciate it!

Thank you so much for the helping hand! I really appreciate that you took the time to write that down, it is really helpful! 

Thanks a lot! That will do it! Also I will take in consideration your suggestion because that makes a lot of sense to me! Appreciate the support!