Prevent creation of related list

[teambelair]

Hi All,

Is it possible to prevent the creation of related list virtual fields?

They still get generated even if I deleted them. I don’t mind hiding them but I see on the Performance Monitoring that it consumes sync time.

Thanks!

[Koichi_Tsuji]

Quick answer is no.
Once you select REF type for column type, Appsheet will automatically generate those virtual column. Only one solution is to avoid the ref column type but set to Enum, then you manually construct validif with select expression , and then set base type to REF.

[LeventK]

For what reason you want to delete related list virtual columns which will remove any reference between tables?

[teambelair]

Sync time performance

[LeventK]

If you’re experiencing sync problems, may be your app structure is not correctly set up.

help.appsheet.com

App Performance: Core Concepts

In order to make apps run faster, you need to first understand some core concepts.

help.appsheet.com

Improve the Speed of Syncs with Data Updates

There are four ways to improve Sync performance when the app makes updates.

Have you ever investigated your performance profile to see where the app is using lot of time?

help.appsheet.com

Performance Profile

How to get the most out of the performance information for your app.

help.appsheet.com

Improving the Speed of Sync

Six different ways to improve sync performance.

[teambelair]

I think I found a solution, I simply overwrite the formula with

LIST()

The Performance Analyzer shows time gain for the table.

[Marc_Dillon · Accepted solution]

Use Enum/EnumList (Base Type: REF) to De-Reference Data & Reduce Reverse-Reference Clutter Tips & Tricks 💡

Hey Everyone. We all know the power of references inside an AppSheet app, but there’s also some overhead associated with them; and by that I’m talking about: Reverse-References These are the [Related Whatever] virtual columns that appear when you create a reference connection between two tables. These are great, essential even, allowing you to now only view your data in a clear way, but also customize the functionality around your app as well. But sometimes you don’t need the reverse refer…

[teambelair]

@Marc_Dillon So just use the Ref column type when we actually want the related list and use Enum otherwise?

[MultiTech]

@teambelair yep!

Enum/EnumList with a base type ref have similar capabilities as a ref column:

• They show the Label, not the actual value in the field
• You can de-ref values from them

But they don’t have the overhead of the reverse reference - the [Related Whatever] columns on the parent.