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?
Why donโt you hide that field if the entry is new? Would that be the same thing?
Yes, it would be the same, but I can not think of what expression to use in โshow ifโ. How do I determine the entry is new?
You can check if your record belongs to the list already with IN([KeyColumnName],TableName[KeyColumnName]). When itโs a new record, itโs key column value is not saved to the table yet and it will give you a result as FALSE. If you add that into the Show_If, it wonโt show the field.
Great! Many thanks!
User | Count |
---|---|
39 | |
35 | |
29 | |
23 | |
18 |