Using the Table function
Often your table of data will come from a data source so you need to create a table manually. This might be to populate a Dropdown control or to define information to be used in a Gallery or Data table control. To create a table, there's the Table function.
The Table function allows you to create a table of data that only exists in the context, which it's used within your app. For example, to recreate the table shown in the previous section you can use the Table function in the Items property of a Data table. The formula would be as follows.
Table({Name: "Chocolate", Price: "$ 3.95", 'Quantity on Hand':
12, 'Quantity on Order': 10}, {Name: "Bread", Price: "$ 4.95",
'Quantity on Hand': 34, 'Quantity on Order': 0}, {Name: "Water",
Price: "$ 1.95", 'Quantity on Hand': 10, 'Quantity on Order':
10})
To see the items appear in the Table, be sure to update the Fields in the Properties panel (refer to the image above for location).
Sometimes you need a simpler, single column Table for populating a Dropdown control choices. In that instance you can use the short cut method of [ ] to create a single column table. An example of creating a single column table with the colors Red, Blue, and Green is shown below.
["Red", "Blue", "Green"]
By placing that formula in the Items property of a Dropdown control, you'll have a simple dropdown with the three colors as options.
