Hi all,
I think this might be a bug, but every time I think there's an issue with Appsheet, it turns out to be an issue with my expression :), so hoping someone can help me figure out what the issue is.
I have this dashboard. It is supposed to be only Filter and Stock 2, but I added Stock 3 when trying to test the issue with Stock 2. When I add data to my filter, Stock 2 sometimes pulls/shows the wrong row. The identical Stock 3 shows the right row so I am confused. I don't know if my Slice filter expression is incorrect?
Correct when filtering Location 2 and SKU 2. Same row ID showing for both Stock 2 and Stock 3.
Incorrect when filtering Location 2 and SKU 1. Stock 2 shows the wrong row.
I changed Stock 3's View type to Detail view to see if it still works. Neither Stock 2 nor Stock 3 shows any date when filtering Location 2 and SKU 1. But it works fine when filtering Location 2 and SKU 2.
I have added the relevant settings below for your review. If there is anything else you need, please let me know.
Dashboard
FIlter
Stock 2 and Stock 3 share the same Slice.
Stock 2 UX view
Stock 3 UX view. It is a copy of Stock 2 UX view. Only changed View Type (an.
Stock data
Solved! Go to Solution.
I think I have resolved the issue. Sharing this for anyone that might come across this post in the future.
Turns out that SKU had been set as the Key column instead of ID. I removed SKU as Key. That seems to have resolved the issue.
Also, thanks @Marc_Dillon for trying to help ๐
Interactive mode typically doesn't mesh well with user-filterable dashboards like this. But I don't know if that's causing your issue.
Your expression looks fine to me, though I'd point out that it's missing cases for if the filter values are blank, if that matters.
Setting up a user-filterable dashboard like this doesn't really have a good UX when using a Detail view, because when you change your filter, the Detail view still tries to show the old record, but since it's not in the Slice anymore, all it can show is a blank view, the user still has to press the slideshows arrows to find the actual filtered record(s). Are you aware of this?
@Marc_Dillon wrote:Interactive mode typically doesn't mesh well with user-filterable dashboards like this. But I don't know if that's causing your issue.
Your expression looks fine to me, though I'd point out that it's missing cases for if the filter values are blank, if that matters.
Setting up a user-filterable dashboard like this doesn't really have a good UX when using a Detail view, because when you change your filter, the Detail view still tries to show the old record, but since it's not in the Slice anymore, all it can show is a blank view, the user still has to press the slideshows arrows to find the actual filtered record(s). Are you aware of this?
Was not aware of this. Is there a better way of creating a filter that will show me data that can be updated? I want to be able to scan two separate barcodes. Based on the scanned barcodes, I want the app to show a specific item that I have in stock. I want to count the stock I have of this item and add it to the app, ideally without going to a differnt view (hence the dashboard).
@Marc_Dillon Even though my initial issue seems to have been resolved, I would love to learn more about how I can create better user filters if you have the time to share some knowledge. Thanks.
I think I have resolved the issue. Sharing this for anyone that might come across this post in the future.
Turns out that SKU had been set as the Key column instead of ID. I removed SKU as Key. That seems to have resolved the issue.
Also, thanks @Marc_Dillon for trying to help ๐
User | Count |
---|---|
33 | |
31 | |
30 | |
19 | |
17 |