- nysteaAsked on October 26, 2015 at 06:48 PM
When taking in data for a name with two separate fields (FName, LName), many people put a space after their first name without thinking about it. I assume this is an issue in other situations, but it popped up here first for me.
This results in data coming in with reply to fields of Bill  Smith. Is there a way to trip of spaces at the end of a field? In FileMakerPro, the function is "trim". As we're using FMP for data management, I'l just add a trim command to the import, but I still have to deal with adding people to an address book in Mail.
- JotForm SupportEltonCrisAnswered on October 26, 2015 at 10:08 PM
The space was generated from your calculation formula in one of your condition that passes information from the two fields into a single fullname field.
I have tried this setup but I can't seem to reproduce the problem. I think the email client you are using also matters. It doesn't seem to render names with spaces. Here's how it works on my end.
May I know why you are not considering the full name field instead? This will at least minimizes configuration with your form. This contains first and last name field by default.
- nysteaAnswered on October 26, 2015 at 11:29 PM
Thanks for the insight.
I've used the Full Name field in some places, but we need FName and LName as separate fields in the database for other things, such as name tag generation with larger fonts for first name.
If everyone had single first and last names, I could always use Full Name, but Mary Sue Van Alstyne confuses the parsing scripts.
It didn't occur to me to use Full Name in the email. I think it will solve the problem nicely.
- SammyAnswered on October 27, 2015 at 06:10 AM
Glad to hear the Fullname field will address you scenario, should you encounter any difficulties please let us know and we will gladly assist.