Create a Lookup Table
Go to Content > Lookup Tables and click on Create a lookup table.
- Enter a display name
- Enter a slug with no spaces
The Slug is used to reference this table and may only contain alphanumeric characters. Note that this slug is used in referencing the email template
- Click on Save
Creating an item in a table
Click on the table you've created
From the context menu that pops up, select "View"
Each item in a table is essentially a JSON document. This means you can build up a tree-structure of keys and values, where the values can be text, numbers, booleans, arrays or objects themselves. You can either enter a JSON document directly, using JSON syntax or you can use a UI editor to construct the JSON document.
JSON Editor
- Once you have saved, you will see a JSON editor. You can select either the Text or UI editor based on your preference.
- Update the lookup table using a JSON structure.
Adding an item
To add an item in a JSON for organization, click on +Add Item on the left pane.
- Type a name on the top
- Click on Add Item button
- Once created, you can see the item created on the left pane.
Write the JSON
Use the JSON format to define any object structure and key-value pairs below:
For example, a JSON which gives countryname and local currency based on country abbreviation
代码示例
{
"NL": {
"countryname": "Netherlands",
"local_currency": "EUR"
},
"US": {
"countryname": "United States",
"local_currency": "USD"
}
}
You can also use the UI editor to define the JSON structure.
