Custom number transform function
Introduction
The custom number transform function is used to map a given number to a target field.
If you've added/updated a map shape before, you'll be used to selecting a source field and a target field. However, when a custom number transformation is used we don't select a source field - the custom number transformation is our data source.
Adding a custom number transform
Step 1 In your process flow, access settings for your map shape:
![](https://doc.wearepatchworks.com/~gitbook/image?url=https%3A%2F%2F2440044887-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FLYNcUBVQwSkOMG6KjZfz%252Fuploads%252FWVyqnULF7g5M3Pd7G8aN%252Fcustom%2520string%25201.jpg%3Falt%3Dmedia%26token%3Dff64e072-de9d-409d-b428-5d8ccfc9fdad&width=768&dpr=4&quality=100&sign=f8ed2303&sv=1)
Step 2 Select the add transform button for the required mapping rule - for example:
![](https://doc.wearepatchworks.com/~gitbook/image?url=https%3A%2F%2F2440044887-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FLYNcUBVQwSkOMG6KjZfz%252Fuploads%252FxOOae75HpSijTH2Ou8AJ%252Fmap%2520transform%25203.jpg%3Falt%3Dmedia%26token%3D9f624f78-9604-47d4-b599-86d75760b7ce&width=768&dpr=4&quality=100&sign=986a640e&sv=1)
Step 3 Click the add transform button:
![](https://doc.wearepatchworks.com/~gitbook/image?url=https%3A%2F%2F2440044887-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FLYNcUBVQwSkOMG6KjZfz%252Fuploads%252F3Ua8TKaE4TZFejZDXzLl%252Fmap%2520transform%25204.jpg%3Falt%3Dmedia%26token%3D9ad403ed-d029-4c81-ab5c-ee9839b6316d&width=768&dpr=4&quality=100&sign=1aa8f94b&sv=1)
Step 4 Click in the name field to access a list of all available transform functions, then select custom number:
![](https://doc.wearepatchworks.com/~gitbook/image?url=https%3A%2F%2F2440044887-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FLYNcUBVQwSkOMG6KjZfz%252Fuploads%252F9FlaMgLzNkYUWmpdcGsY%252Fcustom%2520number%25201.jpg%3Falt%3Dmedia%26token%3D134649c7-7ca0-4a52-98d2-3c35dee21420&width=768&dpr=4&quality=100&sign=cd630173&sv=1)
Step 5 Move down to the custom number field and enter your required number - for example:
![](https://doc.wearepatchworks.com/~gitbook/image?url=https%3A%2F%2F2440044887-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FLYNcUBVQwSkOMG6KjZfz%252Fuploads%252FDNyh1Ixtg6vTCpwgReDs%252Fcustom%2520number%25202.jpg%3Falt%3Dmedia%26token%3Dfab95842-a616-44a0-9681-ff67ec5d24e5&width=768&dpr=4&quality=100&sign=6baf6d6&sv=1)
Step 6 Accept your changes:
![](https://doc.wearepatchworks.com/~gitbook/image?url=https%3A%2F%2F2440044887-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FLYNcUBVQwSkOMG6KjZfz%252Fuploads%252FrPAXC3oBpx6UnypYopd1%252Fcustom%2520number%25203.jpg%3Falt%3Dmedia%26token%3D82f7e04e-8047-41a6-85e6-1ddfc123f811&width=768&dpr=4&quality=100&sign=b9d83f75&sv=1)
...then save the transformation:
![](https://doc.wearepatchworks.com/~gitbook/image?url=https%3A%2F%2F2440044887-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FLYNcUBVQwSkOMG6KjZfz%252Fuploads%252FGngw5LlMxvjwW4UTsk3x%252Fcustom%2520number%25204.jpg%3Falt%3Dmedia%26token%3D29c0e075-1fa1-4948-aeb3-84a6f8046d1e&width=768&dpr=4&quality=100&sign=c5997187&sv=1)
Step 7 Now you can select a target field in the usual way - for example:
![](https://doc.wearepatchworks.com/~gitbook/image?url=https%3A%2F%2F2440044887-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FLYNcUBVQwSkOMG6KjZfz%252Fuploads%252F1hG7URex0oKXVNdfuKUc%252Fmap%2520transform%25209.jpg%3Falt%3Dmedia%26token%3D9819a58e-8213-458f-ac2a-ed981ecc58cd&width=768&dpr=4&quality=100&sign=faf84971&sv=1)
...then:
![](https://doc.wearepatchworks.com/~gitbook/image?url=https%3A%2F%2F2440044887-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FLYNcUBVQwSkOMG6KjZfz%252Fuploads%252FgzRyA9oiTMGD44GyJ1au%252Fcustom%2520number%25205.jpg%3Falt%3Dmedia%26token%3D1ab14fb1-e728-4539-808b-c5b730e71690&width=768&dpr=4&quality=100&sign=d4bbfcca&sv=1)
...then:
![](https://doc.wearepatchworks.com/~gitbook/image?url=https%3A%2F%2F2440044887-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FLYNcUBVQwSkOMG6KjZfz%252Fuploads%252FDiMNlzUQgRLdG0n2PvG2%252Fcustom%2520number%25206.jpg%3Falt%3Dmedia%26token%3Dbced1908-290b-4ace-a438-8f96b485f08c&width=768&dpr=4&quality=100&sign=91ae6211&sv=1)
Step 8 Once your mapping is complete, the row should be displayed without a source field - for example:
![](https://doc.wearepatchworks.com/~gitbook/image?url=https%3A%2F%2F2440044887-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FLYNcUBVQwSkOMG6KjZfz%252Fuploads%252FU4txHNrK5OwgnKSKFxEU%252Fcustom%2520number%25207.jpg%3Falt%3Dmedia%26token%3D90ff110d-2239-43dd-bdf3-13f2260210f0&width=768&dpr=4&quality=100&sign=f5e6059&sv=1)
From here you can save changes or add more mapping rules as needed. Next time the process flow runs, the custom number will be mapped to the given target field.
Last updated