Omatic Cloud
317 results found
-
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 -
Import of Fund Relationships
There is currently no functionality to import new Fund Relationships or update existing ones via import. We would like to track scholarship recipients directly on the fund itself. Providing this functionality would allow us to import the students receiving aid, making your solution even more valuable than it already is.
Thank you!1 vote -
Comparative Logic for Date Inputs
We would greatly benefit from the addition of a function within transforms to compare a date input with a dynamic date provided at runtime. For example: if End date < Today’s Date then Replace input value with “Inactive”.
In our Raiser’s Edge database, we rely on the Constituent Code “Start date” and “End date” fields to determine when a donor opted into a program and whether they are still active with that program.
Presently, to update the status fields in our destination records, we’re forced to build a distinct NXT List for each pairing of program and status, as well…
20 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 -
Ability to "deactivate" user without deleting in Omatic Cloud
If a user needs to go on extended leave but should not have access to Omatic Cloud, the only current option is to delete their record (and possible history associated with the record). It would be helpful to have the option to temporarily deactivate a non temporary user.
1 vote -
Enable File-to-File Transformation & Export in Omatic Cloud
Currently, Omatic Cloud only allows transformations when importing data into Raiser’s Edge or other connected systems. However, it would be extremely beneficial to have a file-to-file processing option. This would allow users to:
Upload a spreadsheet, apply transformations, and export the transformed data as a new file (CSV, Excel, etc.).
Use Omatic’s powerful transformation tools without requiring integration with an external database.
Improve data cleaning and preparation workflows for reporting, imports, and other external processes.
This feature would save time and expand Omatic Cloud’s usability beyond direct imports. Please consider adding this functionality in a future update!1 vote -
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 -
Include flat file name on omatic cloud formula history page
Include flat file name on omatic cloud formula history page. Currently the page shows information like "Formula file upload started," "formula ingestion completed," and "export completed" for the Event column, and details on the number of records processed in the Description column, but it would be nice to include the name of the uploaded file in the Description column so you can easily identify which file was being handled. We use a flat file formula pretty frequently, with unique file names, and this would be very useful.
13 votes -
Applying Gift to Head of Household (HOH)
Would like to apply incoming gift records to the Head of Household in Raiser's Edge, even if the gift matches the email address of the spouse. If the gift matches to the spouse email address, spouse will also receive soft credit.
6 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 -
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.
6 votes -
Ability to Add Multiple Constituent & Gift Custom Fields in an Import Profile
Need the ability to add multiple custom fields for constituents and gifts. This would be similar to Virtual Fields in ImportOmatic, as it would be very helpful to have that same flexibility and ability of multiple attributes and additional items in Omatic Cloud so we can switch fully to Omatic Cloud.
3 votes -
Allow us to stop/pause formula when running
Give us the ability to "Pause" or "Stop" processing. We currently have to open a ticket with support to kill a process. It would be more efficient and timely if we have that control.
6 votes -
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 -
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
- Don't see your idea?