Columns used in views

[Rahul_Sanghavi]

Hi,

I was checking performance analyser. I found out that certain virtual columns are taking more time to sync and wanted to remove them or re-work on the logic.

The problem is i need to understand in which views those columns are used and check if the column value is really required or not so that i can easily decide and remove the said column and improve the performance of the app.

so now, Is there any way to find out in which all views the column of a table are used?

Please advise.

[Aurelien]

Hi @Rahul_Sanghavi 

As far as I know, there is no way to know where your columns are used.

[Rahul_Sanghavi]

Oh. that's not a good news. that means i will have to cycle through all the views to check. 

anyways, thanks for the prompt reply.

[Aurelien]

You are welcome. 

One tip, though: you may be aware of it, but you may benefit from using a Show_If condition on your column if you know exactly when to display your columns and when not to do so.

For reference:

https://help.appsheet.com/en/articles/961221-show_if-column-constraint

https://help.appsheet.com/en/articles/2347640-context

Such expression should be used there:

[Rahul_Sanghavi]

Yes. thanks. I am aware of this option.

[Steve]

Make a copy of the app. In the new copy, remove the virtual column. The app editor will tell you what breaks.

[Rahul_Sanghavi]

That's a good option to try. Thanks.