How can I change the name of the list as a text?
I have a list name 'Group' and it has "city", "state", and "country" as value.
Then, I have other lists named 'City', 'State', and 'Country' and those list contains its own items.
City = New York, LA, Chicago, Dallas......
State = NY, CA, IL, TX.......
Country = US, CA, ......
In a module, I have three line items named "city", "state", "country" and its data type is assigned as 'City', 'State', 'Country' list and open for user input.
Then, I have another line item called "type" and its data type is assigned as 'Group' list.
If I want to write a formula for this "type" line item to show the type of group that is filled in at city -> state -> country order, how can I write the formula without hard coding the text field??
I came out with this formula and it does the job that I am looking for, but I would like to know a way to do the same job without hard coding the text as "city" or "state"
Your help is highly appreciated.