Set a field value based on two other fields

jimcalhoun
Kilo Expert

‎11-11-2017 05:38 PM

I have a field called "CostCenter" and it is based on the value in the "CARSDept" field and the "DeskCode" field.   I have created a second table with all three fields in it that contain all the possible values as a lookup.   I need to find the matching CostCenter value based on the other two fields that are in my import file when i do an insert.   Can someone help me with the script.  

Labels:
0 Helpfuls
  • 3,510 Views
8 REPLIES 8

bernyalvarado
Mega Sage

‎11-11-2017 07:14 PM

Hi Jim,



What you need is to use choices and dependent fields.



Thanks,


Berny


0 Helpfuls

jimcalhoun
Kilo Expert
In response to bernyalvarado

‎11-13-2017 08:50 AM

Thanks, I will give it a try.



On Sat, Nov 11, 2017 at 9:16 PM, bernyalvarado <


0 Helpfuls

bernyalvarado
Mega Sage

‎11-11-2017 07:17 PM

That assumes that Field A filters down to a list of possible Field B values and from the one it's possible to filter down to a list of Field C values.



Thanks,


Berny


0 Helpfuls