- What are Unique IDs used for?
- Where do I find Unique IDs?
- How do I Customize Unique IDs?
Unique IDs are a way to identify specific things in a form, and use them in anything further along in your business process, from analytics to documents to destinations.
This article will discuss what Unique IDs are used for, where to find them, and how to set them up.
Unique IDs are a central part of the internal structure of your form: when you create a Conditional Logic rule , the form uses the page, section, or questions' unique IDs to structure that rule; when you create an Analytics project, you use questions' unique IDs to send the answers to the analytics system (this is why changing the unique ID can break analytics projects, data destinations, and other 'downstream' parts of the form workflow).
Unique IDs are also the main way you control what answers are included in destinations and documents: use Data Record Expression Language (DREL) to refer to:
- the answer(s) to a particular question
- a question's text
- the answer to an Additional Comment on a question
- the metadata associated with a question
- information inside a repeatable section
To help put the use of Unique IDs into context, this section will offer some common examples.
Custom Excel Document
The Custom Excel document allows you to map Unique IDs into an Excel spreadsheet. When a form submission is made, it will generate an Excel file with your desired formatting and send it to the people and places configured with data destinations.
To do this, it uses Data Record Expression inside the spreadsheet template:
Please read our documentation on the Custom Excel Document for more information on how unique IDs are used.
Custom Filter Rules for Data Destinations
Using DREL inside a Custom Filter for a Data Destination allows you to route a form submission to different destinations based on the answers inside the form. For example, if an inspection is marked as failed, it might go to a different destination than the same inspection form marked as passed.
This is done by pulling the answer to the Pass/Fail question via DREL and the Unique ID, and putting it in the Data Destination's rules configuration.
For more information on custom filter rules, please read: Applying Filtering to Data Destinations
Sorting Form Submissions into Folders
When using data destinations that send data to cloud services, form submissions are automatically sorted into folders. You can customize how forms are sorted and named using unique IDs, making it easy to organize and retrieve data.
For example, you can use the unique ID to the Customer Name question to set up customer-specific folders:
For more information on using unique IDs to create file paths for your form submissions, please read: How-To: Change how form submissions are named and organized in cloud services.
Analytics Project Reports
ProntoForms analytics uses unique IDs to collect and display data based on one or multiple forms, making easy-to-read charts out of the answers provided using those unique IDs.
For example, you might have five different inspection forms that each have a "Total Score" question, and want to create an analytics display based on that question. If your "Total Score" question has the same unique ID in each form, your analytics project can report on all those questions, showing the inspection scores across all the inspection forms.
Standardizing unique IDs across your forms can not only help your form building, but create more opportunities for integrations.
The form builder is the first place you'll encounter Unique IDs, and where you can customize them at need.
You can find the Unique ID for questions at the top of the question display in the Form Builder. The Unique ID is automatically generated based on the question text when you are setting up the question, but can be edited to a custom ID in the Question Information page.
You can find the Unique ID for pages or sections inside the Page/Section Information view, accessible by selecting Edit from the menu next to the page/section name.
One of the easiest places to find your form's unique IDs is the Pages & Questions tab:
The Excel Form Report is an Excel spreadsheet that provides a detailed look at a form's structure, including listing the unique IDs:
Unique IDs are set in the Information screens of the respective pages, sections, and questions. While they are automatically generated based on the section or page name, or question text, they can be customized in the Information screen.
Note: changing a unique ID after setting up references in destinations or documents can cause those references to break. Please set up your unique IDs before setting up destinations, documents, or analytics.
In order to edit the Unique ID on a Page, Question, or Section:
- Navigate to the Information page.
- Select the Unique Identifier... bar.
- Type your new Unique ID: