Copy text left 1 and .

Ask the community
,
1

Dear community, I would like to protect the names of our football players from the database. I have a text field and I want to shorten it, the player in the database has to fill 2 fields first name and surname and I want to output it in the database as follows

Abraham Lincoln = A.L.

My idea is to make an invisible field in the form and encode the formula there and write it into the database - can someone code it please?

Thanks

2

Here’s a link to a thread with a number of different solutions. Choose the one that’s easier or most understandable. An Internet search will turn up a bunch of other options.