M-Files is a 2025 Gartner Peer Insights Customers' Choice for Document Management
➡️Download the report!

Options
  • Locked Locked
  • Replies 10 replies
  • Subscribers 9 subscribers
  • Views 364 views
  • Users 0 members are here
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

A little VB Script help please?

Former Member
Former Member
I have property definitions for FirstName, Surname, and FullName.
I need the user to be able to enter the FullName in a single field, and to automatically calculate the FirstName and Surname.
I can use the automatic value 'Simple concatenating of properties' to achieve the reverse result, but presume I need to use Calculated Value(VBScript) to separate the FirstName and Surname.
I could do it easily in EXCEL but I'm not a programmer and don't know how to do it with VBScript. ???
I wonder if somebody would be kind enough to give me the code for this?
Parents
  • Former Member
    Former Member
    you have to change that on the line 8 to match the property ID you are using.
    Aha! Thanks for that. Works perfectly now. I replaced the Comma Postion with Space Position so that the FullName presents normally. I guess it will work fine so long as we don't have to deal with someone putting in two spaces accidentally.

    Thanks for your help.
Reply
  • Former Member
    Former Member
    you have to change that on the line 8 to match the property ID you are using.
    Aha! Thanks for that. Works perfectly now. I replaced the Comma Postion with Space Position so that the FullName presents normally. I guess it will work fine so long as we don't have to deal with someone putting in two spaces accidentally.

    Thanks for your help.
Children
No Data
M-Files
M-Files Support


© 2025 M-Files, All Rights Reserved.