Thank you for the solution and the reference! I appreciate it.

I have a form that checks for duplicate names (these are first and last names within one field) but I would like the script to ignore any spaces at the end or before the text (but not if there is a space between words) no matter how many words are in the field. For example, the current script would ...

This is working correctly now. Thank you again!

I tried to request access but I dont know if you received the message. Below is what I get when I click on the link. 

I was wondering about over using resolveNode(). Thank you!

@Mayank_Tiwari  Great! thank you, this is very close! One issue I'm finding is that when you tab through the fields adding values, and if you leave adjustedRate value null or empty (or type a value then delete it after), hourlyRateUsed becomes a null or empty value. If adjustedRate is empty then I n...

I'm so close but maybe my script is way to cumbersome and needs to be written in a different way. We ( @Pulkit_Jain_ and @Mayank_Tiwari ) had this form working but the customer wanted another functionality added to my tbleEmployeeInfo table. We added a column with a field named adjustedRate. If this...

Thats it! I thank you from the bottom of my heart!!! I'm learning everyday and you guys are a big part of it.

Please forgive me, I just cant get this to work. Can you look at my document and see where I'm going wrong? I need to specify where the duplicates are and highlight them somehow when the button is clicked. I've tried a few things but I still cant get the script to check any table but the first one. ...

@Mayank_Tiwari I was able to create a validate button at the bottom of the form and get it to work the same as your original idea. The issue is that it still only indicates duplicates within the original table. For example, if I put a value in the first employeeName field then click on the "Add Payr...