The curious case of the missing data

I have this setup.

So, obviously, if [Class] has a value, then the other 3 columns of course would have values. Right?! (assuming of course that the ref’d record has those values filled in, which I’ve already confirmed in the below case)

Well I’m seeing this in the back-end data a couple times (4 times out of 190 records), and have been trying to troubleshoot it.

3X_6_4_6493eaf20ccbb32d1468ca1e146452cefafe9164.png

As you can see in this specific case, all 3 records reference the same Class, but the middle one is missing the other data.

Any ideas at all where to start looking?

These 3 records came from 3 different users, which they accessed from pre-filled Form links from an email. I have all 3 emails and following the links myself displays as it should. I even filled out the form for the affected record and saved it and it worked for me.

Reset on edit is off. None of these columns are user-editable. Only the base table, no slices. Only one Form view.

Solved Solved
0 10 671
1 ACCEPTED SOLUTION

Ohhhhh…man

Thanks for helping me think it through, I think I know what happened.

I just opened up the link from the email, in a new private browser tab (this is a Public plan app btw). The sync time on this app is around 20 seconds, not terrible, but also these users are probably like “why is this taking so long?”

Sync on Start is turned on. But, there’s a cancel button on the bottom of the sync screen. I pressed it. This is the form I saw:
3X_3_0_300f3e89595183cfb1a408d67d4e6b7fd33b375c.png

This is what you see when you let it sync all the way:

Only an assumption, but it makes sense. I guess my solution here would be to pre-fill more of the values. Ugh!

Why is there a cancel button on the sync screen?!

View solution in original post

10 REPLIES 10
Top Labels in this Space