Inline editing is available for:
- number fields
- single line text fields
- choice and score columns (drop-down, radio and multi select, however this does not include user lookup) and
- multi line text
You should switch this on at column level and then also decide if you want the particular view to be one that you want users to inline edit.
To enable inline editing double-click in a cell within your iSheet.
When you make your changes any validation you have set up for the particular cell is still applied. If you do enter any incorrect characters an error message will display to explain this.
Once you have finished, click anywhere outside of the cell and a message is displayed on the top right of the screen. This is to let you know that a change has been made and offers you the chance to have an optional refresh of the view.
Inline editing limitations
Inline editing is enabled for most of these columns by default however for date and time, the default format is not compatible with our inline editing functionality.
Date & Time
There are four formats for Date & Time:
- DD MMM YYYY (12 Jan 2014)
- DD/MM/YYYY (12/01/2014)
- MM/DD/YYYY (01/12/2014)
- DD.MM.YYYY (12.01.2014)
Inline editing is possible only for options 2 and 3, so inline editing is not possible unless this format is changed from the default.
Columns with the 'Other' option
You cannot use inline editing where the 'Other' option is possible.
