Omatic Cloud
371 results found
-
katrina.molnar@mercy.net
Currently when using the Classy Connector in O-Matic Cloud and building/updating a formula, you are unable to add a new "Campaign Type" when "Editing Classy Settings" in a profile without all of the previously selected campaigns disappearing. This forces the user to have to reselect all of the campaigns wanted in the profile. My organization 171 active campaigns. It would be great if users could select a new Campaign Type without all of their previous selections disappearing in the formula build.
3 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…
6 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 -
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 -
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 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 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 -
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 -
option to not overwrite receipt type
we have to map to receipt type as this is a required field when creating constituent records. But this means the receipt type is constantly being overwritten, which we don't want. Can we have options, similar to what is available for email/phone number, where we can choose to not overwrite it if a match is found
3 votes -
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 Suffix as a field for matching.
We bring in many alumni or students who have parents who match on first, last, address, etc. and we would like to use Suffix as a matching or autopick field.
0 votes -
Ability to copy detail rows
Need the ability to copy detail rows in as well as pre-processing rows. Very often, most configurations in multiple rows are the same, with the exception of only a few things (or sometimes just one thing) that needs to be changed. The ability to copy a detail row or a pre-processing row, and then change one or two configuration items, would save a great amount of time in configuring complex formulas.
2 votes -
test connection
Particularly while I am setting up or testing a new connection I find myself going in to edit the formula often. Each time I go in I have to wait for the connection to be tested. I think it would save a good bit of time if the connection testing was separated out so that you could make changes a little at a time. If you have just setup a connection and its tested, that's not likely to change within the first day of being setup.
1 vote
- Don't see your idea?