Hello! Is there any way to detect a NaN error, “The entry is not valid” to put in “show if” and that this field is not shown when the expression fails? I have a field that shows the available stock of each product when an order is being loaded (= [ProdSel]. [Total Available]), but if a new product is loaded in the same Form, as the product does not yet exist in the table of products, the expression gives error. The idea is that the quantity available is not shown when the product is new. Is there an ISERROR () formula that allows me to control the error?
LinkedIn
Twitter
