Auto enter if field is blank

[pja7]

Hi,

I have a list of fields, but some of them have no information. I wish to auto enter when there is no data. For example under the field 'Connectivity:" I wish to enter USB 2.0 and under 'Weight:', I wish to enter 'Not Known' . I would only wish t do this when I don't have the data/info

I know I'm being thick, but have tried using the calculation under options and can't get it to work

Thanks in advance

Edited March 11, 2008 by Guest

[mr_vodka]

Try

Case ( IsEmpty ( Connectivity ) ; "USB 2.0"; Connectivity )

[pja7]

Thanks John, that works.

Unfortunately, it doesn't work on any existing records with blank data, only new records. I've tried with the tick box on and off for "do not replace existing value (if any)" and it doesn't seem to make any difference

Edited March 11, 2008 by Guest

[mr_vodka]

Make sure that "do not replace existing value" is unchecked. As for your existing data, you can do a find for the ones that are empty by using "=" in your find criteria.

After you find the records that have empty data, you can put the cursor in the field and then use Replace field contents with "USB 2.0". Then you can find the records that are empty for the weight field and do the same thing.

[pja7]

Many thanks, works a treat.

I'd thought of using find-replace as that solution but couldn't figure out which way to do it.

What a great application this is!

I've downloaded the White Paper for FM Novices