Datasource

Metaforms supports a wide range of Data Source Setups in your surveys.

Let's take a look at all of them:

Datasource setup using variable declared in the extraVariables attribute of survey tag. Maps survey variables defined in the extraVariables attribute of the survey tag to datasource fields for data retrieval and pre-population.

Match source from URL with ID in dataset.

• Mapping Process:

  • Survey Variable: source (defined in extraVariables attribute)

  • Dataset Field: ID (unique identifier in external datasource)

  • Functionality: Matches the source value from URL parameters with corresponding ID

• Example Flow:

  • Survey URL contains: `?source=12345`

  • System searches datasource for record where `id=12345`

  • Retrieved data pre-populates designated survey questions

• Auto populate text question from the datasource

  

• Auto populate text question with rows from datasource

• Auto populate number question from datasource

• Auto populate number question with rows from datasource

  

• Auto populate float question from datasource

• Auto populate number question with rows from datasource

• Auto populate radio question with rows from datasource

• Auto populate radio question with columns from datasource

  

• Auto populate radio question with rows and columns from datasource

  

Datasource Setup using variable declared in one of the sample source in survey

Maps sample source variables to datasource fields for data retrieval and pre-population survey questions.

• Mapping Process:

  • Sample Source Variable: userId (from sample source tag)

  • Dataset Field: userId (unique identifier in dat file used for datasource file)

  • Functionality: Matches userId from sample source with corresponding userId in external datasource

• Example Flow:

  • Sample source variable contains: `userId=ABC123`

  • System searches dat file used in the datasource for record where `userId=ABC123`

  • Retrieved data auto-punches designated survey questions

• Auto populate text question from datasource using sample source variable

• Auto populate text question with rows from datasource using samplesource variable

• Auto populate number question from datasource using samplesource variable

• Auto populate number question with rows from datasource using samplesource variable

• Auto populate float question from datasource using samplesource variable

• Auto populate float question with rows from datasource using samplesource variable

• Auto populate radio question with rows from datasource using samplesource variable

• Auto populate radio question with columns from datasource using samplesource variable

• Auto populate radio question with rows and columns from datasource using samplesource variable

• Auto populate checkbox question from datasource using samplesource variable

• Auto populate checkbox question with columns from datasource using samplesource variable