AnsweredAssumed Answered

Formula producing "?"

Question asked by Matty_1 on Jun 10, 2015
Latest reply on Jun 11, 2015 by philmodjunk


Formula producing "?"



Hi there,

Maybe I'm losing it but I thought that the formula below worked previously but it certainly doesn't now.  What I have is a function that copies over information from another table if you select it's ShippingID.  The fields with information that has been copied over then becomes greyed out using visibility and you can no longer access the field.  If you want to manually change parts of the information once it's been copied over you have to select the manual entry box.  Once you do that - visibility allows you to gain access to the field and I want the old information to stay and let the user clear or modify what's already there.  That's what I'm trying to attempt in the first line of my case but it returns a "?" instead of leaving the fields content intact and I don't know why.  The other two lines appear to be working as they should.

Case ( 

ManualEditCity = True ; Self ;

IsEmpty (_kfnShippingID) and ManualEditCity = False ; "" ;

not IsEmpty ( _kfnShippingID ) and ManualEditCity = False ;  Locations_People::City