Question

FSM Mobile field value auto populating in negative

  • 20 July 2021
  • 4 replies
  • 76 views

Badge +5

Hello,

 

I have added a custom screen with custom fields in the FSM Mobile portal but the values are populating as negative for the “Asbuilt id” but it is working fine in backoffice.

I am facing the same for all the id’s for the custom screens created.

Hope to get a quick answer on this.

Please find the screenshot for the same.

 

Best Regards,

Deepak Kumar


This topic has been closed for comments

4 replies

Userlevel 7
Badge +24

Hi @EnvDeepaK,

The ID for an entry in an SQL table gets assigned at the point the record is saved. The ID that the record has prior to this is a temporary one that is converted on save and it is negative to ensure it cannot be an existing valid system ID.

You should find that on save it is converted to a correct, valid ID. An alternative would be to set the ID to be user entered for that table rather than system assigned with the next value prompted.

Kind regards,

Lee Pinchbeck

Badge +5

Hi @Lee Pinchbeck ,

Thanks for the quick explanation.

Best Regards,

Deepak Kumar

Badge +2

Hi together, we have the same behaviour and the ID will be not changed after saving to a positive number ! Cheers Marc. 

Userlevel 7
Badge +24

Hi @RTTMRINGWELS,

Do you mean saved on the device or synced back and saved to the database? If it is still awaiting sync and response from the server it will not yet have received the ID back from the database. Check the sync queue on the device and the mm_message_out queue are cleared.

Kind regards,

Lee Pinchbeck