How to create field based on other field

Naps_230 — Tue, 22 Jul 2025 17:59:49 GMT

Hi All,

I have some data. I need to create field 'Home Away' based on 'Ground' Field .

if Ground out of India it will be Away otherwise Home in script.

Please any one help me.

Re: How to create field based on other field

YoussefBelloum — Mon, 23 Apr 2018 08:33:39 GMT

Hi,

it is better to have/create a field "country" where you can found the Country related to each Ground, like this

Ground | Country

Melbourne | Australia

Manchester | England

Bengaluru I India

Delhi I India

then you can do this: If(Country<>'India','Away','Home')

otherwise if you don't have such column, you should hardcod it on the script..