Skip to content
Web > Panels

HTML

Overview

HTML panels have two main uses: - A simple form builder for creating complex forms & workflows that interact with other parts of the layout - A panel to use custom HTML within a layout

Fields

Autofill

This example will demonstrate how to use the Country field to populate the Country Code, Continent and Population field using the Country table:

First create a HTML Panel and add a 'Text' field attached to the Country Datamodel and choose Name (here the Name column contains Country names) as the display value:

Use the same method to add the other fields of interest (ie. Country Code, Continent, Population). Next, add a button called 'Lookup' with the following script. When this button is clicked the remaining fields will populate based on the chosen Country.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
Table dbTable = layout.getDatamodel("Country").getData().get("Country");
string countryName = countryname.getValue();
Table dbTableInfo = dbTable.query("select Continent, Code, Population from this where Name==\"${countryName}\" limit 1");
string Continent = dbTableInfo.getRow(0).get("Continent");
string Code = dbTableInfo.getRow(0).get("Code");
string Population = dbTableInfo.getRow(0).get("Population");

if (strIs(Continent)) {
  continentname.setValue(Continent);
}
else {
  continentname.setValue("");
}

if (strIs(Code)) {
  countrycode.setValue(Code);
}
else {
  countrycode.setValue("");
}

if (strIs(Population)) {
  population.setValue(Population);
}
else {
  population.setValue("");
}

This scripts uses a function called query to get the values corresponding to the chosen Country. Searching for a Country also gets a dropdown list of the Countries:

Performing a lookup on Belgium shows the other fields are populated:

Filtering Options

For this example, use the Country table and create 3 select fields. The output of the first select field will be used in the WHERE clause to give the filtered selection of data which acts as the input of the second select field:

First create 3 select fields and call them Continent, Region and Country Name. Then create a blender on the Country datamodel called CountryFiltered and insert the following snippet:

1
2
3
4
{
  CREATE TABLE Region AS SELECT Region FROM Country WHERE Continent==continent.getValue();
  CREATE TABLE CountryInRegion AS SELECT Name FROM Country WHERE Region==region.getValue() and Continent==continent.getValue();
}

Here the continent.getValue() and region.getValue() gets the value in the select field named Continent and Region respectively.

Next, set up the three fields as shown below to get the relevant data from the CountryFiltered datamodel:

Finally, to make the select field options update each time a different Continent or Region is selected, reprocess the datamodel. Thus for the Continent and Region select field, add the following AmiScript:

1
layout.getDatamodel("CountryFiltered").reprocess();