Integer field has a maximum limit of 10 digits?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mansi.kakkar
    Junior Member
    • Jan 2024
    • 15

    #16
    shalmaxb Ok, I used this formula in the varchar field's condition. But, its showing me invalid if I try to add numbers. Did I wrote something wrote?
    PS. Its not required to have exactly 12 digits if its a varchar field, that was the issue with int field.

    Click image for larger version  Name:	image.png Views:	0 Size:	8.6 KB ID:	107172​​​
    Attached Files

    Comment

    • shalmaxb
      Senior Member
      • Mar 2015
      • 1705

      #17
      The Regex belongs in the field itself, see screenshot Click image for larger version

Name:	regex.jpg
Views:	178
Size:	23.4 KB
ID:	107176

      Comment

      • fberbert
        Junior Member
        • Dec 2024
        • 8

        #18
        Originally posted by victor
        In your particular case, it is better to use a different field type (for example, Varchar) or you can try the following:

        1. In your_instance_name/custom/Espo/Custom/Resources/metadata/entityDefs/Your_entity.json find your field and under the line
        Code:
        "type": "int",
        add
        Code:
        "dbType": "bigint",
        Thanks for sharing, your tip saved my day! ✅

        Comment

        Working...