1 Reply Latest reply: Jun 8, 2014 5:46 PM by gCubed RSS

    Autogenerate Currency based on Country

    das777

      Hi,

       

      When Country is selected in Category1, can we auto update the Category2 with the countries Currency??

       

      Thanks in Advance!

      regs

      das

        • 1. Re: Autogenerate Currency based on Country
          gCubed

          Yes,

          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";

          return "Unknown";

           

          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.

           

          V/r,

          Gene