Omatic Cloud
381 results found
-
Bulk in line edit
Having the ability to bulk in line edit records would be very beneficial.
1 vote -
Add the functionality to map 'Class Notes Status' in the Notes field section
The 'Class Notes Status' field is used in RE Database view. We are unable to use Omatic Cloud to import class notes because this field isn't mapped.
3 votes -
Add the "Class Notes Status" field to the Notes field section
Add the "Class Notes Status" field to the Notes field section
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…
4 votes -
Import Processing
I'm just learning Omatic Cloud and a big reservation I have about import processing is that I wish the job would not start processing the second you upload a file. I'd really like to be able to hit 'run' when I am ready for it to do so. There will be times when I upload a file and realize at the last second that I forgot to do something or will realize I've grabbed the wrong file. I just wish there would be the opportunity to say 'are you sure' before it starts running.
1 vote -
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.
0 votes -
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!4 votes -
Match search on existing relationships within record
It would be helpful to match on existing relationships that already exist on a record vs the entire database. For example, if there are duplicates of a non constituent organization relationship, it wouldn't be reasonably possible to narrow down which value was the existing relationship without opening up all the records to review first. Use case - schools, company relationships.
0 votes -
Sort Data Differences in Buckets with Mailchimp Connector
It would be great if we could sort the different Mailchimp connector buckets in a formula by data differences so that they are sorted to the top of the list or bottom depending on preferences. ie. purple highlights at the top or bottom of the list.
1 vote -
Pulling in Mailchimp actions from previous Campaigns sent in previous months, not just current month.
I've noticed that after a mailchimp campaign has been sent, if donor clicks on a link or opens the mailchimp email many weeks or months after it was initially sent, that data does not pull into NXT. It would be great if there was a way to ensure that all mailchimp actions (sent, open, click, unsubscribe, abuse) are pulled into NXT regardless if it's from the current month's mailchimp campaign or an older one.
1 vote -
Add text fields to facilitate documentation of formula configuration background
For each group heading in an ImportOmatic+ formula (in the mapping section of its definition), add text fields to allow the addition of notes by the creators/managers of the formula. This would improve the product by providing a mechanism for documentation directly within the formula. Information that could be included could be explanations of why certain configuration decisions were made, idiosyncrasies and deficiencies expected in the data, where to find current mappings/value lists from data source systems, and other considerations etc.
13 votes -
Set Start Datetime to the Datetime of Last Ingested Transaction
Can we add an option to set the start date and time for formulas to use the datetime of the last ingested transaction, rather than the last job's end datetime?
This is especially helpful for Continuous formulas where a new gift may be added or updated while the formula is running, and now falls outside the new start datetime.
2 votes -
Add connector for Marketo
Add a connector for RE and Marketo to capture consent/solicit changes and campaign results to Actions.
5 votes -
Inactivate old formulas
It would be helpful to be able to inactivate old Omatic Cloud formulas. I would hate to lose the work by just deleting it, but the list is becoming a lot of noise.
1 vote -
Ability to map to Mailing ID and Finder Number on gift record
These fields aren't available through the Blackbaud API, but we have numerous queries and reports that rely on them, dating back to when we first started using RE. We use the Mailing ID field to track the platform through which a gift was made, and the Finder Number field to identify constituents from acquisition mailing finder files. If we can't map to these fields in Omatic Cloud, it will require significant changes to our existing workflows. Currently, I'm adding this data to gift records with a Blackbaud import after importing through IOM+, which is not an efficient process.
3 votes -
Formula Tabs Across Users
At the moment organising the formulas in tabs is a per user setting.
When working in a team, it is useful to categorise them to assist with daily processes, systems, frequencies, etc...
It would be great to be able to have the tabs shared across all users in the environment.
2 votes -
Improve CSV Export Format for Web Front-End Exceptions
When exceptions occur in the web front end, users can export the affected records to a CSV file. However, the exported file does not match the format used by the system's formula, preventing direct external corrections and re-import.
Currently, users must manually look up ID numbers in the original file, extract the rows, make corrections, and then re-import—adding unnecessary steps to the workflow. While small numbers of errors can be fixed directly in the web view, handling large batches this way is impractical.
Proposed Solution:
Provide the option to export the csv data so that it aligns with the format…3 votes -
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…
11 votes -
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.
16 votes -
Name Formats - Custom Checkbox
It would be helpful for OC to have the "Custom" Checkbox for Name Formats. This is currently supported by the SKYAPI but not yet available in OC. https://developer.sky.blackbaud.com/api#api=56b76470069a0509c8f1c5b3&operation=EditConstituentNameFormat
0 votes
- Don't see your idea?