Check a field whether the name already exists

[kfok]

I have a script to save found set (see below). I don't want user to enter and save duplicate set name. So I want to add a function to check whether the new set name is already exist or not. Please help.

New Record/Request

Show Custom Dialog [Enter the set name]

If [status(CurrentMessageChoice=2]

Delete Record/Request[No Dialog]

Else

Select All

Go to Layout

Paste [Record ID]

End If

[Osman]

You can prevent dublicate datas in one field by chekking unique option from field validation.

[LaRetta]

Hi kfok,

Except field-level validation will not trigger during script (nor would you want it to) so this must be handled yourself. You might consider relationship check. Establish relationship self-join SetName = SetName. Then:

New Record/Request

Show Custom Dialog [ yada yada ]

Exit Record/Request

If [ Status(CurrentMessageChoice) = 2 or Count(selfjoin::setField) > 1 ]

Show Message [ "User Abort or Duplicate Set Name. Request Cancelled" ]

Delete Record/Request

... etc

Personally, I'd use a global to hold their Set Value and only create a new record AFTER the contents have been tested. But that's more a personal choice.

LaRetta