How can I have two calculated value together on one field?
I want to use proper function & text format remove together.
what do I need? ( and. &. ) ?
I find the answer of this question.
You can do it at least in two ways.
In order to help any programmer looking at the code years after you went unleashed on it, I'd suggest learning to use the Let () structure.
Let ( [
tfr = TextFormatRemove( yourField ) ;
prop = Proper ( tfr);
myResult = prop ];
Sir, I Do it This Way:
Proper ( TextFormatRemove ( First Name ) )
Am I choose wrong way?
There is nothing wrong, since your calculation keep simple enough, there are only 2 functions both have only 1 parameter.
When you use more functions and parameters, it will become 'unreadble', then you'd want to use the Let() method he wrote.
Retrieving data ...