Skip to main content
V
venkatb0004
October 2, 2023
Solved

Getting the error "The value provided is too large"

  • October 2, 2023
  • 6 replies
  • 0 views

HI Team,

i was created the application like naukri, in that mentioned mobile number and data type is int/text also tried size is 20, when i enter the values 10 digits its getting error "The value provided is too large"

i was rechecked and changed all the details and while testing after modifications i  below, and its pointed to data source

can anyone please help me on that

find the below code

{
a!sectionLayout(
label: "Record",
labelSize: "MEDIUM",
labelHeadingTag: "H2",
labelColor: "STANDARD",
contents: {
a!columnsLayout(
columns: {
a!columnLayout(
contents: {
a!textField(
label: "First Name",
labelPosition: "JUSTIFIED",
value: a!defaultValue(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{a4ccef83-8dc6-4fe5-875d-92719c90cf6e}firstName'],
"–"
),
readOnly: true
),
a!textField(
label: "Last Name",
labelPosition: "JUSTIFIED",
value: a!defaultValue(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{58f81f07-98b7-4d13-b505-abb223b0e4cd}lastName'],
"–"
),
readOnly: true
),
a!textField(
label: "Gender",
labelPosition: "JUSTIFIED",
value: a!defaultValue(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{e8273cf3-5315-42af-b3d8-d6223ee4f39f}gender'],
"–"
),
readOnly: true
),
a!textField(
label: "Email Id",
labelPosition: "JUSTIFIED",
value: a!defaultValue(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{4fa1ccf4-52b3-449e-9553-f06067601097}emailId'],
"–"
),
readOnly: true
),
a!textField(
label: "State",
labelPosition: "JUSTIFIED",
value: a!defaultValue(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{701ba832-14c8-41f4-b6ab-087d86149d46}state'],
"–"
),
readOnly: true
),
a!textField(
label: "E1 College",
labelPosition: "JUSTIFIED",
value: a!defaultValue(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{cf066df3-b944-41ca-bb46-3ca57205a243}e1College'],
"–"
),
readOnly: true
),
a!textField(
label: "E1 Grade",
labelPosition: "JUSTIFIED",
value: a!defaultValue(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{37c8d3e4-9959-42a1-994a-f60f58beec0e}e1Grade'],
"–"
),
readOnly: true
),
a!textField(
label: "E2 College",
labelPosition: "JUSTIFIED",
value: a!defaultValue(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{eccdff36-4aff-4e78-b2ad-d79f06f20297}e2College'],
"–"
),
readOnly: true
),
a!textField(
label: "E2 Grade",
labelPosition: "JUSTIFIED",
value: a!defaultValue(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{cea1dffe-4ec9-4469-80d5-c376655fccc7}e2Grade'],
"–"
),
readOnly: true
),
a!textField(
label: "J1 Company",
labelPosition: "JUSTIFIED",
value: a!defaultValue(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{5dba32bc-8760-48fd-90b7-99bab80d10ef}j1Company'],
"–"
),
readOnly: true
),
a!richTextDisplayField(
label: "J1 Start Year",
labelPosition: "JUSTIFIED",
value: if(
isnull(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{b2169e24-9801-4878-8a8a-268e85953966}j1StartYear']
),
"–",
{
a!richTextIcon(
icon: "calendar",
color: "SECONDARY"
),
" ",
a!richTextItem(
text: text(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{b2169e24-9801-4878-8a8a-268e85953966}j1StartYear'],
"mmmm d, yyyy"
)
)
}
)
),
a!richTextDisplayField(
label: "Experience2",
labelPosition: "JUSTIFIED",
value: if(
isnull(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{c0e5aa58-9291-4735-a7f2-5681420cce0c}experience2']
),
"–",
{
a!richTextIcon(
icon: if(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{c0e5aa58-9291-4735-a7f2-5681420cce0c}experience2'],
"check-circle",
"times-circle"
),
color: if(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{c0e5aa58-9291-4735-a7f2-5681420cce0c}experience2'],
"POSITIVE",
"NEGATIVE"
)
),
if(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{c0e5aa58-9291-4735-a7f2-5681420cce0c}experience2'],
" Yes",
" No"
)
}
)
),
a!textField(
label: "J2 Position",
labelPosition: "JUSTIFIED",
value: a!defaultValue(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{ec3d7b04-d8e4-4789-a44e-abd9c9386afd}j2Position'],
"–"
),
readOnly: true
),
a!richTextDisplayField(
label: "J2 End Year",
labelPosition: "JUSTIFIED",
value: if(
isnull(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{1d691b71-efb0-4b02-ae62-00a37fe264cc}j2EndYear']
),
"–",
{
a!richTextIcon(
icon: "calendar",
color: "SECONDARY"
),
" ",
a!richTextItem(
text: text(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{1d691b71-efb0-4b02-ae62-00a37fe264cc}j2EndYear'],
"mmmm d, yyyy"
)
)
}
)
),
a!textField(
label: "Created By",
labelPosition: "JUSTIFIED",
value: a!defaultValue(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{66a94d6c-554d-4ceb-b4cd-a47fd129bac9}createdBy'],
"–"
),
readOnly: true
),
a!textField(
label: "Modified By",
labelPosition: "JUSTIFIED",
value: a!defaultValue(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{eeced0e5-341f-4e0f-aad6-79467f09a048}modifiedBy'],
"–"
),
readOnly: true
),
a!richTextDisplayField(
label: "Is Active",
labelPosition: "JUSTIFIED",
value: if(
isnull(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{8ba09ff2-5120-49ac-bab2-7d997375aee5}isActive']
),
"–",
{
a!richTextIcon(
icon: if(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{8ba09ff2-5120-49ac-bab2-7d997375aee5}isActive'],
"check-circle",
"times-circle"
),
color: if(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{8ba09ff2-5120-49ac-bab2-7d997375aee5}isActive'],
"POSITIVE",
"NEGATIVE"
)
),
if(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{8ba09ff2-5120-49ac-bab2-7d997375aee5}isActive'],
" Yes",
" No"
)
}
)
)
}
),
a!columnLayout(
contents: {
a!textField(
label: "Middle Name",
labelPosition: "JUSTIFIED",
value: a!defaultValue(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{b616feaa-8189-4835-a141-e120f4aa805d}middleName'],
"–"
),
readOnly: true
),
a!richTextDisplayField(
label: "Date Of Birth",
labelPosition: "JUSTIFIED",
value: if(
isnull(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{f1bda36e-e344-47ff-9000-67bd4e3dfcbe}dateOfBirth']
),
"–",
{
a!richTextIcon(
icon: "calendar",
color: "SECONDARY"
),
" ",
a!richTextItem(
text: text(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{f1bda36e-e344-47ff-9000-67bd4e3dfcbe}dateOfBirth'],
"mmmm d, yyyy"
)
)
}
)
),
a!textField(
label: "Mobile Number",
labelPosition: "JUSTIFIED",
value: a!defaultValue(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{3ab8b520-8c95-4f98-8e02-773e9f6d51b5}mobileNumber'],
"–"
),
saveInto: ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{3ab8b520-8c95-4f98-8e02-773e9f6d51b5}mobileNumber'],
characterLimit: 20,
readOnly: true
),
a!textField(
label: "City",
labelPosition: "JUSTIFIED",
value: a!defaultValue(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{34070e9c-c36d-473c-ad90-aa8cdaf88897}city'],
"–"
),
readOnly: true
),
a!textField(
label: "E1 Highest Qualification",
labelPosition: "JUSTIFIED",
value: a!defaultValue(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{47098015-6a0f-4b14-8725-eb7cb52a0365}e1HighestQualification'],
"–"
),
readOnly: true
),
a!richTextDisplayField(
label: "E1 Passed Out Year",
labelPosition: "JUSTIFIED",
value: if(
isnull(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{b3a007a2-81f0-442f-92d4-bbb93321b531}e1PassedOutYear']
),
"–",
{
a!richTextIcon(
icon: "calendar",
color: "SECONDARY"
),
" ",
a!richTextItem(
text: text(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{b3a007a2-81f0-442f-92d4-bbb93321b531}e1PassedOutYear'],
"mmmm d, yyyy"
)
)
}
)
),
a!textField(
label: "E2 Highest Qualification",
labelPosition: "JUSTIFIED",
value: a!defaultValue(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{7fea8111-d51c-4117-9e33-ddcd88d1162e}e2HighestQualification'],
"–"
),
readOnly: true
),
a!richTextDisplayField(
label: "E2 Passed Out Year",
labelPosition: "JUSTIFIED",
value: if(
isnull(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{802c85f2-8c70-495f-bfb6-0568eb375bfd}e2PassedOutYear']
),
"–",
{
a!richTextIcon(
icon: "calendar",
color: "SECONDARY"
),
" ",
a!richTextItem(
text: text(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{802c85f2-8c70-495f-bfb6-0568eb375bfd}e2PassedOutYear'],
"mmmm d, yyyy"
)
)
}
)
),
a!richTextDisplayField(
label: "Experience1",
labelPosition: "JUSTIFIED",
value: if(
isnull(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{59f15166-bc62-4a23-bf8d-e9dd54f96422}experience1']
),
"–",
{
a!richTextIcon(
icon: if(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{59f15166-bc62-4a23-bf8d-e9dd54f96422}experience1'],
"check-circle",
"times-circle"
),
color: if(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{59f15166-bc62-4a23-bf8d-e9dd54f96422}experience1'],
"POSITIVE",
"NEGATIVE"
)
),
if(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{59f15166-bc62-4a23-bf8d-e9dd54f96422}experience1'],
" Yes",
" No"
)
}
)
),
a!textField(
label: "J1 Position",
labelPosition: "JUSTIFIED",
value: a!defaultValue(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{7074c398-99a7-4a15-be60-21f4df1cf629}j1Position'],
"–"
),
readOnly: true
),
a!richTextDisplayField(
label: "J1 End Year",
labelPosition: "JUSTIFIED",
value: if(
isnull(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{e19ada7d-8957-4433-915f-9723459f1bf2}j1EndYear']
),
"–",
{
a!richTextIcon(
icon: "calendar",
color: "SECONDARY"
),
" ",
a!richTextItem(
text: text(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{e19ada7d-8957-4433-915f-9723459f1bf2}j1EndYear'],
"mmmm d, yyyy"
)
)
}
)
),
a!textField(
label: "J2 Company",
labelPosition: "JUSTIFIED",
value: a!defaultValue(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{4ae5215c-ad2a-46bf-8fbf-e7aaa0554b40}j2Company'],
"–"
),
readOnly: true
),
a!richTextDisplayField(
label: "J2 Start Year",
labelPosition: "JUSTIFIED",
value: if(
isnull(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{f5e69adf-881a-4cf5-b122-d4b5b3ed293d}j2StartYear']
),
"–",
{
a!richTextIcon(
icon: "calendar",
color: "SECONDARY"
),
" ",
a!richTextItem(
text: text(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{f5e69adf-881a-4cf5-b122-d4b5b3ed293d}j2StartYear'],
"mmmm d, yyyy"
)
)
}
)
),
a!textField(
label: "Area Of Interest",
labelPosition: "JUSTIFIED",
value: a!defaultValue(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{3aab2578-c67c-4d50-84ff-6da7fa8960c6}areaOfInterest'],
"–"
),
readOnly: true
),
a!richTextDisplayField(
label: "Created On",
labelPosition: "JUSTIFIED",
value: if(
isnull(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{635070a6-6562-4064-9eee-682b7d543fb7}createdOn']
),
"–",
{
a!richTextIcon(
icon: "calendar-o",
color: "SECONDARY"
),
" ",
a!richTextItem(
text: text(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{635070a6-6562-4064-9eee-682b7d543fb7}createdOn'],
"mmmm d, yyyy h:mm AM/PM"
)
)
}
)
),
a!richTextDisplayField(
label: "Modified On",
labelPosition: "JUSTIFIED",
value: if(
isnull(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{8e620d67-8013-4dd0-9d86-186cdccd7f4e}modifiedOn']
),
"–",
{
a!richTextIcon(
icon: "calendar-o",
color: "SECONDARY"
),
" ",
a!richTextItem(
text: text(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{8e620d67-8013-4dd0-9d86-186cdccd7f4e}modifiedOn'],
"mmmm d, yyyy h:mm AM/PM"
)
)
}
)
),
a!textField(
label: "Fileupload",
labelPosition: "JUSTIFIED",
value: a!defaultValue(
ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{0f2e5271-3677-4c83-b87c-ead4ef405919}fileupload'],
"–"
),
readOnly: true
)
}
)
}
)
},
divider: "ABOVE",
marginAbove: "STANDARD",
marginBelow: "MORE"
)
}

Best answer by amits0028

Hi Venkat, Please check the datatype of the Mobile Number field. It should be of type VARCHAR.

6 replies

A
amits0028Answer
October 2, 2023

Hi Venkat, Please check the datatype of the Mobile Number field. It should be of type VARCHAR.

    G
    gokulrajp7605
    May 28, 2024

    Hi Amit,  once we modified the data type, in the text field can we add the validation check for, "only integer allow to enter " ..?

    venkatrea696188
    venkatrea696188
    May 28, 2024

    Use regex match to only allow numbers. Go through below code and make necessary changes

     

     if(len(ri!phonenumber)<>10,
                "Length Should be 10 Digits",
                if(regexmatch(
                  pattern:"^(\+91[\-\s]?)?[0]?(91)?[6789]\d{9}$",
                  searchString:ri!phonenumber),null(),
                  "Please Provide Valid Number"
                )),

    mathieud0001
    mathieud0001
    Brainy
    October 2, 2023

    You can't use an integer for a phone number field.

      stefanhelzle0001
      stefanhelzle0001
      Brainy
      October 2, 2023

        mikes0011
        mikes0011
        Brainy
        October 2, 2023

        for the love of god, this.

        The Expression Guru
        Terms & ConditionsAccessibility statement