Hi Zoho,
I have a form that is being update every week.
In the form the user enters a list of approved agents,
and than in a subform lists the valuations he got from them.
On input, the list the user entered is translated to a drop-down menu of all the approved agents from the user to choose from.
But when the user is updating the list - I need to have an alert if an entry in the subform is from an agent that is no longer approved.
Trying to script the following on the list entry field "On Update":
Approved_Agents_List_New = List();
Approved_Agents_List_New = input.Approved_Agents.toList(",");
for each line in Agent_Valuation
{
Name = line.Agent_Name;
if Approved_Agents_List_New .contains(Name )=false
{
alert(Name +" is broker is not an approved anomore, please update the data");
}
}
I get an error that an alert can only be used on Loan, On Validate and On Change (What is "On Change"?) actions.
How can I solve this?
Thanks
Ravid