I have been tasked with populating two different fields from a single field. My plan was to use AA and either the Field, Field Trigger, or Expression function to populate the new fields.
Field where the values are added = FACILITYID
new Field 1 = FunctionalLocation
new Field 2 = EquipmentID
I plan to create two new entries into the Dynamic Value table
To populate the FunctionLocation field:
- Table Name: swFacility
- Field Name: FunctionLocation
- Value Method: (unsure if this should be FIELD TRIGGER, FIELD, or EXPRESSION)
- Value Info:
- IIF([FACILITYID] LIKE 'E-MA%') &[FACILITYID]
To populate the EquipmentID field (this is a numeric field that is not consistent so I can't really wild card it) :
- Table Name: swFacility
- Field Name: EquipmentID
- Value Method: (unsure if this should be FIELD TRIGGER, FIELD, or EXPRESSION)
- Value Info:
- IIF([FACILITYID] NOT LIKE 'E-MA%' OR IS NULL) &[FACILITYID]
I found a few other threads where they were using similar IFF statements, but none were using a wildcard in the expression.
Thanks in advance!
