- App Settings
These are the currently supported Field types that can be applied to cells.
but not displayed in the input form.
"Click Here | http://www.google.com"
The data will be stored as a string “100-200” where 100 is the left button and 200 is the right Button. Ex: 0|1000|50|250
Ex:im1.image You can upload images for an app using the upload images button in the cell mapping screen. Once the image are uploaded the cells with cell type image will use the cell value to display images. so if the cell value is abc.jpg then the image will be displayed there.
You can also make an Image Clickable by passing the URL after a Pipe Symbol. Ex:
This will link to another app in XLApp.
This will link to http://www.google.co.in.
Ex:im1.imagebreak Normally the images and content are displayed in a table layout if you specify imagebreak then the image is displayed independently. This is useful for displaying header and footer images.
Ex:im1.imagepopup if the cell type is imagepopup then the thumbnail of the uploaded image is displayed in the form. When the user clicks on the thumbnail the full image is displayed in a popup. The Value in the Cell Next to imagepopup Cell will be used as the title for the Image.
Ex:im1.imageslide if the cell type is imageslide then the thumbnail of the uploaded image is displayed in the form. When the user clicks on the thumbnail the full image is displayed in a popup with all the other images in the page as a slide show. The cell value has to have the cell name.
The caption in the image can be set by providing it after the | symbol.
product1.jpg| This is a Two ton AC running at 220v AC.
In value of tb1.tablestart if “colsel” is specified then column selector displays In value of tb1.tablestart if “filter” is specified then column filter will come up you can give the value as “colsel,filter” if you want both.
To make a region of cells into sections it can be selected and the type set to xlapp.sectionarea.1.
The first cell in the section area decides how the section shows up. The valid values for the first cell are Expand Collapse Show Hide. The next cell can have the Section Caption. The cells in the subsequent rows are grouped into this section.
You can have multiple regions named as xlapp.sectionarea.2 , xlapp.sectionarea.3 etc.
Regions of the forms can be grouped into sections by naming the cells with cell xlapp.sectionstart and xlapp.sectionend types.
The cell value of cell named with sectionstart* type can have “expand collapse hide show”. These will decide how the sections show up. The cell value can be an expression also so depending on another cell you can decide to show hide display or collapse a section. The cell adjacent to the sectionstart** cell will be used as the caption for the section.
Name the Cells as
xlapp.sectionstart.1 Fields .... .... xlapp.sectionend.1 xlapp.sectionstart.2 Fields .... .... xlapp.sectionend.2
If the value of the cell is show then the section is displayed. If the value of the cell is hide then the section is hidden.
If the value of the cell is expand then the section is expanded. If the value of the cell is collapse then the section is collapsed.
Multiple sections can be grouped into section groups. When one section in a Section group is expanded, other sections will be collapsed. So only one section in a section group can be expanded. This also called accordion widget.
xlapp.sectiongroupstart.1 xlapp.sectionstart.1 Fields .... .... xlapp.sectionend.1 xlapp.sectionstart.2 Fields .... .... xlapp.sectionend.2 xlapp.sectionstart.3 Fields .... .... xlapp.sectionend.3 xlapp.sectiongroupend.1
Tab groups and tabs allow creation of tab based UI. These are similar to section groups, just that instead of being horizontal they are vertical.
xlapp.tabgroupstart.1 xlapp.tabstart.1 Fields .... .... xlapp.tabend.1 xlapp.tabstart.2 Fields .... .... xlapp.tabend.2 xlapp.tabstart.3 Fields .... .... xlapp.tabend.3 xlapp.tabgroupend.1
For Menus you need two columns of data after menustart row. The first is the caption the second is the link for the item. if the link is empty the items shows up as a menu divider.
menu1.menustart Lablel LinkLablel LinkURL LinkLablel LinkURL Lablel LinkLablel LinkURL LinkLablel LinkURL menu1.menuend
Record Selector for Editing Records.
Owner Email for Assigining Editable records to others.
This disables the input and the data in disabled cells are not submitted to the output form.
Searching on Input page. q1.text.search
Add a button with this name to apply filters on the input page.
In certain cases it might be needed to recalculate the input form when the value in a cell changes. The normal way of doing this is to check the “Need Input Refresh” box in the app settings screen. The issue with “Need Input Refresh” is that all the input cells will trigger a recalculation. If you do not want this then, If the special attribute for a cell is set to refresh then a change in that cell will trigger the input form recalculation.
Normally when Refreshing the form the validations are also executed. In some cases you might want to do the validations only when saving (hitting the Go Button). In this case you can set the type to to refreshnovalidate.
The contents in the cells with cell type html will display the cell values directly. This can be used to output special html content. The content will be bound in the cell.
The contents in the cells with cell type htmlbreak will display the cell values directly. This can be used to output special html content. The content will be displayed independently. htmlbreak - will stop and restart the table so data flows are different.
You can Include html files using this tag. The cell value should have the name of the file you want to include ex: mytable.inc . You have to upload the file with extension .inc using the upload images button.
The following are cellnames that can be assigned to cell to retrieve XLApp variables like Current Logged in Username, email etc .
Name Cell as “title1.title” and assign it to the input form.
You can also use general Excel features in XLApp. Some of the features are:
You can set the color of a cell using the following syntax
Positioning These Names can be set for any cell to place system widgets.
xlapp.position.gobutton ⇒ Positions the Go - Submit button.
xlapp.position.recsel ⇒ Positions the Record Selector and RecordFilter. The value determines the Labels in the Selector dropdown. Ex - “Add New Name|Edit Name :”
xlapp.position.inputmenu ⇒ Positions the Input Menu ( On the Home Input page ).