Hi Friends,
I have below tables
KEY | STYLE | DESCRIPTION |
1 | A | 1 |
2 | A | 2 |
3 | B | 3 |
4 | B | 4 |
Could you guys advise me how to separate it with <<Start>> <<End>> expression to below 2 thinner tables ? ( I'm trying to do this for Email Body Template )
STYLE : A
KEY | DESCRIPTION |
1 | 1 |
2 | 2 |
STLYE : B
KEY | DESCRIPTION |
3 | 3 |
4 | 4 |
Solved! Go to Solution.
Assuming the table is called "Styles":
<<Start:
Style: <<Style>>
Key | Description |
<<Start: FILTER( Styles, [Style]=[_THISROW].[Style] ) | <<Description>><<End>> |
<<End>>
Please change [_THISROW] with [_THISROW-1] on either expression if it doesn't work, I tend to forget the logit sometimes about it's usage. And I found it unreliable sometimes
<<Start:SELECT(TABLENAME[KEY], [STYLE] = "A")>>
I am writing this from my phone, so this may not be an instant home run, however, it should be well towards a starting point.
i would recommend switching out SELECT() for FILTER() once you get moving.
<<Start:FILTER("TABLENAME", ([STYLE] = โAโ))>>
Hi Ryan,
Thanks for reply,
What if in the case that we have many of different STYLE values ?
Assuming the table is called "Styles":
<<Start:
Style: <<Style>>
Key | Description |
<<Start: FILTER( Styles, [Style]=[_THISROW].[Style] ) | <<Description>><<End>> |
<<End>>
Please change [_THISROW] with [_THISROW-1] on either expression if it doesn't work, I tend to forget the logit sometimes about it's usage. And I found it unreliable sometimes
Hi SkrOYC,
It works great! with changing to [_THISROW-1]
References!
Reference my friend; connect the two sub tables to the main one, with reference columns on the sub tables.
When you connect the tables together, AppSheet creates "reverse references" - which basically hold the result of the formula you're trying to build.
(^_^)
Create a "Styles" table as the parent
Yeah, but he has just one dataset and wants to separate it on multiple template tables for the purpose of reporting. I'm with you that reference can make this scenario way easier and efficient, but he also would need to have a table with all of the Styles available and execute the bot from there, the parent
User | Count |
---|---|
25 | |
24 | |
24 | |
20 | |
16 |