Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following field:
Country:
Australia
Brazil
China
France
UK
US
From the country field above I want to create a Country2 field.
Country2 field values should be:
Australia
UK
US
How can I create this field most efficiently please in the script?
Hi,
ok for the second field Country2, but the question here is how you want it to be linked to the first field ?
Hi,
Both of the fields will be in the same table.
I just want Australia, UK, US for Country2 if they are present in the Country field.
why?
Hi Michael,
I think its possible with If statement,but you may need to hard code the country name.
If (Country = 'UK' or Country = 'US' or Country = 'Australia',Country) as Country2
Regards,
Binu