The basics
In order to configure your website, your need only to add a new worksheet to your Excel file.
The worksheet must have the name EG2 (in other words : EG in capital letters, and then the number 2).
Inside this worksheet your have to fill columns A and B.
- Column A - is required and will contain the type of the component.
- Column B + C - will contain list of properties which describes how this component will behave in the Eg2 website.
In column A your write each component you want to appear inside the website. For example, if you want that the table called “Sales” will apear inside the page, so write “TABLE” in column A. And then in column B write the table name: “Sales”.
It should be like this:
The Eg2 way is very simple, and based on 2 principals :
- Column A holds the component.
- Columns B+C holds the properties of the component, e.g. name, colors, alignment, filter or sort options etc.etc.
If you understand this, there is nothing more you need to know.
You just need to write your desired configuraion in these 3 columns, and upload the file to your Eg2 account.
Here are the full list of Eg2 options.
Full list of Eg2 options
| Component | Properties |
|---|---|
| PAGE Enable to create a page in your website. All the next rows - will be included inside this page, until the next PAGE word will apear in column A. | |
| BROWSER_TAB_TITLE - The title that will appear in the browser tab. | |
| PATH - The path that will hold your page. For example: “abc” means that this page address (e.g. url) will be “yourSite.com/abc This path MUST be unique (e.g. you can’t use this path again in this website). | |
| HEADER Enable to create an header | |
| CONTENT -Required The actual header. For example: Welcome to my website. | |
| TEXT Enable to create a paragraph with text. | |
| CONTENT - Required The actual paragraph. | |
| LINK - Optional. In case you want this text to be a link, set here the URL (e.g. the internet address of your target webpage). | |
| TABLE Enable to show a table in the website. | |
| NAME - Required. The name of the table. | |
| COLUMNS - Optional. The names of columns to show, seprated by | symbol. If this propery is not exists - all the columns will appear. | |
| OPTIONS - Optional. By default, each table have all the options, meaning: Read (e.g. see the data), add new rows, delete rows and edit rows. If you add this DISABLE, you can limit these options.There are 3 available options you can limit: DELETE,EDIT,ADD.The options need to be seperated by | symbol. | |
| SEARCH - Optional. Enable you to turn on or off the option to search in the table. By default, each table include a search box, which enable users to search, if you set this option to OFF so Eg2 will hide this search box. | |
| FORM - Optional. If you will set this option to ON so Eg2 will show a form, which enable user to add new rows to your table (but not to read /delete or edit ).This setting overrides the OPTIONS settings. | |
| ORDERABLE Optional. By default all the columns have sorting buttons on the header row. If you want to limit this capability only to certain columns, write these columns in this settings. The columns names need to be seperated by | symbol. | |
| CHART Enable to show a chart in the website. | |
| WORKSHEET - Required. The name of the worksheet | |
| NAME - Required. The name of the chart (When you select the chart, the chart name appears to the left of the formula bar). | |
| PIVOT Enable to show a pivot table in the website. | |
| NAME - the name of the pivot. | |
| IMAGE Enable to create a paragraph with text. | |
| URL - The address of the image in the internet. For example: https://eg2.app/img/quick.png. | |
| CELL Enable to create a paragraph with text. | |
| ADDRESS - Required. The address of the cell | |
| MODE - Required. The mode of this cell. You need to specify one of these options: FIELD - this cell will show as field.READONLY - This cell will show as text, without enabling the user to change values. | |
| HTML Enable to create an HTML section. | |
| CONTENT - The HTML code. For example: <span>abc</span>. | |
| GLOBAL_SETTINGS Enable to set global settings which affect the whole website. | |
| ALLOW_REGISTRATION - TRUE / FALSE. When set to TRUE, users will be able to register, and a “Create Account” link will appear at the bottom of the login page. If set to FALSE, the registration page will be disabled, and the login page will not display a sign-up link. Default value: FALSE |
