I have a simple table with Last Name, First Name and Middle Initial. I wrote the following formula to pull the first letter out of each field to suggest a ID
concat(left(field(‘First Name’),1),left(field(‘Middle Initial’),1))+(left(field(‘Last Name’),1))
It works like I want. However, there will be times when the suggested ID won’t be used and I would like the user to be able to type in their own. Is that possible?