Import an Excel file with customer or product information to use in your forms.
Click here for a preview of a Work Order
1. Excel file
You will need to prepare an Excel file that meets a few requirements in order to have the file imported to the Platform. The Excel file has to have:
- An .xslx extension
- An id column with unique numbers or letters
- A header for each column
2. Data source
Once your Excel file is ready you can log into the MoreApp Platform. Go to the Data Sources tab and click on Add a data source. You have the option to import from three formats; Excel, URL, or Google Spreadsheet. Today we will explain to you how to import an Excel file. You can give the data source a name so that it would be easier to find, after clicking on Excel you will be able to Choose the file. Now that you have your file click on Save. Now MoreApp starts importing your file. You will see that all the information appears in the overview. In this overview, you can delete the data source, upload a new file, and select and position the data to your preference.
Adding a data source always goes together with adding a Search-widget. Start by selecting your form by the Forms tab and click on Edit form. Add the Search-widget to your form, click on the widget's pencil to give it a name. By Data source select the excel file you just imported and choose which fields you would like to be visible in the app. All the columns of the data source will be visible in the PDF.
You have now successfully imported data from an Excel file! The information will be stored locally on your mobile device and also works offline.
Do you wan to be the first to see our latest tutorials? Go to YouTube and hit the Subscribe button!