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
  • Watch the instruction video
  • Instruction - steps
  1. Quick start

Excel Add-in

Use the Any2info Excel Add-in for quick data transfer.

PreviousBuild your first app - Simple form (PDF)NextExcel add-in functions

Last updated 2 months ago

Watch the instruction video

Instruction - steps

Open the app store page ().

Select Add-Ins in the left menu bar.

Download the latest Excel Add-in from the App store (fitting the software version of the App Studio).

Ignore default warnings. Preserve the file and run anyway.

Complete the install wizard.

Note: If you have already installed an An2info Excel Add-in please delete this version before installing the latest one.

After installing the Excel Add-in open a new Excel Worksheet.

In the toolbar a tab Any2info will appear. Select this tab.

Select Settings and create a connection to the Any2info platform entering the URL below and your credentials (username and password). Sign in and select your app collection.

Create an Excel Table (Look for more Excel Add-in functions here).

Create an new table, name the table and add data into columns (headers). Always add one unique column ID.

Place the mouse in the table and push the button Create in the toolbar on the top left.

Follow the steps in the wizard.

Choose an unique header field.

Enter an unique data clip name and complete the wizard.

Push the button Send data in the toolbar on the top left.

Open the App Studio - Menu part Data - Data clips and select Live View.

The Excel table data = dataclip are now available for use in dashboards (for example a grid) of forms (for example a lists).

https://portal.any2info.com
5MB
Excel Add in - Install - Excel Table - Dataclip.mp4