can i create a custom field in table ?

edgardsayah

can i create a custom field to be filled from another field in the same table where i need to replace empty value with a specific value?

mohana_cse06

yes, you can.. please provide more details.

edgardsayah

i have a field in a table where in some record that field value is empty . so i need to create a custom filed in the same table to be filled by same value but when i have empty value i want it to be replaced by N/a.

mohana_cse06

yes, you can create a batch job/codeunit to copy the data from old field to new field and if it is empty then N/a.

Kishorm

If it's another field in the same table then you should do it using the OnValidate trigger of the original source field. You should add something like this...

IF "Original Field" <> '' THEN
  "Destination Field" := "Original Field"
ELSE
  "Destination Field" := 'N/A';

RockWithNAV

Follow what suggested by either Mohana or Kishoram.
Make new fields in 50000 series.

pavithrap0992

If the purpose is to replace the empty values with N/A, why do you have to create a custom field and copy the same values?