Inline view using data from slice displayed strange/different content and unable to control

In my app, the thing displayed on screen (which data source is not from a table but a slice) and the thing I did setting system generated view is mismatched and unable to control.

By that, I even tried created a separated reference inline view myself (then mount the data source of that custom view to slice), sometimes it works (then the displayed part mounted to the new custom view and I can control it again), but sometimes it doesn't, especially when I create new slice having source from the same parent table or rename an existing slice.

So I'm really confusing don't know where the displaying view is mounted from when working with slices...

In the example below is what happened with an inline view using data from a slice using a filter formula.

FILTER("ใƒžใƒƒใƒใƒณใ‚ฐไป•ไบ‹", AND([็จฎ้กž] = [_THISROW].[็จฎ้กž], IF(ISNOTBLANK([_THISROW].[ๅฐฑ่ทๆฅญ็จฎ]), [ๆฑ‚ไบบๆฅญ็จฎ] = [_THISROW].[ๅฐฑ่ทๆฅญ็จฎ], TRUE), IF(ISNOTBLANK([_THISROW].[ๅฐฑ่ท่ท็จฎ]), [ๆฑ‚ไบบ่ท็จฎ] = [_THISROW].[ๅฐฑ่ท่ท็จฎ], TRUE), ISBLANK([ๆฑ‚่ท่€…ID]), IF(ISNOTBLANK([_THISROW].[้ƒฝ้“ๅบœ็œŒ]), IN([_THISROW].[้ƒฝ้“ๅบœ็œŒ], SPLIT([ๆฑ‚ไบบๅ ดๆ‰€], ",")), TRUE), IF(ISNOTBLANK([_THISROW].[่ƒฝๅŠ›]), IN(SPLIT([_THISROW].[่ƒฝๅŠ›], ","), SPLIT([ๆฑ‚ไบบ่ฆๆฑ‚], ",")), TRUE)))

Evendo_1-1736986694883.png

At another place using exactly same formula (just different slice source)

FILTER("ใƒžใƒƒใƒใƒณใ‚ฐใ‚นใ‚ฟใƒƒใƒ•", AND([็จฎ้กž] = [_THISROW].[็จฎ้กž], IF(ISNOTBLANK([_THISROW].[ๆฑ‚ไบบๆฅญ็จฎ]), [ๅฐฑ่ทๆฅญ็จฎ] = [_THISROW].[ๆฑ‚ไบบๆฅญ็จฎ], TRUE), IF(ISNOTBLANK([_THISROW].[ๆฑ‚ไบบ่ท็จฎ]), [ๅฐฑ่ท่ท็จฎ] = [_THISROW].[ๆฑ‚ไบบ่ท็จฎ], TRUE), ISBLANK([ๆฑ‚ไบบID]), IF(ISNOTBLANK([_THISROW].[ๆฑ‚ไบบๅ ดๆ‰€]), IN([้ƒฝ้“ๅบœ็œŒ], SPLIT([_THISROW].[ๆฑ‚ไบบๅ ดๆ‰€], ",")), TRUE), IF(ISNOTBLANK([_THISROW].[ๆฑ‚ไบบ่ฆๆฑ‚]), IN(SPLIT([่ƒฝๅŠ›], ","), SPLIT([_THISROW].[ๆฑ‚ไบบ่ฆๆฑ‚], ",")), TRUE)))

Evendo_2-1736987074262.png

Sometimes both form view and detailed view that retrieve data from slices having the same phenomenon.

Is there a way I could debug or mounting the view again myself by viewing then changing the generated source code? (I know the purpose of AppSheet is no coding, though).

Solved Solved
0 3 230
1 ACCEPTED SOLUTION

Steve
Platinum 5
Platinum 5

The table or slice used to display the inline rows is determined by the Referenced table name setting of the column, not by the expression used to gather the rows. Make sure this setting matches your intention.

Steve_0-1737043280115.png

View solution in original post

3 REPLIES 3

Hi @Evendo , I'm not sure if I understood, but do you know that appsheet generates separated detail and form views for each slices? If you need to have the same view of the data, you need to configure the views for all slices.

Steve
Platinum 5
Platinum 5

The table or slice used to display the inline rows is determined by the Referenced table name setting of the column, not by the expression used to gather the rows. Make sure this setting matches your intention.

Steve_0-1737043280115.png

@Steve Thanks so so much, Steve. I didn't notice that the reference table part of the non-displayable inline was pointed to another table after my slice renaming. Will learn it by heart.

Top Labels in this Space