MoreApp's flexibility and the easy to use Form Builder makes your life easier every day. Now you can import data from Google Sheets directly into your inspection form!
1. Google Sheets
In order to have your data imported into your inspection form, you will need to have a Google Spreadsheet. You can create one or use an existing spreadsheet. Pay attention, you will need to name the first column id in lower case letters, then you can add as many columns as you like once you also add a name to each column. Once you have your sheet, you can go to the MoreApp Platform and make a form.
2. Add a data source
Once you have logged into the Platform, you can go to the Data Sources tab to add the spreadsheet. By clicking on Add a data source, you can give the source a name. Under Type, click on Google Spreadsheet. Before adding the Google Spreadsheet you will need to authenticate your Google account. Once it's authenticated, you can add the Google Spreadsheet ID. The spreadsheet ID can be found in the URL of your Google spreadsheet as shown below. You can also change the interval of the updates from every 15 minutes to weekly. Click on Save once you have filled in the fields.
3. Import your data
After you have added the data source, you will need to import the data by clicking on Schedule Import at the Data Source tab. Now add it to your preferred form, by selecting the form and clicking on Edit Form. Now you can add the Search-widget to your form so that the user can be able to search through the data. Edit the Search-widget by clicking on the pencil. You can name the widget under Label. Select the data source you just created. Once you selected the data source, click Save and then lastly click on Save & Publish.
You have successfully imported data from a Google Spreadsheet to your form. Now your users can search for and use the imported data in their forms, even offline!
Do you want to be the first one to see our latest tutorials, go to our YouTube Channel and hit the Subscribe button!