Please note: Access to the Custom DB is only available to Premium clients.
Custom DB allows you to prefill your own internal data into your Nest Forms responses.
We have many clients using this feature in many different ways, but to give a sample of usage, consider product catalogues, visiting locations that requires extra associated data, regular site visits, linking inventory with QR codes, recording timesheets with QR codes etc.
To get started, you can import an Excel document into Nest Forms Custom DB. Then choose which columns to show for each form item, when using the Form builder.
We currently support a custom DB containing the following components:
- Text field
- Barcode & qr code
Managing your Custom DB #
You can add/edit/delete rows directly in NestForms. However, you will need to import your first set of data via the excel file to set the initial structure - see Import process below.
You can also use search to filter the results you are looking for.
Import Process #
You can start on the following URL: https://www.nestforms.com/customdb
First you need to import an excel document, we also support a range of file types that can be imported, including xls, xlsx, csv and others.
Then you can choose to import into an existing table if you have any or into a brand new.
The import allows you to do some magic with the fields you have in the document. You can choose a field as a link to your relations, so the group (row) is linked to the members specified in that field (if they are an active relation).
The system checks the field special values before you import the document, so you can correct any issues.
After you import your data, you can continue by editing your form.
Update the Form Builder #
On the form builder, the dropdowns will now have a new checkbox, ‘Custom DB’, which when checked, will show the ‘Custom DB’ dropdown which allows you to select which columns should appear in the form field.
Do not forget to share the form with all members you expect to fill the data. Otherwise they will not be able to fill the form. If you have any members selected within the Custom DB, but not in the form share, warning message will display.
In the App #
In the app, you will have a new menu item on the left ‘Search Custom DB’, which will show you the master groups for each form you are assigned to (owners see all their data). When you choose a group and create a response, the data will be prefilled into it.
The data can also be prefilled using the standard form filling method, so after you open a new response, the dropdown (radio or checkbox) will have the options available and will work the same way as on the Search page.
Modes of usage #
1) Custom DB rows are shared with all relations - all your colleagues (that have the form shared with them) will receive all custom DB rows and they will be able to start a Response based on the Custom DB data.
2) Custom DB rows are specific to the relation - each colleague will receive only rows that are specifically linked to them. If you login to the app with the master account details, you will see all the rows for testing purposes.
Keep Options #
There is a Checkbox we call Keep Options which is available for single answer, multiple answer and dropdown component types linked to your Custom DB.
When the keep option is ticked, it means that when a responder is filling in a response, options listed within the component will be displayed.
The main usage would be when you have a custom DB row, but in some answers you need to select from a specific set of values.
The big advantage to using this is that you can also assign skip logic to these options and hide other questions that are no longer needed. So in this way you can specify which questions are to be selected for the specific custom DB rows.
To use a client scenario: When you have a custom DB containing addresses for client air conditioners that you need to inspect.
You can add a single answer question, for example “Manufacturer” which will contain options that you can select that include “Toshiba” Mastertherm etc. and when you select the address, the manufacturer will then display as prefilled within your Custom DB.
You can also add another Text question like the “Toshiba model”, but using Skip logic to display this question only for Toshiba manufacturers.
So if you pick the location with Toshiba, the “Toshiba manufacturer” questions will appear, but if you pick the location with another manufacturer, the “Toshiba manufacturer” will be hidden.
Updating your Custom DB data #
If you want to update your Custom DB from an Excel file, you can upload as many times as you need (eg update once a day if required). This is possible with few precautions you should observe:
- Keep the same structure of the uploaded file (same amount of columns, same identifying name of the columns in the first row)
- You will need to have one column in the file that contains a Unique ID field (Eg system number, email address, client id etc), you will need to make sure that this is always entered within each row. And you need to set this column as a “Unique Value” in NestForms.
Then when you upload a new file, NestForms will merge the new data with your existing data. In this case only modified items will be synchronised into the apps.
You need to send one user to four different locations. You can create a form, link it to the custom DB and share the form with the user. Then you create four custom DB records that the user should visit and link them to the user.
When this is done, the user will see a new tab in the app menu called Custom DB. And there will appear the four locations the user needs to visit.
Obviously, you can have different places linked for different users in the custom DB, so each user will see only the places they need to visit.
We have clients using this for product catalogues, visiting locations that requires extra associated data, regular site visits, linking inventory with QR codes, recording timesheets with QR codes etc..
You can also see how this works when you login as a guest into the Android app.
Here you can find a simple example to start with:
Import the custom db example file into the Custom DB in your account. And go through the process. Then import the form definition example into your forms. Within the form - you can make edits into the required fields - tick the Custom DB and pick correct item from Dropdown.
You can then share your results with your colleagues and see how it words within the app.
Custom DB support updates via the API - see more on the API help page.
Note: Custom DB is currently not available on the online form fill page.