can i create a custom field in table ?

edgardsayah · 2016-11-29

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 · 2016-11-29

yes, you can.. please provide more details.

edgardsayah · 2016-11-29

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 · 2016-11-29

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 · 2016-11-29

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 · 2016-11-29

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

pavithrap0992 · 2016-12-01

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?

can i create a custom field in table ?

Answers

Categories