Start a new topic

Add ability to append custom text to incoming field

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.


4 people like this idea

Michael, 


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!


Chanel Floyd

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!

Login or Signup to post a comment