Omatic Cloud
367 results found
-
Implement anti record looping in Mailchimp
It would be nice to be able to stop records from looping back and forth in Mailchimp. One way to prevent this could be using a custom field such as "last updated by Omatic Cloud" that gets updated when sending records to Mailchimp so that they don't come back through the subscribers formula.
1 vote -
Add transformations to use for various number formatting options
It would be very helpful to have number transformations available for number to currency, options for decimals or not, options for currency symbol, adding commas, etc. I have a rating file from a vendor with the value amount showing as 56740 as an example. This is difficult to read so I would like to transform it to $56,740. Currently my only option is to use a formula in the source file in excel to convert it from the number to text in the $#,##0 format. I have to manually do this for 10+ columns every time I get a new…
3 votes -
Update ECS Transaction Type for Engaging Networks
Currently, we are not able to bring over supporter data for Event attendee supporter data with the ETA transaction formula type. The ECS transaction type does support event attendee supporter data in the API but that data is not currently in the EN connector. It would be helpful to have access to Event Attendee supporter data because otherwise, we will need to use a Flat File import.
1 vote -
Importing data to a field on a top level object ONLY if the field is blank and ignoring it if it's already populated
We have fields we'd like to import into a top-level object but only want them to import if the field in Salesforce is blank. If the field is already populated, then skip importing that field from Import Omatic.
3 votes -
Add ability to assign Interest Groups in Mailchimp for only newly added records (query source)
When we use a query source to both update existing Mailchimp records and to add new Mailchimp records, we would like the ability to assign interest groups to new MC records but not overwrite preferences on already existing records. Currently after the formula processes, we need to go to MC and create a segment using the email added on date to find newly added records and assign them to group(s).
1 vote -
Partial string 'Replace' transformation
It was a sad day when I realized that there wasn't a Transformation for address abbreviation standardization like there is in IOM (https://support.omaticsoftware.com/s/article/RegularExpressionDictionaryforAddressAbbreviations) and sadder still when I learned that I couldn't create a transformation of my own. While the 'Replace' transformation will IDENTIFY a field value containing a qualifying text string just fine, it will also replace the ENTIRE field value (not just the identified text string) with whatever replacement value you designate. Thought you could use a transformation for common address standardizations like replacing "Street" with "St"? Think again, because the way it exists now will…
7 votes -
Fuzzy text string matching
Human beings are imperfect and ever-changing, and I expect OC to accommodate that variability the same way IOM does. If OC cannot find a potential Constituent or Relationship match between nearly identical strings like "Rachel Bailey" and "Rachael Bailey," then I'm forced to use IOM until it does. In the meantime, my organization is paying extra for a software that creates multiple duplicate Constituent, Relationship, and Address Records. See also https://omatic.uservoice.com/forums/950413-omatic-cloud/suggestions/46745101-allow-matching-on-fuzzy-address-formats
10 votes -
Enable Importing Event Registrations from GiveCampus
The GiveCampus integration currently supports only importing gifts. Events is another large use for the platform and one we're looking to leverage. Being able to utilize this would improve our process flows greatly.
8 votes -
Add UTM fields to GiveCampus connector
GiveCampus recently added the UTM fields to their Gift API. We would like these added to help with tracking gift appeal data.
1 vote -
Include Date Added and Date Processed fields to review bucket export
I love the new fields for Date Added and Date Processed. It would be nice to include these in the Export that we can create from review buckets to help with troubleshooting in excel.
1 vote -
Export Formula Option from Data Queue
It would be helpful to be able to export the formula from the Data Queue screen rather than having to open the formula and navigate to the mapping page. The button location could be below the "Other Options" section on the formula options flyout.
1 vote -
Ability to Overwrite an Entire Data Extension in SFMC
In some cases, it would be great to be able to instead of update the Data Extension, instead having the ability to Overwrite it with all records in a query. So all records not in the query are removed from the Data Extension.
1 vote -
Enforce Default Data Differences Selection During Setup
It would be great to make the "Default Data Differences" selection more transparent to the user during setup. It opens them up to the risk of overwriting data in mass if they are sending records from the "Ready" bucket and have left the default difference as Source and have not switched it to Destination.
4 votes -
ability to select what fields are updated separate from mapping/matching fields
It would be helpful if we could use fields for matching but then select which ones we actually want to be updated.
For example, match on name or Constituent ID/Donor ID, but only update the email address or web appeal activity information.3 votes -
Multiple Route to Ready Criteria Options
It would be helpful to have the OR operator for "Route to Ready" based on critera.
Ex: If Classy ID matches, Route to Ready
OR
If First Name/Last Name/Email matches, Route to Ready
3 votes -
Need someway to determine what data DID NOT flow through Omatic
We've had multiple instances of data not flowing from LO through Omatic and into SF. It would be great if there was a list of items that were not pushed through Omatic, so we would know what needed to be moved manually from LO to SF.
0 votes -
Duplicate data checks between columns
It would be helpful to have the ability to compare fields in different columns to each other, to check for duplicate values. For example, when we're working with files that contain more than one address, email, phone etc. while being able to either blank out the value if its a duplicate of another field, or keep it if it isn't.
3 votes -
Omatic Data Service
We currently have a subscription to Omatic Data Service with IOM to find fuzzy match duplicates during import. This service has been critical in reducing the number of duplicates created in the database. Will ODS be available in IOM+? I'm concerned that duplicate records will start to increase without it. This becomes a big issue after year-end when preparing tax receipt letters if donors have gifts spread over multiple records.
2 votes -
Autoreprocess on Destination Exception Queue
It would be helpful to have retry/resend logic on records in the destination exception queue.
Examples: running Classy Recurrings Gifts and Classy Transactions on a continuous schedule, API limits exceeded, etc. This would be very help especially for clients that have to link records to parent records but want continuous functionality.
3 votes -
Additional Object Picker Field Access for Contact Roles
It would be great to have access to additional fields on the object picker when creating Contact Roles in Salesforce. This would allow for the prevention of duplicate Contact Roles being created in Salesforce if a Contact Role already exists for a Contact on an Opportunity.
Our integration is set up to create a TeamRaiser Participant Contact Role in Salesforce in order to soft credit a person who is fundraising and receives a donation. When a person donates to his/her own fundraising efforts, a donor Contact Role is created (as desired) for that person along with a second Contact Role…
1 vote
- Don't see your idea?