Hi AppSheet community,
I am fairly new to AppSheet, so Iโm not sure if I Iโam not getting it (yet) or if it is an actual issue. Hopefully someone with more experience can give me some pointers.
Summary:
In a โDetailโ view, a list of refs column shows me the entire referenced table (6 rows) instead of the actual filtered list of values (2 rows) as defined in the column.
My tables:
Lets look at row โnewid0005โ in table โExpressionsโ
All rows of table โExpressionsโ have the same behavior with an 6-row itemization in the โDetailโ view regardless of the content of the column.
Note that the next column [Related WordsInExpression], another list of refs, show a proper itemization in the โDetailโ view, consistent with the content of the column.
As per the data representation of the table, my expression to build the list of refs gives me the expected result. Itโs the โDetailโ view that does not seem to honor this resultโฆ I am confused.
Question:
Would anybody know why I am seeing a list of 6 rows in the โDetailโ view when the same column only contains a list of 2 references?
Thanks for you insights.
Hmm. Iโve seen a few other complaints similar to this recently. There may be a bug here.
Please post a screenshot of the column configuration screen for the Related Words column that includes at least the top section, the Type Details section. and the Auto Compute section.
@Steve , thanks for the reply.
I have been playing a lot with it since yesterday trying to figure it out or work around it. The behavior is different today, and I am not sure if itโs because of my own changes. It is however still unexpected.
Today, I am no longer seeing what I described originally (6 rows instead of 2 in the itemized view of references)โฆ
โฆ instead, I am now seeing an empty list of rows, where I an (still) expecting 2. So still inconsistent as far as I understand.
Configuration of column [Related Words] in table 'Expressionsโ
Below is the screenshot you asked for (let me know if I misunderstood you, happy to give you what you need).
Note that there is no Auto Compute section.
Inconsistent Itemization of referenced rows"
Below is what I am seeing today, with an empty itemization of the [Related Words] column that should actually contain 2 rows".
The other columns containing a list of references are consistent, like I mentioned in my original post.
Thanks for looking into it
Hmmโฆ (again)
The count n the header (the 2
in Related Words (2)
) is generated independently from the list of rows displayed in the inline view. Itโs possible that the expression that gathers the rows to display (the columnโs App formula expression, in this case) could produce a list that includes duplicate results and/or invalid row references, meaning the count of list items could include items that arenโt displayable: duplicates and invalid row references are not displayed. Is it possible your SELECT() expression produces duplicate rows, and/or invalid row references?
@Steve , looking closely again, everything looks as expected, except for the itemized view. I hope Iโm not missing the obvious.
Column [Related Words] of table โExpressionsโ seems to be referencing existing rows of table โWordsโ, without duplication
See the few screenshots belowโฆ
โExpressionsโ table: Column [Related Words] lists 2 references (no duplicate): 15b0dfd4 & c2eb1fff
โWordsโ table: Contains both keys 15b0dfd4 & c2eb1fff (among others) as expected.
Both tables look good and consistent actually. Iโm still scratching my headโฆ
The only thing I can think, then, is that itโs a bug. Please contact support@appsheet.com for help with this, the report back here with the findings, if you would.
Thanks @Steve . I will contact support then.
Last question before doing soโฆ Could the missing rows be caused by the way the โDetailโ view is set?
One thing is that I could not understand is how to configure the sub-view itemizing the referenced rows:
I am assuming the UI is calling a specific view to do so, but I donโt see/understand the way for me to specify which one. Such a view must be defined somewhere, right?
I am wondering if I may have set up a weird view somewhere with obscure rules filtering out rows, that the UI may be picking up without me realizing it. Not likely, but possible.
Below an example of what I am talking about:
Do you have any insights on how to control the way the referenced rows are displayed?
Thanks for your time Steve, I much appreciate it!
The app will configure the inline table using a table view for the table (or slice) named by Referenced table name in the columnโs configuration:
in the Ref position:
The system often creates the view configuration automatically, giving it a name with the _Inline suffix:
Thanks @Steve !
I had no idea. I will look into this.
@Steve , Iโm finally back to it.
I see indeed a table Ref View with an _Inline suffix associated with the data table in question. It is an auto-generated system view as you suggested.
Unfortunately, this is not the one used to display the itemized referenced rows in my Detail view. Instead, it is using another table Ref View that I created myself.
I tried to delete the _Inline view and it came back (as expected), but my Detail view keeps using the wrong Table view to display the itemized referenced rows. I donโt quite see how I could to force itโฆ
Ah, yeah. If you create your own view in the ref position, it will be used rather than the system-generated one. To wok around that, youโll need to create a slice for one of the views.
Create a slice on the same table.
Reconfigure the column to use this new slice as the source table.
Configure the inline view for the new slice as desired.
See also:
@Steve , thanks using a slice is a great tip. I didnโt think of it as a workaround but it sounds logical.
[UPDATE] It worked like a charm! I definitely need to give slices more thoughts.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |