Any2info Academy
  • Home
  • All-in-one software
  • Infra
  • Free trial
    • Empty canvas
    • Base template
  • Quick start
    • Free trial - start with data - build your first app (video)
    • Build your first app - Simple form (PDF)
    • Excel Add-in
      • Excel add-in functions
  • App template store
    • Create app template
    • Download app template
  • Change logs
  • Change logs version 3.7 - 3.11.1
  • No-code Platform
    • Introduction
    • Start
    • Platform
      • Licenses
      • Settings
        • Microsoft Azure
        • Google
        • Apple
      • SMTP
      • Profile
    • Management
      • Users
      • Usergroups
      • Authorisation forms
      • Variables
    • App Studio
      • Designer tools
        • Canvas
        • Toolbars
        • Left sidebar
        • Right sidebar
        • Footer bar
        • Stylesheets
        • Merge documents
        • Icons
      • Application design
        • Basics
          • App specifics
          • Layout and menu
          • Privacy
          • Dashboard defaults
          • Form defaults
          • Overview defaults
        • Dashboards
          • Pages
          • Layouts
          • Toolbox - controls
          • Properties - controls
          • Events - actions
          • Footer - tools
          • Specifics
            • Filter control
            • GPS
        • Forms
          • Pages
          • Layouts
          • Toolbox - fields
          • Properties - fields
          • Events - actions
          • Messaging
          • Overviews
          • Footer - tools
          • Specifics
            • Filter field
            • Scan
            • GPS
        • Navigation flows
        • Master forms
      • Logic - automation
        • Dashboards
          • Events - actions
          • Links
          • Parameters
          • Calculations
        • Forms
          • Rules - action flows
          • Events
          • Actions
          • Action flow
          • Events - actions
            • Form life cycle
          • Links
          • Parameters
          • Calculations & formulas
      • Navigation
        • Main menu left sidebar
        • Form overview header
        • Form page header
        • Events - actions (fields)
        • Events - actions (controls)
        • Supporting panels (webapp)
      • Data
        • Data sets
        • Mapping data to controls
        • Mapping data to fields
    • Data Studio
      • Data hub
      • Connections
        • AFAS Connector
      • Toolbox
      • Data flows
        • Case example 1
        • Case example 2
        • Dataflow output
      • Form data hub events
      • Resultset and dataclip
      • Reports
      • Dataclips
      • Devices
    • Tools
      • Import and export
      • Translation
      • Notifications
      • Database tags
      • Form web links
      • Document services
    • Artificial Intelligence - Supporting tools
      • Create forms with AI (text or image)
      • Extract data from text
      • Extract data from an image
      • Analyze image
      • Analyze audio
      • Task
      • File search
        • Create a File search Assistant in OpenAI
        • Configure file search in Any2info
      • Extract subforms from a source
      • Prompts
  • Apps
    • Custom design
    • Apps (browsers and native)
      • Specifics
        • Impersonation
    • Download the Any2info app
  • Integrations
    • ERP
    • Planning
    • Artificial Intelligence
  • Tutorials
    • Video instructions
  • Tips and tricks
    • Database tips
  • Policies and guidelines
    • Terms and Conditions
    • Software & Service Agreement
    • Disclaimer
    • AI Disclaimer
Powered by GitBook
On this page
  • Footer function
  • General
  • Mapping types
  1. No-code Platform
  2. App Studio
  3. Data

Mapping data to controls

Bind data to dashboard controls in the application.

PreviousData setsNextMapping data to fields

Last updated 1 year ago

Footer function

Mapping data to controls is available in the supporting footer below the canvas. If a control has the ability to bind data, the mapping option becomes visible in the footer bar.

General

In general the best way to approach data mapping is to refer to the dataclip as a table structure consisting of rows and columns.

To determine a single value from this structure a column (header) and row (occurence) is needed.

When multiple values from multiple rows are needed system will need to know which columns and rows are needed.

Mapping types

A general note here regarding mappings:

  • By default all rows in a data set are targetted.

  • Filtering to these rows are commonly applied by configuring these as links or filters.

  • Use the option "swap mappings" if you want to change rows to headers (and vice versa).

The software supports the following types of mappings:

Single header mapping:

This mapping requires a single header or column form a dataclip to be mapped to a property.

Examples:

  • A dropdown which should show all unique values under a header.

  • A label that shows a specific value under a header based on a filtered or chosen line from a dataclip.

Multi header mapping:

This mapping requires multiple headers or columns from a dataclip to be mapped to a property.

Examples:

  • A grid that should show multiple colums from a dataclip.

  • A graph that should show lines for multiple data points.

Single dataclip:

This mapping requires a single dataclip to be mapped to a property.

Examples:

  • A dropdown that should show a list of unique values (based on the header that is marked as unique value holder).

  • Rare cases where headers are determined through links and a mapping is needed to trigger data retrieval.

Extended mappings:

This type of mapping is available depending on the chosen control/properties and/or the relationship to other (linked) controls and/or properties. In those cases the option will appear in the mapping Toolbar or can be accessed via "Switch view".