Problem with hiding columns in form view

[Christian_Kryge]

Hi all

I have a question regarding hiding a column in the form view.
In my table I have a virtual column that shows a weekday, based on the today() function. I need to show it in the table views, but when you go into the form view, this virtual column is visible. How do I hide it in the form view, but keep it visible in the table view? (See pictures for setup)

Thanks!

[Steve · Accepted solution]

In the column’s Show_If property:

(CONTEXT("ViewType") <> "form")

[Christian_Kryge]

Thanks! Works like a charm

[Skip2MiLu]

I’m still holding thumbs that one day Appsheet with give forms the same column order ability that every other view already has and make form management a whole lot easier.
One can only hope…

[LeventK]

@Michael_Pinto
You can already do that with creating a slice of your table and using that slice in your Form View. You can re-order the columns in the slice that you want to see in the Form.

[Skip2MiLu]

I am familiar with the process. Thank you.
Unfortunately it is not as efficient as the other views. Taking the current question as a example…
A expression is needed for each field just to do a common thing as not show a virtual or other column in a form to avoid confusing a user. My app alone has more than 30 virtual columns and my simpler apps have at least 10.
I would love to see the stats of how many apps have virtual columns that users do not want to be in the form but in other views and how many users have forms linked to slices just to order columns.
I also very rarely need my data presented in a form in the same order as it is in other views. Which means I have to setup a combination of slices and show_if expressions that take hours to setup which would take me minutes to do in comparison to other views types that have the column order feature.
I would think that all the duplicate slices and expressions per form also influence speed of an app.
I do not understand the logic to why forms is the only view that does not have order column. Maybe there is a reason that I am not seeing.
So I am still holding thumbs that this feature will eventually be implemented in forms.

[LeventK]

@Michael_Pinto
Having 30 virtual columns (though I have no idea what they are all used to do but) will affect an app’s sync time lot more than having multiple views in your case. Provided you don’t want to mess with slices, than I might advise re-ordering your columns in the back-end gSheet and just perform a re-structuring of the column schema in the editor. Form UX always obey to the column order of your back-end, but the views that you have created don’t have to. So you have 2 options: 1.) Creating a slice for the table and re-order the columns there, 2.) Re-order your columns in the back-end and perform a column re-structure in the editor.