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)))
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)))
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! Go to Solution.
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.
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.
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 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.
User | Count |
---|---|
15 | |
11 | |
11 | |
8 | |
3 |