Finance | Project Operations, Human Resources, ...

How to avoid user to type in lookup field using validation method

(0) Share

Report

Posted on by HammadAhmed12

I want to add the validation field so that user avoid to type in lookup field and type some garbage value that would not important for me to deal with.

I have the same question (0)

All responses (14)

Answers (0)

Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report

Hi HammadAhmed,

You need to write code in "validateField" method of the table and validate whether the value given in the lookup field.

Just convert the query you have added in the lookup to select statement and validate the lookup field values.

Also if the lookup field has a relation with the other tables - By standard it will give validation if you enter values other then values from the related table.

Thanks,

Girish S.

Was this reply helpful? Yes No
Suggested answer

Arunraj Rajasekar 1,743 on at

Like (0)

Report

Hi Hammad,

You can accomplish this by using the validatefield method. Write a select statement to look for the record entered in the field; it will return false if the typed value is not found in the table.

Was this reply helpful? Yes No
HammadAhmed12 30 on at

Like (0)

Report

Kindly elaborate it by code

Was this reply helpful? Yes No
Arunraj Rajasekar 1,743 on at

Like (0)

Report

Please see the blog below for sample.

For custome table

www.atnyla.com/.../909

For extension table

ztirom.at/.../

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report
Refer to the below syntax for validateField method.

Public boolean validateField(FieldId _fieldIdToCheck) { boolean ret; ret = super(_fieldIdToCheck); if(_fieldIdToCheck == fieldnum(YourTableName, YourLookupFieldName) { convert the lookup query to standard select statement. if(!bufferName.RecId) //if select statement doesnt return any buffer. { ret = checkFailed("throw warning"); } } return ret; }

Thanks,

Girish S.

Was this reply helpful? Yes No
HammadAhmed12 30 on at

Like (0)

Report

I got syntax error

Was this reply helpful? Yes No
Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report

You are missing one more bracket at if condition.

Also where is your select statement for validating records?

if(_fieldIdToCheck == fieldNum(tableName, fieldName))

Was this reply helpful? Yes No
HammadAhmed12 30 on at

Like (0)

Report

I didn't understand how to do select statement in this method

Was this reply helpful? Yes No
Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report
You are adding a lookup from the table "Ui_EmployeesDept" and adding range to "operating unit number" field - value should be "00000011".

Now on the table level validate field you need to add the select statement based on the above condition. Like below.

Public boolean validateField(FieldId _fieldIdToCheck) { boolean ret; UI_EmployeesDept employeesDept; ret = super(_fieldIdToCheck); if(_fieldIdToCheck == fieldnum(YourTableName, YourLookupFieldName) { select fisrtOnly * from employeesDept where employeesDept.Name == this.Name && employeesDept.OMOperatingUnitNumber == "00000011"; if(!employeesDept.RecId) //if select statement doesnt return any buffer. { ret = checkFailed("throw warning"); } } return ret; }

Thanks,

Girish S.

Was this reply helpful? Yes No
HammadAhmed12 30 on at

Like (0)

Report

Now its givings me syntax error... Why?

Was this reply helpful? Yes No