Omatic Cloud
92 results found
-
Allow same source and destination
OmaticCloud would be more valuable to us if it would allow same data source and destination. For example, data stored in RE membership could be transformed or simply moved to constituent attributes area by an OmaticCloud job when membership data is changed. This will help workaround missing functionality from RE and Omatic to improve our data efficiency and accuracy. Thank you!
8 votesThis is now supported! You will need to connect RENXT as a Data Source twice (once for the "Source" and once for the "Destination"). Once the two data sources are created, you will have the option to select one as source and one as a destination in the wizard. Then, you will have formula types available for those connections.
-
Support "starts with" or "ends with" in Transformations
When translating data we need more supported options for translating data, for example, "starts with" or "ends with" at minimum.
7 votes -
Keep 'Remove batch if validation fails during processing checkbox' checked
After checking the box to "Remove batch if validation fails during processing checkbox" it would be nice if that remained check for each subsequent posting job.
3 votesWith the release on 12/5/2024, the 'Remove batch if validation fails during processing' checkbox will remember the last status chosen when processing a formula so that a user doesn't have to manually update the checkbox each time a formula is processed.
-
New Formula Types
If I create a second API Connection to my RE/NXT database (called RE Maintenance), I’m hoping to use the primary connection to identify specific maintenance scenarios and the second connection to update the data in RE. (Ie, we have a custom field called Minor (under 18) with a Y/N value. I’d like a formula to automagically change it once they reach their 18th birthday.) I currently do this on a monthly basis for many different maintenance scenarios using RE Database View queries and global changes. Automating would be better, more efficient, and more timely.
OC will allow me to create…
5 votesThis is now supported! You will need to connect RENXT as a Data Source twice (once for the "Source" and once for the "Destination"). Once the two data sources are created, you will have the option to select one as source and one as a destination in the wizard. Then, you will have formula types available for those connections.
-
Ability to silence or "x" out toast notifications in Omatic Cloud
Toast notifications can be distracting especially when multiple users are in an Omatic Cloud instance. The notification blocks the "X" button on the formula and prevents another user from closing a formula. When those notifications stack or another user is processing records, it can be a long wait.
It would be helpful to silence those notifications per user and have the ability to close out of the notification before the processing bar is completed.
12 votesAdditional toast notification feedback can be submitted within the referenced link
-
Offering the ability to pull all list types from NXT, not just a Constituent list. (Gifts, Actions, Opportunities)
I need the ability to sync constituents between NXT and Luminate who have given to a particular Package. This is only searchable in NXT through a Gift List.
3 votesThis is now supported, with RENXT Query as a Source. You can create a query in RENXT, and use it as the source of the data to send to Luminate.
-
Include Uploaded file name in PostToGL FE NXT Batch Description
To help identify the contents of a FE NXT Journal Entry, it would be helpful if the Journal Description could include the file name of the uploaded file.
4 votesThere is now a field available named Uploaded File Name that you can use to map in any area where mapping is supported in a formula.
-
OC Date transformation for D/M/YYYY
Currently there is a transformation for M/D/YYYY but not D/M/YYYY
Seeing a lot of "data differences" simply because of OC adding back in a zero when we do not want one.6 votes -
GiveCampus: Adding "Donor Covered Fees" as a field
Donor Covered Fees is a field available in GiveCampus, but not yet available to map in either IOM or OC. Organizations would like this available to track in RE/RENXT.
1 vote -
Floating Column Headers in Buckets
When scrolling down a bucket, the headers do not follow and it's difficult to remember which field is associated with which header.
0 votes -
Add ability to include archived/unpublished donation forms
Add the ability to include archived/unpublished forms to the donation form selection in the "Additional Settings (Source)" step. Currently we cannot unpublish or archive any donation form with a recurring gift option in Luminate (which for us is most pages) because Omatic cloud will not pull those transactions once the page is unpublished/archived. This causes unnecessary page clutter in Luminate.
2 votes -
GiveCampus: Adding Time Zone Selector
All gifts from GiveCampus are currently coming over with UTC timestamps, making the gift dates inaccurate on some gifts. We need the ability to specify the time zone the gift dates should be in
1 voteThe date/time transform in Omatic Cloud is able to handle the source time format so this suggestion will be closed. A separate User Voice ticket may need to be opened for Classic products (IOM).
-
SFTP to HubSpot
Please add SFTP Capabilities for ingesting files from a SFTP to HubSpot. Right now we can ingest Flat Files into HubSpot, but there is no formula that will support a SFTP connection to HS
1 vote -
Update fields only if new record
When a formula imports data for new and existing contacts, there may be fields that should only be populated for new records.
For example, we have source campaign, source, and sub-source to record where a record initially came from. This should only be updated on new records.
Having a 'only if new' option in the mapping would be really useful. I.e. when selected, the incoming data is ignored when updating existing records, and populated when creating new records.
3 votes- With the July 2, 2024 release, we added new options for child object matching to add, update, or ignore incoming values depending on whether the child object is matched
-
Add Salesforce Production to Salesforce Production option to Formula Setup
Would like the ability to create a report in Salesforce Production and have omatic pull that report and make the updates noted in the formula in Salesforce production at a scheduled time. At this time, I can only schedule automatic updates from Salesforce Production to Salesforce Sandbox, which is useless when trying to keep the data clean in the live database
2 votes -
Field Campaign Internal Name Visibility
Ability to view the Internal Campaign name in hosting when attempting to map Classy Recurring gifts,
6 votes -
1 vote
This work as been completed and the ability to export the entire "bucket" is now available in production!
-
Add optional questions to fundraisers formula type (classy defined and user defined) to OC
IOM has Option Questions available to map, but they are missing from OC. Please add these to allow more formula usage.
7 votes -
ability to use 'if / then / else' logic for mapping fields
My file has some rows with gift data and some rows without gift data. In order to import the gift data, we have to map required fields (ex: gift type). But the rows without gifts are creating exceptions because it is still trying to send in the required field but there are no gifts associated with that row.
Need to the ability to map fields conditionally:
if gift data exists, then add them (with the mapped values), else ignoreIn this case (RE NXT), the exception that was generated was not as clear as it could have been: 'the gift_splits…
14 votesWith the recently released updates to Transformations, you can accomplish this use case by stacking different types of transformations together.
For example, to populate Gift Type only if the incoming Gift Amount is not blank you would:
- Map gift amount
- Add a "Replace" transformation to transform: "If not Blank" to "True", and "If Blank" to "False" (in that respective order)
- Add a "Concatenation" transformation and add Gift Type
- Add a "Replace" transformation to transform "If contains False" to "Blank"
- Add a remove custom text for "True"
This will ensure that the Gift Type field coming in is only populated if the Gift Amount is populated.
Depending on your incoming data, there are many variations and approaches you could take to setting up this transformation logic. We will continue to look into adding new Transformation Types in the future to improve efficiency and capabilities.
You can find more information about transformations…
-
Add reason code to BBCRM Constituent Email
BBCRM Constituent Email Address section has an option to set the "Do Not Email" flag. However, our Bio records team would like us to include a reason code inorder to identify who (in this case from where) set the flag.
Would it possible to add reason code as an option?
We are currently integrating with Emma.
1 voteHi Michael - We released this last sprint. You should now see the Reason Code on the email object and be able to map this field.
- Don't see your idea?