I have a field that is designated to store numerical values, specifically used for inputting Facebook Business Manager IDs.\u000a\u000aRecently, I\u0027ve observed a peculiar behavior when entering a specific ID number. \u000a\u000aFor example, upon inputting the ID \u00222594725127352904\u0022, the value in the datasheet cell alters to \u00222594725127352900\u0022. Notably, the last digit of the ID changes from \u00274\u0027 to \u00270\u0027.\u000a\u000aWhat might be causing the last digit of the Facebook Business Manager ID to change upon entry into the AI Table?\u000a\u000aAre there any specific data handling or format settings that I need to adjust to prevent this alteration?

Question

EvieWong · Answer

Hi Yusri,\u000a\u000aSorry for any confusion caused.\u000a\u000aI have reproduced this issue and will report it to the development team, and they will look into it and see what went wrong.\u000a\u000aFor now, you can use the \u0022Single line text\u0022 field instead of the \u0022Number\u0022 field, then the ID won\u0027t be modified, and as the ID is for unique identification, it could be a large number, so using the \u0022Single line text\u0022 will be more suitable than the \u0022Number\u0022 type.\u000a\u000aHope this will be helpful to you, if you have further concerns, please don\u0027t hesitate to ask.

AITable.ai

Share AITable.ai

Related questions