Omatic Cloud
370 results found
-
be able to define "Run Once" to within hours or minutes - not only days
sometimes a gift gets accidentally deleted, so we have to use the "Run Once" function to re-run teh formula. It would help if I could run it for just exactly that single transaction I need to import, rather than a whole day of data which could be thousands of gifts
6 votes -
Add Multiple Notes to One Action
Need the ability to add multiple notes to one action. Existing IOM profiles have many notes per action sometimes, and the ability to replicate this in OC would be helpful.
3 votes -
Allow for the Import of Gift Aid Declarations in Omatic Cloud
Absolutely critical for clients in the UK doing any gift importing. This is a feature that is UK specific but needed to move IOM profiles to OC.
4 votes -
Ability to Import Mapping on completed formulas
It would be great to be able to import a mapping into an existing/completed formula. Right now you can only do this if the formula is in "Draft", but there are many times where we need to be able to import a mapping to a completed formula. The workaround is "Copy and Swap", but that only works in some cases.
4 votes -
Allow In-Line Edit in Formula Exceptions
It would be helpful to have the ability to fix matching formula exceptions using inline edits. Specifically with email connectors, this is would be useful to correct invalid email addresses.
1 vote -
Allow mapping to gift subtype and gift code for pledges
Allow mapping to gift subtype and gift code for pledges. I currently get a message that this in unavailable for pledges.
4 votes -
Ability to import gift note
Currently I cannot import a flat file of gifts into an NXT/webview batch because I want to add a gift note.
3 votes -
Transformations: Completely delete/remove data field
I would like to see that one of the transformations have the ability to completely delete/remove that field. One of the examples that I have come across is for consistuency codes. We use them if someone is giving at a certain amount annually. But if they are not at that level anymore, we need to delete the code. But I can see this being used for attributes or duplicate pieces of contact information.
4 votes -
Match on preferred name in NXT !
We need to be able to check incoming first name against both 'first name' AND 'preferred name/nickname' fields. THIS IS CRITICAL and is causing a much inefficiency and possible data corruption.
1 vote -
Add "Single" as option for Schedule Frequency for Pledges
It looks like Blackbaud has added "Single" as an additional option in their SKY API for schedule frequency in the Gift API call. The full list of options for frequency is now:
"Annually",
"EVERYSIXMONTHS",
"Quarterly",
"Monthly",
"EVERYFOURWEEKS",
"EVERYTWOWEEKS",
"Weekly",
"Irregular",
"Single"Can the API call be updated and coded in Omatic to accommodate the new options for mapping this field?
https://developer.sky.blackbaud.com/api#api=gft-gifts&operation=CreateGift
1 vote -
Support for line break character (/n)
Right now we can add line breaks through Concatenation, but there isnt a simple way to force a line break in some more complex situations.
We use this particularly for notepad text, where we want to summarise a few cells of data into a single notepad, e.g.
'Signed up for Email Newsletter on the website. /n
First Name Provided: Alex /n
Surname Provided: Bishop-Thorpe /n
Email address provided: alex.bishop-thorpe@'Importimatic supported '/n' as a line break character, but this isnt supported by Omatic Cloud. Instead it just renders the text '/n'. If we use the line break as the separator…
2 votes -
Custom Routing to send some rows onto another Formula
Sometimes it's necessary (or more convenient) to achieve our desired outcome by taking one file and running two different Formula across it.
A common example would be files that have a mix of Individual and Organisation records. One Formula for the Individual import, and another formula to do the Organisation import - the Organisation import would add and link the individual as a Contact against that Organisation. Fancy.
Right now custom routing lets us skip some rows, having the Formula ignore them. This let's us have our two import formulas, one for Individuals and one for Organisations.
But it would…
3 votes -
Fuzzy Organization Name Matching
Currently, Omatic Cloud does not support fuzzy name matching for organizations. Organizations can only be matched on name exactly. In this case, if you were to try and import employment data, minor variations in organization name will force you to manually match with existing organizations or you will end up with multiple duplicate organizations within your database. Fuzzy organisation name matching would make this process much simpler and streamlined.
18 votes -
Allow defined type property for the column
The table, when it doesn't explicitly know the data type of a column, defaults to sorting its values as strings. This causes numbers to sort incorrectly (e.g., '10' appears before '2'). For proper numerical or date sorting, the table requires either a defined
typeproperty for the column (e.g.,type: 'number') or a customsortfunction that understands how to compare the specific data type.3 votes -
Allowing the formula to auto match based on a spouse in a record.
Example: The file I'm importing the donor name is Laura Smith but in RE NXT we have a donor of Robert Smith with spouse of Laura Smith. When these come through Omatic Cloud they are 1:1 matches but we still have to look at every single one by opening the RE record to ensure the spouse is on there. Is there a way to make the formula automatically match it if the spouse matches and the address matches?
2 votes -
Add new GoFundMe Pro Channel to connector
GoFundMe Pro has added a new Channel feature for the Peer 2 Peer campaigns. We'd like this added to the GFMP connector for importing transactions.
1 vote -
Add individual system Record ID as a match option when importing a Relationship
Expand the matching logic for Relationships to include the Constituent System record ID . The constituent system record ID is unique across RE and is assigned to a record once added in RE. This data point will allow the import for Relationship records to use an alias/alias type and constituent system record IDs to get an exact match and will prevent duplicate/reciprocal relationships to be added in RENXT. Currently ImportOmatc will match on an Alias ID and will not create additional relationships if it exists.
Currently in OmaticCloud, matching on alias id/type will result in unwanted/duplicate relationships added to RENXT.…
1 vote -
1 vote
-
other name format for tributes
when creating tributes we need an "Other Name Format" to add to the record. This is available for consittuents, but not for tribute records.
3 votes -
US phone number - catch incomplete phone numbers
Add this as built in code in the telephone formatting options so there are built in options to catch "bad" data, in this case incomplete phone numbers
US Phone Number Normalization
Goal: normalize to digits, then detect “short” values and exclude them.Steps on the phone field
Telephone format (or use Replace to strip punctuation)
Normalize the phone first so only digits remain (remove spaces, dashes, parentheses, etc.). If you don’t use Telephone format, add Replace rules to remove “(”, “)”, “-”, “ ”, “+”, “.”, and “x/ext”.
Fixed Length Formatting
Fixed Length: 10
Append Value: choose a unique character,…1 vote
- Don't see your idea?