Update field contents from another field

Question

Hi All,

I have a field called IP Phone which allows us to enter the users IP phone number which our Mitel system uses to create the users extension in Mitel.

We need to add another field (Which does not necessarily need to be visible) that updates from the extension adding a * in between the second and third number.

So we enter 1001 I then want the new field to put 1*001 any assistance would be appreciated thanks.

Comments

Hello Kevin,

Could you, please, clarify what attribute is used to store the extension? Or is it the IP Phone property itself that should be updated with an asterisk (*) character and saved to another property?

---

We currently complete the IP Phone property name but I need to create a field to update Extension attribute 13 that automatically populates once someone enters an extension into the IP Phone field thanks.

the text in the extension attribute 13 field needs to be what ever is entered into the IP Phone box but with a * between the 1st and 2nd characters e.g.

I enter 1001 into the IP phone box then move off the box or save, i need the extension attribute 13 box to auto populate with 1*001 thanks.

Answer 1

Hello Kevin,

The solution will include a Business Rule executed After Creating a User and a PowerShell script. The script will take the value of the IP Phone property, insert an asterisk (*) between the first and the second character and update the Extension Attribute 13 property. To implement the solution:

1. Launch Adaxes Administration Console.

2. In the Console Tree, right-click your service node.

3. In the context menu, navigate to New and click Business Rule.
   

4. On step 2 of the Create Business Rule wizard, select User object type.

5. Select After Creating a User and click Next.
   

6. Click Add an Action.

7. Select Run a Program or PowerShell script and paste the below script into the Script field. In the script, the $extensionProperty variable specifies the LDAP name of the property that will store the updated IP Phone value (with asterisk).
   

    # Get property value
    $extensionProperty = "extensionAttribute13" # TODO: modify me
    try
    {
        $value = $Context.TargetObject.Get("ipPhone")
    }
    catch
    {
        $Context.LogMessage("The property IP Phone is not specified for user %fullname%.", "Information")
        return
    }
   
    # Update the user
    $newValue = $value.Insert(1,"*")
    $Context.TargetObject.Put($extensionProperty, $newValue)
    $Context.TargetObject.SetInfo()

8. Specify a script description and click OK.

9. Click Next and finish creating the Business Rule.

Comments

To Support3 Thanks very much that worked great.