In my photo database where each record contains the pertinent data of each shot there are also thumbnail .jpgs of each picture appearing. This works fine with the following procedure:
“1974 thumbs ƒ/”+TP+«R-NO»+YR
where “1953 thumbs ƒ/” is the folder with the jpgs and TP+«R-NO»+YR the image title. (this saves me entering hundreds of individual image titles, this procedure puts the titles together from available data in 3 fields of the record.
Now, there are cases where I made an error in the numbering of pictures. In stead of correcting all the subsequent numbers I leave the following numbers alone and have an extra field ES which in these cases contains a corrective number, e.g. .1, .2, etc. They are normally not more than 2-3 records, so the ES field is normally empty. It contains a number only if there was a correction in the image numbers.
So, in analogy to the above procedure I’d like to reformulate the procedure with an IF statement: if ES is empty, follow the above naming procedure (in most cases), else, if ES is not empty, get the image:
“1974 thumbs ƒ/”+TP+«R-NO»+ES+YR
What would the statement in Pano X be for “ES is not empty”? I did not succeed in putting the right formula together, but I am not a programming genius.