Displaying data

[jongag1]

I have a field VOICENAME which can contain a wav file name like "todaysdate.WAV".
It can happen that there is no filename available, all those empty filenames must print out the field NONAME and the extension .bad, it must show up like "agentname.bad"

I have created the formula below to check it out, it prints out the filled in VOICENAME field, but when that field is empty it doesn't print out the .bad value.

if (instr({nawt.VOICENAME},"WAV") > 0) then {nawt.VOICENAME} else
if (not(instr({nawt.VOICENAME},"WAV") > 0)) then {nawt.NONAME}+".bad"

How is this possible?

Kind regards,
Age

 

[Naith]

You don't need all that second qualification.

It's just:

if isnull({nawt.VOICENAME})
then {nawt.NONAME}+".bad"
else
if (instr({nawt.VOICENAME},"WAV") > 0)
then {nawt.VOICENAME}
else {nawt.NONAME}+".bad"

Naith

 

[jongag1]

Checked, tnx works fine.

Regards,
Age