New Bug Encountered: Number (range) column edit not going through on IPhone

[Minh_Le]

I am building an app in which users can edit multiple number columns on the app using sliders from 1 to 5. However, many of the slider inputs are not coming through into Google Sheets for iPhone users. I have tested this a few times and all inputs from the Android apps and in-browser app go through very consistently, while slider input from the iOS app go through only about 60-70%, while the rest revert back to ? (the default value). This can be circumvented by making all the inputs ‘required’ but this is undesirable.

[Aleksi]

Is this happening only for some columns or all columns in one slice?

[Minh_Le]

This only happens on some columns, very randomly. For my example, I have 5 candidates, each has 10 columns that use the number slider input for rating. We’re using “Edit” (not “Add”) to change the numbers. I use the app on my Android phone, one of my coworker is using the in-browser app, and mt other two coworkers are using iPhone. Everyone made sure that they input every column. All of the inputs coming from Android app and browser app came through into the spreadsheet, while all of the inputs from the iPhone app is missing 3-4 columns quite consistently. When we checked back on the app the missing columns reverted back to the value “?”, which is the default value.

[Aleksi]

It sounds that the problem could be a bad key column or two users are updating the same record at the same time and the last one wins.

[Minh_Le]

Each person is updating a different row, so I really think this is some weird problem with iPhone only. I noticed that sometimes the slider position can stay between two numbers without snapping into either position (although it will still display either number and some of the inputs still came through, tested by intentionally putting all the sliders between two numbers). On android and windows they work without any issues. On iPhone only about 60-70% of the inputs came through, very randomly and I can’t notice any particular pattern.

I have worked around it by using enum buttons instead of sliders and all the inputs worked on all devices, but this might be worth taking a look at.

[Aleksi]

@Gil Any thoughts with this one?

[Gil]

@Minh_Le, Did you see if the app finished syncing? In iOS the sync isn’t likely to go through if the app is in the background. In that case the app should still keep the changes and try to sync the next time the user opens the app.
If that’s not the case, could you take a look in your app’s audit logs and see if edits appear there?