UX Show_If - All Columns from the Same Table

[Michael2]

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

@Phil, @Steve, @Aleksi, @Peter

[MultiTech]

Yup, I’m seeing that as well

[Michael2]

@praveen, @Phil, @Steve, @Aleksi, @Peter

Does anyone have any input regarding this bug?

[Steve]

I did note this issue internally yesterday. I encourage you to contact support@appsheet.com directly if the matter is urgent.

[Aleksi]

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.

[Michael2]

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.

[MultiTech]

If you have the QREW extension installed, there’s a tab with all your tables and columns there.

FREE Chrome Extension that enhances the Expression Assistant [AppSheet Toolbox/QREW Tools] Tips & Tricks 💡

Hi AppSheet Community As someone who is in the App Editor 24/7, I frequently catch myself trying to remember the syntax for a particular expression, re-reading a formula several times to figure out where my missing parentheses are, or searching my mind for some fancy formula I put together ages ago. I know many of you have experienced the same. To make life a little easier on our favorite app making platform, the QREW Technologies team has released the first version of a Chrome Extension, QR…

[tony1]

Hi, we’re taking a look.

[tony1]

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).

[Aleksi]

@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.