In two of our apps, when attempting to set a Show_If condition on ANY view, the expression builder only shows columns from one table regardless of the underlying table. Because of this, I cannot set a show_if condition on the views.
In two other apps I checked, the columns being shown are from the user settings which are not being used.
This bug may be affecting other apps but I have only confirmed four so far
I have tried:
closing and reopening the editor
saving and verifying data
Yup, Iโm seeing that as well
I did note this issue internally yesterday. I encourage you to contact support@appsheet.com directly if the matter is urgent.
As Matt showed this in his video, yes it sounds a small issue with โColumnsโ. Though you can write your formula as you wish without the need to pick up the column name for your Show? formula.
Writing the Show_If with the correct columns and the platform returns and error and stops the app. If the columns are not in the expression builder, an error is thrown.
If you have the QREW extension installed, thereโs a tab with all your tables and columns there.
Hi, weโre taking a look.
Hereโs the issueโฆ The Show_If for a view warns:
This formula is not evaluated in the context of a row, so column values are not available.
This means that a formula like [Status] = "Open"
wouldnโt work in a Show_If for a view. Why? Because there is no notion of โthe current rowโ for a view. So a formula like [Status] = "Open"
doesnโt make sense in this context, since [Status]
is ambiguousโwhich rowโs status do you want it to check?
Let me discuss with my colleagues to see if thereโs a better way to display the column list here, since you might still want to know the list of columns (e.g. if youโre writing a SELECT
formula).
@Michael As Tony described earlier, the reason is not the fact is the column there or not. The reason is because the formula is probably just not possibleโฆ and throws an error.
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |