RT 5.0.2 - load CF from external database

Hi, I need to load one or more fields from external data, I’ve used External CFs before to fill a short list of values but this is a different scenario.
In this opportunity the user must fill one CF (customer number) and I need to load other CFs after getting the information from an external system based on the first one.

Any suggestions?

Best regards,

Could you use an On Transaction scrip that checks if the transaction is setting your customer number CF and if it is pull data via whatever API the external data source exposes to populate the other CFs?

Thanks for the advice GreenJimil, I’ll try to do some research on it this week.