I am not sure if you consider SharePoint "programming" but I am very new to it. I would like to create a list with calculated values but still provide the user the ability to edit the values. For example, take the following list of a group of people who have first names, last names, and nick names.
First Name | Last Name | E-mail John Smith [email protected] Bob Adams [email protected]
For a good lot of the people their e-mail is [email protected], so I would like to fill this in by default. To do this I used a calculated value column to extract the first initial and concat it with a "." as well as the last name and finally "@domain.com".
The problem is there are a few one off cases where I would like the user to have the ability to correct their email. Bill Douglass may want to use his personal email such as "bill.d[email protected]" and this would obviously break the formula.
So my question is simply how can I have a calculated value list but still allow people to override the value.