Looking for information about ProntoForms features and functionality? Visit our Product Documentation Portal.
A data source (usually a CSV file) is used to provide a list of options in dropdown or radiobutton questions in forms. The pre-made forms loaded to new accounts all use at least one data source. This article will show how to update an existing data source to include your custom data.
While this article discusses editing a manual upload data source, other data source types are available that allow you to host your data remotely in the cloud or enterprise service of your choice. Read more about data sources here.
Watch the video below to learn how to customize a data source with your own data.
You may want to check what questions use the data source before updating it.
Navigate to the desired form and enter the Form Diagram tab.
Mouse over the data source in the Data Sources column of the diagram.
Scroll down to "Referencing Questions" in the pop-up window. These are the questions in the form that use the data source.
- Question Label: the label of the question using the data source
- Question Text: the text of the question using the data source
- Display column: the column of the data source that provides the list of options
From the Form Diagram, select the icon of the desired data source.
Mouse over the dropdown beside the data source name and press Download as CSV or Download as Excel.
The file will download. For easy viewing, open the file in Excel or another spreadsheet program.
- If the file doesn't open in a spreadsheet program automatically, click "Show in Folder." Then, right click on the file, select "Open with" and choose the program.
The top row is the header. Leave this row as-is, and add your own data in the rows below it. Save the file.
On the data source page in the web portal, press Upload New Data.
Select Choose File button. Open the file and press Update. Leave other settings as-is.