Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Correcting poorly typed web submissions
We use web-to-record for getting applicant leads. However, many applicants type in personal information such as name and city without proper case. I wanted to correct these fields on new web submissions. I did not want to correct new records added internal personnel.

1) I made a hidden field on the web page that sets a field in the application record to true to indicate that it is a web submission.

2) I made a record change rule that checks for new web submissions.

3) I made a action that modifies the contents of the fields as required. The following formula changes the first letter of each word to upper case and the remaining letters in each word to lower case, for up to four words in the field.

Trim(Replace(List(" ",Upper(Left(Part([City],1,"-/ "),1)) & Lower(NotLeft(Part([City],1,"-/ "),1)),Upper(Left(Part([City],2,"-/ "),1)) & Lower(NotLeft(Part([City],2,"-/ "),1)),Upper(Left(Part([City],3,"-/ "),1)) & Lower(NotLeft(Part([City],3,"-/ "),1)),Upper(Left(Part([City],4,"-/ "),1)) & Lower(NotLeft(Part([City],4,"-/ "),1))),".",""))

If anyone has any recommendations on how to simplify this code or to make it apply to more than four words without additional Part() clauses, I would appreciate your response.
ID
589
Category
Setup
Author

Shem Sargent
Date Created
12/11/2012 12:00:22 PM
Date Updated
2/5/2014 2:31:47 AM
Comments
Rick Cogley 1/10/2013 12:08:29 AM
I wonder, could you not use a field in the webform that is for capturing webform data only, and use a default formula to fill the main field, if data is present in the webform field. If an internal visitor is using, they do not even see the webform version.

[City_] - receives whatever the web visitor types
[City] - defaults to Upper([City_] maybe inside an If() or Case() that checks to see if [City_] is blank. And, this is what the internal user sees.

Just off the top of my head.
basenine 2/5/2014 2:31:47 AM
It would be really nice if TD just had the Proper() formula reference. It has Upper() and Lower()....just needs Proper()!

Nice formula BTW Shem - a real head scratcher!

I think I'll export my data into Excel for my requirements this time (it's a one off, of over 16000 records).

Cheers anyway 😀
Feedback
Back to Search Results