Template with powershell that updates the host runs after VPN

Hi,

I am trying to create a setup where i have host entry for a store which contains a IP base adress for the store ie 10.20.30.0
This is so that its easier to create new stores, and update when/if the network changes.


On the POS entries I then have different templates

All these templates have this powershell script under "Event - Before opening".
It updates the host based on the base adress from the parent by,

• Adding 1 to octet 3
• Adding the till number to octet 4

Ie
POS 1 would be 10.20.31.1
POS 1 would be 10.20.31.3
POS 1 would be 10.20.31.2

# Inputs
$baseIp = "$PARENT_CUSTOM_FIELD4$"
$tillNumber = "$CUSTOM_FIELD1$"

# If till number not configured then use the configured host
if ([string]::IsNullOrWhiteSpace($tillNumber)) {
    exit
}

# Split IP into octets
$octets = $baseIp -split '\.' | ForEach-Object { [int]$_ }

# Add 1 to the third octet
$octets[2] += 1

# Add till number to the fourth octet
$octets[3] += $tillNumber

# Handle overflow from third to second
if ($octets[2] -gt 255) {
    $overflow = [math]::Floor($octets[2] / 256)
    $octets[2] = $octets[2] % 256
    $octets[1] += $overflow
}

# Build new IP
$newIp = "$($octets[0]).$($octets[1]).$($octets[2]).$($octets[3])"

$RDM.Connection.TabTitle = "Debug: $newIp"
$RDM.Connection.Host = "$newIp"

My issue is then that it seem like the powershell script are run after the VPN tries to open.
Is there are way to have the powershell update the "host name/ip" before the VPN start to connect ?

On all my other templates (ssh, browser, sftp) thats not an issue because i am using a socks5 proxy.
But for the VNC i need this "VPN" to forward from a local port to port 5900 on the remote host through the socks5 proxy.


Template configuration

VPN configuration