When creating a new formula, it is our practice to first build the formula connected to staging sites before pushing to a production environment. It is common for data in staging environments to be slightly altered. One example of this is that user email addresses are prepended with a short string of characters in-order to invalidate the email. This makes it impossible to match on email when using the omatic connector.
I would like to request that the ability to append/prepend a small string to the value in the transformation section or perhaps in the concatenation section.
The is similar to another posted Idea: https://support.omaticsoftware.com/support/discussions/topics/28000008691
Do you have other scenarios where the append/prepend would be helpful?
One way to accomplish invalidating emails with the current clean-up tool would be to use the 'Remove specific characters' option and take out the '.com' string of text from the emails.
Thank you for your feedback!
Product Manager - Omatic Cloud
At this time, I haven't run across anything I can think of off hand. However, the issue has more to do with matching than it does invalidating emails. Since all of the emails in our test system have this prepended text, it shows as different. Currently we are unable to ignore this field, so being able to prepend a static text to the field would be helpful.
Thank you for the additional information!