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" )}
Discussion posts and replies are publicly visible
Hi Venkat, Please check the datatype of the Mobile Number field. It should be of type VARCHAR.
You can't use an integer for a phone number field.
for the love of god, this.
Hi Amit, once we modified the data type, in the text field can we add the validation check for, "only integer allow to enter " ..?
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" )),