The Form data set contains data pertaining to submitted forms associated with Events.
For more information about ACME Forms, see Creating Forms and Viewing Completed Forms.
Tenant | |
TenantGroup | ACME Internal Use |
Form | |
FormDescription | The description of the form |
FormName | The name of the form |
FormResponse | |
FormResponseNumber | A unique number to identify the form response |
FormResponseSubmissionDate | The date that the form was responded to |
FormCustomFields | |
FormCustomField1 | Custom field assigned to the form. |
FormCustomField10 | Custom field assigned to the form. |
FormCustomField11 | Custom field assigned to the form. |
FormCustomField12 | Custom field assigned to the form. |
FormCustomField13 | Custom field assigned to the form. |
FormCustomField14 | Custom field assigned to the form. |
FormCustomField15 | Custom field assigned to the form. |
FormCustomField16 | Custom field assigned to the form. |
FormCustomField17 | Custom field assigned to the form. |
FormCustomField18 | Custom field assigned to the form. |
FormCustomField19 | Custom field assigned to the form. |
FormCustomField2 | Custom field assigned to the form. |
FormCustomField20 | Custom field assigned to the form. |
FormCustomField3 | Custom field assigned to the form. |
FormCustomField4 | Custom field assigned to the form. |
FormCustomField5 | Custom field assigned to the form. |
FormCustomField6 | Custom field assigned to the form. |
FormCustomField7 | Custom field assigned to the form. |
FormCustomField8 | Custom field assigned to the form. |
FormCustomField9 | Custom field assigned to the form. |
Order | |
OrderBillingFirstName | The first name of the person paying for the order that the form was submitted on |
OrderBillingLastName | The last name of the person paying for the order that the form was submitted on |
OrderContactEmail | The email of the contact person at the company that placed the order that the form was submitted on |
OrderContactFirstName | The first name of the contact person at the company that placed the order that the form was submitted on |
OrderContactLastName | The last name of the contact person at the company that placed the order that the form was submitted on |
OrderContactPhoneNumber | The phone number of the contact person at the company that placed the order that the form was submitted on |
OrderNumber | The venue unique order number of the order that the form was submitted on |
OrderTotalAmount | The total amount of the order that the form was submitted on |
Customer | |
CustomerFirstName | The first name of the person that placed the order that the form was submitted on |
CustomerLastName | The last name of the person that placed the order that the form was submitted on |
Organization | |
OrganizationCategory | The category of organization that placed the order that the form was submitted on. |
OrganizationName | The name of organization that placed the order that the form was submitted on. |
Membership | |
AcmeMembershipNumber | The membership number of the customer that placed the order that the form was submitted on |
MembershipExternalId | The external membership id of the customer that submitted the form. If the membership was imported from an external tool then this is the id from that tool |
MembershipLevel | The type of membership that the customer that submitted the form has |
MembershipOrganizationCategory | For org memberships, will contain the category of the organization |
MembershipOrganizationName | For org memberships, will contain the name of the organization |
MembershipPrimaryFirstName | The first name of the member that submitted the form |
MembershipPrimaryLastName | the last name of the member that submitted the form |
Event | |
EventId | Unique ID of the event the form was submitted for |
EventName | The name of the event the form was submitted for |
EventStartTime | The start time of the event the form was submitted for |
EventTemplateName | The template the event was created from |
EventCustomFields | |
EventCustomField1 | Custom field assigned to the event. |
EventCustomField2 | Custom field assigned to the event. |
EventCustomField3 | Custom field assigned to the event. |
EventCustomField4 | Custom field assigned to the event. |
EventCustomField5 | Custom field assigned to the event. |
EventTemplateCustomFields | |
EventTemplateCustomField1 | Custom field assigned to the event template. |
EventTemplateCustomField2 | Custom field assigned to the event template. |
EventTemplateCustomField3 | Custom field assigned to the event template. |
EventTemplateCustomField4 | Custom field assigned to the event template. |
EventTemplateCustomField5 | Custom field assigned to the event template. |
EventResource | |
EventResourceAttributes | Attributes that the resource must satisfy. I.e. must be able to speak Spanish |
EventResourceCapacity | The maximum capacity that this resource can handle |
EventResourceCategoryName | The type of resource, one of Personnel, Facilities, Equipment or Other |
EventResourceEndTime | The time that the resource will no longer be needed |
EventResourceName | The name of the resource |
EventResourceNotes | Notes to the resource |
EventResourceOwnerFirstName | The first name of the resource |
EventResourceOwnerLastName | The last name of the resource |
EventResourceStartTime | The time that the resource will start being needed |
EventResourceTemplateName | The template that the resource belongs to |
FormTransactionItem | |
TransactionAmount | The amount of the item prior to any discounts |
TransactionItemCouponCode | The coupon code for any coupon used on this line item |
TransactionItemCouponName | The name of any line item coupon that was used for this item |
TransactionItemDiscountCode | The discount code of any discount used on this item |
TransactionItemDiscountedAmount | The discounted total amount of this item |
TransactionItemDiscountName | The discounted name of the item |
TransactionItemName | The name of the item, if the item is an event then this will be the name of the event. If the item is an add-on then this will be the name of the add-on |
TransactionItemPricePointName | The ticket type like Adult, Child or Senior |
TransactionItemQuantity | The number of tickets or add-ons of this type included |