You are viewing limited content. For full access, please sign in.

Question

Question

Offline tables data changed format LF mobile

asked on May 30, 2023 Show version history

Hello, I have a form that I want my users to be able to fill out in the woods where there is no cell signal. 

I have everything setup and working for the most part, but something that is messing things up is the offline data. 

Here is the form when filled out normally and not with offline data. 

You can see that the division number is 20 and the district number is 11. Those are values from a lookup table. 

This is the form filled out in offline mode. 

Here the 20 is filled in with a decimal place value which then breaks my rule for getting values into the District name. Nothing comes up in the District name when it's 20.0. 

Has anyone seen this before? The Division number field is a single-line field and not a number. the data from the View is a decimal 2,0. Is syncing the data to the mobile device changing the format? 

Any Ideas on this one? 

 

0 0

Replies

replied on July 11, 2023

I just want to add, I'm getting this again even after changing the database column that holds those values to a CHAR 2. I thought that if I changed the values to Char(2) that storing in the local DB in the app wouldn't change them. It still gives my number a decimal and a 0 when placed into a single-line field. 

 

Is this normal? 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.