When Country is selected in Category1, can we auto update the Category2 with the countries Currency??
Thanks in Advance!
You could use a function on Category2 that getCell.DisplayValue of Category1.
var country = getCell.DisplayValue(“Category1”);
if (country == “France”) return “EURO”;
if (country == "Sweden") return "Krona";
I most likely would setup Category1 as a value list and use the DisplayValue as an index into an array of currencies. I would place the currency array into the function_common.js.