Not sure of the correct terminology, however, this is what I'm trying to achieve:
Should this be done at the scripting level?
It depends. If you have a long list of customers then do it on the script or it if is only a few you can manage on the front end.
As a general principle I do everything I can in the script unless there is a good reason not to.
Could someone explain the syntax for doing this at script level and at the front end.
Thanks for helping the newbie.
In the script :
If ( logic to identify external , 'External' , 'Internal' ) as [Customer Type] ,
add the rest of your fields
I would not do it in the front end.
Retrieving data ...