0

Preventing filed duplication that contain alpha and numeric values?

I currently have a simlar fomula to prevent a unique refrence filed being duplicated if is a number, however my client refences are a mixture of letters and numbers (i.e TRUS01), how can i adpat the follwing forula to prevent duplication, any help woul dbe much appreciated, thank you.

let myField := 'Client Reference';

if cnt('Clients') >1 then

alert("This content does already exist, please enter another one!");

'Client Reference' := null

end

2 replies

null
    • Nick
    • 4 yrs ago
    • Reported - view

    Try this:

     

    let myField := 'Client Reference';

    if cnt(select Clients where 'Client Reference' = myField) >1 then

    alert("This content does already exist, please enter another one!");

    'Client Reference' := null

    • Terry_Prokopchuk
    • 4 yrs ago
    • Reported - view

    Works perfeclty, thank you Nick :)

Login to reply

Content aside

  • 4 yrs agoLast active
  • 2Replies
  • 601Views