Page 1 of 1

iPad Shows Data for One Day

PostPosted: Wed May 22, 2019 10:37 am
by jmundok
I have a Dayback install running on FM17. It's primarily used on Windows 10 machines, but the users are also accessing the primary solution via iPads. They are opening the Dayback file in FileMaker Go 17 and it's only showing data for one day...yesterday. It appears to be displaying all of the events for that day (May 21) but is displaying no data for any other day.

Any idea what could be causing this?

Re: iPad Shows Data for One Day

PostPosted: Wed May 22, 2019 11:25 am
by John Sindelar
Hey Jason,

That's kind of crazy, Am I reading this correctly that the desktop machines are showing events on all the other days correctly and that it's just this iPad that has the issue? If so, are the iPad and desktop users using the same hosted solution and the same layout? Are they logging in with the same privilege set?

- John

Re: iPad Shows Data for One Day

PostPosted: Wed May 22, 2019 3:32 pm
by jmundok
Yeah, I just logged into the source database on a Mac and iPad with my full access account, then launched Dayback from a button on a layout. Dayback is set to auto login with a generic account because it's essentially just a viewer so we're not managing credentials in both files. I'm linking to a screenshot with both screens.

(we usually just use the pivot schedule, but the week view illustrates the issue)

https://drive.google.com/file/d/17XjEx- ... sp=sharing

Re: iPad Shows Data for One Day

PostPosted: Wed May 22, 2019 5:56 pm
by kcembrey
Hi Jason,

Thanks for the screenshots. Could I have you verify that there are no filters applied by going to the filters tab in the sidebar and clicking the "Clear Filters" button at the bottom?

Thanks,

KC

Re: iPad Shows Data for One Day

PostPosted: Thu May 23, 2019 11:58 am
by jmundok
KC,

No filters are being applied. I tapped on the Clear Filters button to be sure. It's different today, though. I just logged in with the same full access account and opened Dayback on the laptop and iPad. If I go back to last week, everything is displayed on both devices. This week and next week are completely blank. The following week shows the events on both devices. Very strange.

Week 1
https://drive.google.com/file/d/1VvYRFy ... sp=sharing

Week 2
https://drive.google.com/file/d/1HBq-R1 ... sp=sharing

Week 3
https://drive.google.com/file/d/1FMwr3e ... sp=sharing

Week 4
https://drive.google.com/file/d/1S_2C06 ... sp=sharing

Re: iPad Shows Data for One Day

PostPosted: Thu May 23, 2019 12:11 pm
by kcembrey
Thanks, Jason.

This sounds like a case of the rogue backslash. If there's a field in an event that has a value that ends in a backslash (\), this will break the Javascript code as it is an escape character, so none of the events will load when the event is showing.

So, the best way to figure this out is to try and narrow down the data set by going to a Day view, then clicking through those weeks to find which days are not showing any events. Then, you can start applying filters on one of those days to find out if you can narrow down some specifics of the issue event.

Once you've got a date and maybe one field figured out by filtering, you can go to the related "Source No X" layout and do a find for events that match that search criteria and look at each of the fields to try and find the one with a backslash.

Let me know if that helps!

KC

Re: iPad Shows Data for One Day

PostPosted: Thu May 23, 2019 1:03 pm
by jmundok
KC,

Wouldn't that break on both the laptop AND the iPad? Or is it handled differently between the two devices?

Thanks!
Jason

Re: iPad Shows Data for One Day

PostPosted: Thu May 23, 2019 2:47 pm
by kcembrey
Hi Jason,

I think you're right if it's a backslash. Still, it's likely there's something about a specific record that's causing an error in the JavaScript code, but only on the iPad/iPhone.

It's still a good idea to try and pinpoint a specific record that might be causing the issue, then we can dive into why it's causing an issue. Let me know if you're able to narrow it down, then we can take a look at the data together to try and figure out what's causing the issue.

Regards,

KC