Product: Omatic Cloud
Have you ever wanted to send data to different fields than your formulas allow? For example, maybe you have a question on your donation forms about volunteer interests, but you can't map to your volunteer-related objects and fields in the preconfigured gift formulas. Now you can!
Omatic Cloud now has the ability to send to "Any Object" in some integrations, like sending Flat Files to Salesforce. We plan to continue expanding this functionality to other integrations, so make sure to follow the Omatic Cloud Updates forum to keep up with the latest changes. As more integrations offer this feature, we will update this solution to include important information about each.
Using the Object Picker with Salesforce:
Tip: Given the flexibility of this formula type, including the ability to use custom objects, we strongly recommend testing with a small data file, and using your Salesforce sandbox first. This will ensure that you can thoroughly review the records that are created, updated, and related to each other before impacting your production org.
- Start by creating a File Upload formula with your sandbox org from the Integrations/Formulas page
- Select the Import Contacts and Any Object formula type
- On the Data Mapping screen, you will see the Contact object and some of its fields displayed by default.
- Click Add/remove objects to open the Object Picker:
- The Object Picker will display all objects that relate to your Contacts (since we use the Contact for matching, we always start there):
- When you expand an object node, all of the fields in that object will display for selection. If you select the entire object, all fields will be selected too. You can deselect the object to pick and choose which fields you want to add to the Field Map. If you select an object that has its own child objects, those will be automatically added to the list for you to explore and add. The rest of your objects are still there too, just scroll down or use the search field at the top!
- Once you've picked the objects and fields you want to include, save your selections to return to the Data Mapping screen. If you forgot something, you can return later to add it.
- As you are mapping your objects and fields, pay attention to which objects include their own matching rules, like Opportunities. By default, these are set to "add new," but you can adjust the settings to match existing objects based on any combination of the available fields.
- When you finish your formula, go ahead and use a small data file to test the configuration. Make sure to thoroughly explore how records were matched and updated, including relationships between objects. If anything looks out of place, check to see if adjusting your formula can resolve it. If you are unable to resolve the issue, let us know! We're looking for feedback from users on where we can improve this new, flexible formula type.
Promoting a formula from sandbox to production is not currently supported on this formula type. You will need to manually recreate the formula within your production integration, following the steps above.
- How does Omatic Cloud know what objects are in my Salesforce org, and how does it know how to relate them to each other?
When you create a formula, Omatic Cloud was already reaching out to Salesforce to make sure we had access to all of the fields you may need to use. Similarly, Omatic Cloud can go a step higher to see what objects you may need to use and how they relate to each other. This data about how you store data is called "metadata." We store metadata in the background, in your Object Relationship database. By storing this info, you can quickly make edits to formulas without waiting on metadata to load.
- When I click on Add/remove objects, nothing happens. I'm unable to open the Object Picker.
If the Object Picker doesn't open, create a case with Omatic Support. We will refresh your Object Relationship database in the background, which will resolve this issue quickly. In the near future, you will be able to update your Object Relationship database without contacting Support.
- I added new objects or fields, but they are not showing in the Object Picker yet.
If the Object Picker doesn't display your new objects/fields, create a case with Omatic Support. We will refresh your Object Relationship database in the background, which will resolve this issue quickly. In the near future, you will be able to update your Object Relationship database without contacting Support.
- Some of my Salesforce objects and fields are missing from the Object Picker, but they are not new.
Currently, the Object Picker will only display objects that relate to Contacts, since we use Contacts for matching. For example, we do not display the General Accounting Unit object (meaning you cannot add a new GAU via this type of formula), but we do display the GAU Allocation object since it rolls up to the Contact via Opportunities.
Additionally, we only display objects with editable fields to prevent confusion. In the future, we will be expanding this feature to include Account-related objects and more. We're welcoming feedback for improvements, so make sure to add your thoughts to the Omatic Cloud Ideas forum!