Prevent creation of related list

Hi All,

Is it possible to prevent the creation of related list virtual fields?
2020-12-19_21-01-47

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!

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.

4 Likes

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

2 Likes

Sync time performance

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

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

1 Like

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

LIST()

The Performance Analyzer shows time gain for the table.

4 Likes

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

2 Likes

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

4 Likes