Very helpfull however it took me a while to figure out that you have to 'click out' in order for FM to run the script in the Hide Object. Is there a way to run that Hide Object script when tabbing to the next field?
Thank you for the great idea. I added a checkbox field next to the duplicate flag, called "HideDuplicate". I use a different field name than you, but I essentially hide the checkbox field using the following Calc, "Count ( Patients NameLast::NameFirst) ≤ 1". I then hide the Red duplicate warning with "Count ( Patients NameLast::NameFirst) ≤ 1 or Patients::HideDuplicate = 1" The "HideDuplicate" field is set to be a checkbox with a value of 1. I do this, because I would imagine that you may want to hide the warning occasionally for a common name like Robert Smith or José Garcia, that is actually not a duplicate.
I need to have three fields. Last, First and Diocese. I tried using your examples. First and last name shows up but not the Diocese. So how do you string three fields?
Create a calculation field as something like: NameFirst & " " & NameLast & " " & Diocese. In the long run, I think it's worth the time invested to learn these kinds of tricks. Best of luck to you.
![Lp. Сердце Вселенной #60 РОЖДЕНИЕ ЛОЛОЛОШКИ [Финал] • Майнкрафт](http://i.ytimg.com/vi/YoR0pAV9FVQ/mqdefault.jpg)
excellent just what i wanted.
you are the best.... thankyou
Excellent video that is tremendously helpful. Thanks for taking the time to make the world a better place!
Thankkkk youuuuuuu
Very helpfull however it took me a while to figure out that you have to 'click out' in order for FM to run the script in the Hide Object. Is there a way to run that Hide Object script when tabbing to the next field?
Thank you for the great idea. I added a checkbox field next to the duplicate flag, called "HideDuplicate". I use a different field name than you, but I essentially hide the checkbox field using the following Calc, "Count ( Patients NameLast::NameFirst) ≤ 1". I then hide the Red duplicate warning with "Count ( Patients NameLast::NameFirst) ≤ 1 or Patients::HideDuplicate = 1"
The "HideDuplicate" field is set to be a checkbox with a value of 1.
I do this, because I would imagine that you may want to hide the warning occasionally for a common name like Robert Smith or José Garcia, that is actually not a duplicate.
I need to have three fields. Last, First and Diocese. I tried using your examples. First and last name shows up but not the Diocese. So how do you string three fields?
Create a calculation field as something like: NameFirst & " " & NameLast & " " & Diocese.
In the long run, I think it's worth the time invested to learn these kinds of tricks. Best of luck to you.
very nice explanation about self join thanks you're really great thanks
You're very welcome Armando.
Thank you for this - it was a quick and easy implementation which really helped me on a project!
Hi, as usual... !! Great Job !!. It is very usefull.
From Colombia, thanks a lot.
Muchas gracias César!
Shouldn't your calculation (at 8:28) be based on FirstnameLastname? You just used Firstname.
Way too complicated...