575
Hi Experts,
i Have a grid in a form.which has several fields(String edit) there are lookups on these fields as well.
the string edit field save the anyvalue (typed in by use or values from lookup)..i dont want this to happen the string edit should take values only from the lookup field.
is there any property that i need to change for this?
Thanks&Regards
Adam
*This post is locked for comments
Hi,
You can't just do simple validation of blank value.
If the value of ServicePlanId comes from the lookup then you need to validate whether the value exist the list of lookup (either from other table or fixed list, etc).
For example:
public boolean validate()
{
boolean ret;
InventTable inventTable;
ret = super();
if(InventJournalTrans.ItemId)
{
inventTable = InventTable::find(InventJournalTrans.ItemId);
if(!inventTable.recid)
ret = checkFailed("Item ID is not exist in table master item table.");
}
return ret;
}
Hi David,
I have added this code but it validation showing for both manual entry field and value selected from the lookup .how to avoid this
public boolean validate()
{
boolean ret;
ret = super();
if(smaagreementline.ServicePlanId)
{
ret = checkFailed("plan is already suspended");
}
return ret;
}
I agree with using a validation. Don't try to force users to use the lookup form; they may have a valid value copied from elsewhere and they should be able to paste it to the string field. It's important for their productivity.
Hi,
The edit field is related/lookup from other tables? If yes, then it will do the validation. If no then you can override validateField() method of the table/datasource. You can put your validation logic in the method.
Regards
#1
André Arnaud de Cal...
293,233
Super User 2025 Season 1
#2
Martin Dráb
231,923
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
