Is there a way to control a columns show contraints based on values it DOES NOT CONTAIN. I am aware of and have used the โCONTAINSโ expression but is there a way to look for something that isnt contained in a cell.
For example, I have a price column containing a spreadsheet formula (therefore I cannot use the app formula, initial value or valid if constaints), the formula will either provide a price e.g. ยฃ5.00 or have the value โInvalid Stock Codeโ. I dont want the app to appear with โInvalid Stock Codeโ I would like it to be blank or appear as 0.
Is this possible using the Show If Constraint??
Try:
NOT(CONTAINS([Price], "Invalid Stock Code"))
You may have a bigger problem is the Price column is of type Price or Decimal but some cells may contain Text values (e.g., Invalid Stock Code
). I donโt know how AppSheet will handle a value like that. Generally speaking, itโs bad practice to shoehorn an unrelated use (e.g., error reporting) into a column value like this.
Yes understood thank you, think that is why the show expression will not apply. Is there a way to hide text columns in a price column field?
No
User | Count |
---|---|
26 | |
25 | |
24 | |
23 | |
20 |