Inline View Showing Conflicting Data

[Greg_Huston]

Hi,

I’m got a problem where my “Inline” views are showing conflicting data. The picture shows (1) item for the Active Field Service, but the inline shows 3 items. My data also shows only one. Here’s what I have

1. Slice of my Field Service Data (Active Field Service) where I’ve filtered from 1 day looking forward ([DaysToEvent] >= -1) -Days to event being a virtual column using today() vs my end date. This works, only return one row of test data, which is right, see picture.
2. Virtual Column Reference Row (Employees Active Field Service) For Employees Spreadsheet (REF_ROWS(“Active Field Service”, “EmployeeID”)) - where I go through the above slice and filter out this employees field service items.
3. My Employees Detail Display then displays the column (Employees Active Field Service) above, hopefully showing 1. The forward (date) looking slice, with that employees field service items only. There should be one result (as verified by the slice data pic) but the inline display is correctly showing that one result as a total, but then displaying multiple lines of data.

See Slice Data (1 item)
See Inline (1 item calc, but 3 displayed)

I’ve been fighting with this a bit and am really frustrated. Anyone ever see this where the numbers and inline items simply don’t match up?

[Steve]

This is probably due to a peculiarity with the way AppSheet decides which rows to show in an inline view and how it counts the rows. Do the two eventually sync-up to each other?

[Greg_Huston]

Hi,

No it doesn’t actually sync up, and that’s the problem. The slice that I’m using for data has exactly one record in it if you look at the second picture there… But no matter which way I cut it, when I try to retrieve the slice data with my employeeIDs (just for that employee), it basically bypasses the slice filtering my data, and just retrieves all data for that employee.

It’s like the calculation number (1) in that first picture correctly uses the slide data, but the inline just bypasses my slice entirely and grabs all data. I’d really really like help with this and to understand it because I’ve built quite a few apps before without issue but somehow this one I’m struggling to understand what is happening here.

[Steve]

Please post a screenshot of the Employees Active Field Service column configuration screen.

[Greg_Huston]

Happy to. Here’s the column configuration

And here’s the slice information

And here’s a view of just the slice so you can see my slice is working properly.

So. Slice has 1 data record - see picture. Ref in my column mentions my slice (with 1 data record). But 3 items show up inline - essentially previewing data outside my slice. I’m stumped.

[Steve]

In the Employees Active Field Service column configuration, make sure the Referenced table name is set to the Active Field Service slice.

[Greg_Huston]

You sir, are a legend. I can’t believe I missed that, I was checking the slice from the REF_ROWS and totally forgot about that other referenced table name. Thank you so much!