Dataverse Integration
The easiest way to connect Dataverse / Dynamics 365 with WordPress.
Gravity Forms Premium
Use gravity forms to manage your organization data
Introduction
Our plugin supports Gravity Forms. So you can use it instead of our Custom or Power Apps forms
When you have created the form and clicked the Save Form
button, you must also create a Dataverse Feed.
To create a Dataverse Feed, you need to click Settings
-> Dataverse
without closing your Gravity form.
Then click Add New
, select crm table, action type(create or update) and map form columns to crm columns(set a correspondence between the column name from crm (key) and the column name from the gravity form(value)).
Dynamic column population
If you want to set default values for columns you can follow these instructions:
- To set default value for standard columns go to
Field settings
tab -Advanced
. - To add lookup column you should go to
Add Fields
tab and chooseDataverse Lookup
fromAdvanced Fields
tab. Then you need to open theAppearance
tab and set default value.
If you want to set default values dynamically for columns using the form’s field_values attribute (see Dynamically Populating a Field, you can follow the following instructions.
- Add a new field, go to
Advanced Settings
and check theAllow field to be populated dynamically
checkbox. - Specify a parameter name just below the
Allow field to be populated dynamically
checkbox and save the parameter name. - Map the field to one of the Dataverse columns in the
Dataverse Feed
settings. - Remember your Gravity Form id.
- Go to
Pages
->Add New
and chooseCustom HTML
block
Example for setting dynamic value:
gravityforms id="1" field_values="parameter_name=Dynamic Value"
Note: The parameter name in the field_values
attribute must be the same as specified in the 2nd
point.
Note: When populate a lookup parameter, use the following syntax: parameter_name=entity_name
:record_id
.
Example for companyid
parameter name (actual column name is parentcustomerid
in the contact
Dataverse table):
-
Fixed value:
field_values="companyid=account:f5aaed4c-654c-4730-bd4f-38bc19a330bd"
-
Using twig expressions to get dynamic value:
field_values="companyid=account:{{account.accountid}}"
Lookup Fields
Lookup column supports two views for displaying the column: dropdown and dialog.
To select a view, you need to click the Add Fields
tab and choose Dataverse Lookup
from Advanced Fields
. Then open the Appearance
tab in the column settings.
If you select the dropdown, you must also select the table and view to lookup. The dialog view does not require any additional settings.
If you want to set a default value for Dataverse Lookup look at this example:
table:98837486-742e-ed22-9db1-00224893bd2f
File upload columns
You can set maximum attached file size for File upload column in Gravity Forms. But you should also remember about the file size limits which are set for such columns in crm. So that your maximum attached file should not be more than the size from the crm column settings.
At current moment we don’t support uploading multiple files.
Access to a table
Be attentive with the access to tables from Maker portal. Pages, based on Gravity forms do not show any error when you try to fill in and submit the form even if you don’t have an access to this table. You click Submit and then you will see success message even when you don’t have privilege to create a new record. In that case the administrator will get an email with the details.