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 not catch Firstname Lastname(space) being the same as Firstname Lastname(no space) hence no duplicates detected. Anyone know how to update this? I seem to break it every time I try. The form is located here: https://drive.google.com/drive/folders/1gneWXGTgzvCEeZHBxumR3v429X6nBzbJ?usp=sharing
Thank you!
Solved! Go to Solution.
Views
Replies
Total Likes
You may use Trim[0] method to remove the leading and trailing spaces from the textValue.
Fixed Form: https://drive.google.com/file/d/1WT1OHXjSgVky9RgEmyDf539iPRRqtsti/view?usp=sharing
[0]: https://www.w3schools.com/jsref/tryit.asp?filename=tryjsref_trim
You may use Trim[0] method to remove the leading and trailing spaces from the textValue.
Fixed Form: https://drive.google.com/file/d/1WT1OHXjSgVky9RgEmyDf539iPRRqtsti/view?usp=sharing
[0]: https://www.w3schools.com/jsref/tryit.asp?filename=tryjsref_trim
Thank you for the solution and the reference! I appreciate it.
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies