how to set default value in second column based on first column data

mcfarland

Member
Joined
Jul 1, 2013
Messages
6
Programming Experience
1-3
Hi,
I have a requirement to get the default value in producttaxcode column based on skutype data.

Here is the scenario

If Sku Type is Fab producttaxcode column must be A_CLTH_FAB
If Sku Type is Swat producttaxcode column must be A_CLTH_FAB
If Sku Type is Notion producttaxcode column must be A_CLTH_COMPON
If Sku Type is PATT producttaxcode column must be A_CLTH_COMPON


The skutype column and producttaxcode column is comming from formfields
                                var fillForm = function (record) {
			       
			        for (var i in formFields) {
			            if (formFields[i].column != null) {
			                var currentValue = record[formFields[i].column];
			                var initValue = record[formFields[i].column + "_init"];
			                formFields[i].ref.set('value', (currentValue == null) ? '' : currentValue);
			            
			                if (formFields[i].column == 'BuyingRetrofitDate') {
			                    formFields[i].ref.set('value', (currentValue == null || currentValue == '0') ? '0' : '1');
			                }

How can i check the condiiton here if skutype column value is FAB, here we need to check for null or empty for producttaxcode. if it is null or empty need to set default value for producttaxcode column as 'A_CLTH_FAB' else we produce current value..

Because in the grid the data looks like for
skutype producttaxcode

FAB NULL
 
Last edited by a moderator:
Top Bottom