Receive the data, per submission, in Excel format! Configure an email with an Excel file that you’ll receive after sending a submission.


No MoreApp account yet? Sign up here.

This feature is available in the Branch, Tree and Forest plan. Visit our Pricing page. 


1. Create the Excel template

Open Excel and design the template that will show your data. Use placeholders in your Excel template in order to know where the form entries need to be placed. You will know which are the correct placeholders to use by checking the data names of the widgets.


Note: Data names of the widgets can be found when activating the advanced mode of the widget's properties panel.


When creating the Excel template, most of the widgets need to be configured using the placeholder {dataname}. For example, a Text-widget named ‘Company’ will have the placeholder {company} in the template.


However, some other widgets use a different placeholder: {%dataname} 

This placeholder can be used for the Photo- and Signature-widgets.


Check the following image as an example of how the placeholders will look in your template.



Notes: 

  • You can add data in multiple tabs if needed.

  • Video-, Catalogue-, Zip Code NL- and Pin-widgets won't be visible in the export. 

  • You can also add formulas to your Excel sheet if you need to do calculations with the results of your forms.


1.1 Subform-widget 

A Subform-widget has to be opened with a # and closed in the Excel template with a / as shown in the example below.



It is also possible to have a subform inside a subform. To configure this in your Excel template you will need to open and close both of them as shown in the example below.


{#subform}

{widget}, {widget}

{#subform1}

{%photo}

{/subform1}

{/subform}


Take the example, change the word ‘subform’ to the data name from your Subform-widget. Do the same for the widgets inside the subform.



1.2 Checkbox-widget 

If you are using a Checkbox-widget in the form, this is the format you need to use in the Excel template:


{#dataname}Correct{/dataname}{^dataname}Incorrect{/dataname}


Add the full code in one cell. Depending on the answer of the widget, the result will vary. 


You can also use icons instead of words (like ❌ or ✅).


2. Configure the integration

Now that you have successfully created your template, go to the MoreApp Platform, select a form and click on Edit Form. Access the Integrations tab and click on Add Integration. Select the Excel integration and click on Add.


Note: This integration will trigger an external system on each submission. You will receive an Excel file every time a form is sent.


You can now start configuring the Excel integration.


First of all, you will need to upload an Excel template. Click on Select file and choose the template you have just created. 

  • Check the box: Use legacy delimiters if you use a placeholder with a dollar sign ($) in the subject, body, filename and the Excel template. 

  • In the Excel file name field, write the name of the export file that will be attached to your email.

  • In the Recipients field, type in the email address of the person who will receive the file. Use a comma to separate the emails if there is more than one.

  • In the Dynamic recipient field, you will have the possibility to send the file to a different person each time. This option uses the Email-widget in your form, as a recipient. 

  • Select Copy to user if you want to send a copy of the Excel to the user who filled in the form.



Note: If your email is bigger than 19 MB, your Excel file and images will be added to the body of the email via a download link. The download link is valid for 7 days.

You can also select the quality of the images you will receive. The section Image Quality is set to Original, by default, but you can select the option you prefer: Original, High, Medium or Low. 



To finish the configuration, type a Subject line and Body for the email. You can also use placeholders.  


Note: Some widgets are not supported in the email body of the Excel integration. Here is the list of widgets you can not use as placeholders: Subform, Photo, Signature, Pin, Location, File, Catalogue, Header, HTML, Label, Image and Help-widgets.


Click on Validate. 




Note: If an error occurs after validating or your template is not working well, this means that there are wrong placeholders used in the Excel file. 


Once you are finished editing the form, click on Save & Publish. 


3. Download the Report

It is possible to download the Excel report on the Submissions tab, by clicking on the green checkmark of each submission. A new section appears and you need to click on Download report.


4. Congratulations!

You will receive an Excel file with your form's data after a new submission is submitted.


Here is an example of the Excel file:



Tip: If you don't want to receive two emails, you can remove the email that MoreApp generates, under the Email tab, by clicking on the trash icon.


Note: You can use this Excel template to see what the report would look like with the Excel integration.

To test the Excel template that can be found below, you can select the predefined "Work Order” template in the Platform.


Keep in mind that this is just an example. Get in touch if you want a customised report and request a quotation. 


Want to stay up to date with our latest tutorials? Go to YouTube and hit the Subscribe button!