I did some math calculation and the value shows in my Android mobile and Ipad perfect but showing wrong numbers to Iphone user and I didn’t understand the reason lead to that. any one face this issue?
Can you show me the calculations and how you did them?
Were any date values involved?
Can you also show us the formula involved each of those columns shown in the screenshot?
Just taking a step back, is it the same user signed in on all 3 devices?
If not, are there Row Owners applied in any of the tables, or are there any user specific columns referenced in any of the calculations?
2 Likes
different users but there is no row owners and when I simulate the other users in glide website it shows the numbers normally.
the main issue appears only in iphone devices. I tried galaxy and Ipad (apple product) and app working fine
all are numbers. I call number from other sheet
If you change all your boolean checks to “is checked” instead of “is” true does it make a difference?
I would also suggest opening your builder environment in Safari to see what child values is not calculating correctly.
I did change it to is checked and same issue appreas to iPhone users. I opened the builder in safari in my iPad and looks perfect while the issue still exist in iPhone
Then I think your last resort is this.
Might be worth placing each of those individual value on the screen in your app. Then open it on the iPhone and see which ones don’t display.
1 Like
I got it. I know the reason now but I don’t know what cause it.
the i phone users where select non-english language as main language. where they change the language to English it does work perfectly.
The strange thing here that we they submit new form with numbers it appears clearly in the android phones even when the language is not English. when the iPhone itself NO.
how this could happen since the base is google sheet !! and other accounts and users could display the details at the same time they or other submit new order.
1 Like
Maybe it’s commas vs periods for thousands separators?
2 Likes
I tried to open the builder in iphone and I found that one of the column which it required to call from other sheet it not matching and no data pulled. is the process being in the phone itself or in the glide web for the column that built in the glide “not google sheet”.
the column with data entry which saved in the sheet it appears with no issue even with non English language, while other column that being processed in glide it is not right.
Do you apply any column formatting in the google sheet?
Can you show us what the problem column looks like in both the google sheet and in the data editor?
I got it and solve it 
I will get back to you soon and explain what was the issue and how did I solve it
1 Like
The App idea:
the idea of the app is calculator for products for home made chocolate. I want to help them makers so they select the product, price level (as they have different prices based on the costumer) and pieces of chocolate in each product.
there is sheet contain all products with different prices level and price based on wight category.
The challenge:
part of the calculation is to get the price of one piece of product based on price level, product and weight category (this will be selected based on number of pieces in the order compare to the pieces in 1 KG. there are prices for 1 KG, 0.5 KG and 0.25 KG
I notice that IOS devices provide wrong value in the total calculation. this issue not exist in Android devices. the users used iPhones and all get wrong result, while I am getting there submitted forms with right numbers and no issue. I was confused as I though that calculations are being processed and saved in the server.
I opened the glide builder in one of the iPhones as @ThinhDinh suggest. I notice that column which should get price of a piece is not functioning (related type). it look like to matching between the values and the pricing sheet.
all iPhones were using the app and get wrong result. When I used my iPad I got the result as it should be !!! I notice all others there languages were Arabic and IOS select the numbers same as the languages structure.
moreover, I notice that the column which created in the glide (not showing in google sheets) are processing in the device not in the cloud.
in as part of the calculation we get ratio for the catalog (1KG, 0.5 or 0.25) by dividing the #pieces in order / pieces in 1KG. then all 3 conditions (price level, product and catalog prices for 1 piece ) are linked by array and them joint together in order to get one test sentence to compare with. ex (max, pure chocolate, 0.25). as IOS taking the language used in the device and it is over come the app language and numbering type used. I got something like (max, pure chocolate, ءءء) number in Arabic structure.
How I solve it:
this was really strange and confused me and spend a lot of time taking the root cause of the issue.
As I got the gap clearly, I think that I have to have dynamic column in the pricing sheet that could change based on the language of the devices to elemental the issue.
I did develop a new column glide base in the pricing sheet to make sentence same like the one created during the calculation. this will help to build dynamic column to compare with which is changing based on the device language.
I did this and got work perfectly.
Thank you guys for your support
2 Likes