g1 issueshttps://code.gramener.com/cto/g1/-/issues2019-02-27T06:09:46Zhttps://code.gramener.com/cto/g1/-/issues/146FormHandler table should support search in columns, like in excel2019-02-27T06:09:46ZBhanu Kbhanu.kamapantula@gramener.comFormHandler table should support search in columns, like in excelapart from filtering via unique values (#142) columns in table should support inline searchapart from filtering via unique values (#142) columns in table should support inline search1.51TejeshTejeshhttps://code.gramener.com/cto/g1/-/issues/142g1.formhandler table must show unique items in header dropdown for quick filt...2019-02-27T06:09:46ZTejeshg1.formhandler table must show unique items in header dropdown for quick filtering, like Excel![image](/uploads/27d5c68392f0b1d6c6f2ed40f7a55da5/image.png)
raised by @sindhura.ch for bmgf admin panel
Table only with sort minus filters & dropdowns![image](/uploads/27d5c68392f0b1d6c6f2ed40f7a55da5/image.png)
raised by @sindhura.ch for bmgf admin panel
Table only with sort minus filters & dropdowns1.51TejeshTejeshhttps://code.gramener.com/cto/g1/-/issues/83Equals not working in column dropdown in FormHandler table2019-02-27T06:09:46ZNaveen ManukondaEquals not working in column dropdown in FormHandler table- When we search with equals in first page it is working good.
- When we click on second page equals as we had only one search result again we need to click on first page for getting the result. If we have only one search result can we r...- When we search with equals in first page it is working good.
- When we click on second page equals as we had only one search result again we need to click on first page for getting the result. If we have only one search result can we redirect to 1 page in the table.
- Can we clear the filters without updating the URL?
- Please refer to below gif.![formhabdler_table](/uploads/7ae8c6e09d5ba35a3e0918a04e47f17e/formhabdler_table.gif)1.51TejeshTejeshhttps://code.gramener.com/cto/g1/-/issues/53FormHandler Table - Feature to disable column options2019-02-05T10:18:58ZBhanu Kbhanu.kamapantula@gramener.comFormHandler Table - Feature to disable column optionsCurrently, column options are enabled by default
![fh-table-column-options](/uploads/951039e00889a78d3dafbce5132e1f2d/fh-table-column-options.png)
It would be good to have an option to disable it.Currently, column options are enabled by default
![fh-table-column-options](/uploads/951039e00889a78d3dafbce5132e1f2d/fh-table-column-options.png)
It would be good to have an option to disable it.1.51TejeshTejeshhttps://code.gramener.com/cto/g1/-/issues/176add a new row with empty data for g1.formhandler2019-12-05T11:15:48ZPratap Vardhanpratap.vardhan@gramener.comadd a new row with empty data for g1.formhandler### Summary
We can't add a new row with empty data for g1.formhandler
### Steps to reproduce
- Create a csv with columns alone and hook it up with formhandler### Summary
We can't add a new row with empty data for g1.formhandler
### Steps to reproduce
- Create a csv with columns alone and hook it up with formhandlerhttps://code.gramener.com/cto/g1/-/issues/164Unable to deselect the selected sorted option2019-05-08T02:28:37ZAkash BarlaUnable to deselect the selected sorted option![sort_deselect](/uploads/a7bd6a42973c618f863c80da2cc68eb5/sort_deselect.gif)![sort_deselect](/uploads/a7bd6a42973c618f863c80da2cc68eb5/sort_deselect.gif)TejeshTejeshhttps://code.gramener.com/cto/g1/-/issues/163Column filter is displaying multiple times in header when we hide the filter2019-05-08T02:28:28ZAkash BarlaColumn filter is displaying multiple times in header when we hide the filter![Column_hiding_issue](/uploads/5876b231e885375373c38129a3ed27fe/Column_hiding_issue.gif)![Column_hiding_issue](/uploads/5876b231e885375373c38129a3ed27fe/Column_hiding_issue.gif)TejeshTejeshhttps://code.gramener.com/cto/g1/-/issues/161g1.formhandler refactor2019-05-08T02:28:20ZTejeshg1.formhandler refactor1. define hierarchy of hooks, make sure it is consistent
2. Examples & documentation
3. Refactor to develop faster1. define hierarchy of hooks, make sure it is consistent
2. Examples & documentation
3. Refactor to develop fasterTejeshTejeshhttps://code.gramener.com/cto/g1/-/issues/157Formhandler Excel export options must enable downloading of entire dataset2019-03-12T05:50:13ZTejeshFormhandler Excel export options must enable downloading of entire datasetraised by @anvesh.dasariraised by @anvesh.dasarihttps://code.gramener.com/cto/g1/-/issues/155Formhandler - show _count, _limit, _offset also as filters.2019-03-04T03:51:04ZTejeshFormhandler - show _count, _limit, _offset also as filters.On changing pageSize, there is no way to clear the filter. Showing `_limit=` also in filters will help.
Same problem when applied filter `"Europe"`, goto page 2 and clear `"Europe"` filter.....Still shows _offset=1, no way to clear the ...On changing pageSize, there is no way to clear the filter. Showing `_limit=` also in filters will help.
Same problem when applied filter `"Europe"`, goto page 2 and clear `"Europe"` filter.....Still shows _offset=1, no way to clear the filter.
Other solution is to, On click of "clear all filters", remove `_offset=`https://code.gramener.com/cto/g1/-/issues/151g1.formhandler unique value filtering - handling more than 100 unique values ...2019-02-19T13:53:12ZTejeshg1.formhandler unique value filtering - handling more than 100 unique values per column- If there are more than limit: values (default: 100), show up to limit items. Mention that "Only first {limit} items shown"- If there are more than limit: values (default: 100), show up to limit items. Mention that "Only first {limit} items shown"https://code.gramener.com/cto/g1/-/issues/125Implement a FormHandler form editor2019-02-07T10:42:47ZS AnandImplement a FormHandler form editorAllow users to design a form that updates a single row. Use this to
- edit rows
- as a modal, a separate section, or as an iframe
- rapidly flip between rows using submit / keyboard navigation
- learn from data already typed to ease the...Allow users to design a form that updates a single row. Use this to
- edit rows
- as a modal, a separate section, or as an iframe
- rapidly flip between rows using submit / keyboard navigation
- learn from data already typed to ease the process of filling the form
- support automated columns (e.g. updated time, editor)https://code.gramener.com/cto/g1/-/issues/117Support multiple datasets2019-02-07T10:43:07ZPragnya Reddypragnya.reddy@gramener.comSupport multiple datasets`$.formhandler` should render multiple tables when `data-src` returns multiple datasets`$.formhandler` should render multiple tables when `data-src` returns multiple datasetsTejeshTejeshhttps://code.gramener.com/cto/g1/-/issues/113Multi-column support2018-12-14T05:16:55ZBhanu Kbhanu.kamapantula@gramener.comMulti-column supportTejesh: alter table to create new columns if the data source is `FormHandler` endpoint else add to `JSON` objectTejesh: alter table to create new columns if the data source is `FormHandler` endpoint else add to `JSON` objectTejeshTejeshhttps://code.gramener.com/cto/g1/-/issues/110edit mode for formhandler table for data: option (non-gramex endpoints)2019-02-07T10:43:22ZTejeshedit mode for formhandler table for data: option (non-gramex endpoints)TejeshTejeshhttps://code.gramener.com/cto/g1/-/issues/92FormHandler Table: master issue2019-04-09T05:59:51ZS AnandFormHandler Table: master issueThese were tested on g1 0.9.0 using this configuration:
```yaml
url:
formhandler:
pattern: /users
handler: FormHandler
kwargs:
url: users.xlsx
id: user
```
- [x] If a table has few rows, allow column dropdown ...These were tested on g1 0.9.0 using this configuration:
```yaml
url:
formhandler:
pattern: /users
handler: FormHandler
kwargs:
url: users.xlsx
id: user
```
- [x] If a table has few rows, allow column dropdown to go below page. Currently it gets chopped off
![image](/uploads/a9c8da00eddf7429dd6404a06a9f3dfa/image.png)
- [x] After delete action, the row is not deleted in the UI, but it is deleted in the backend. Reloading the page refreshes and shows that the row has been deleted.
- [x] In case of an error on the AJAX submission (e.g. a delete action, add action, etc), there error message clears the table. Instead, the error message should be shown above the table. Ideally, this should be a re-usable function. Other custom actions should be able to just call `.alert(msg)` and re-use the same alerting mechanism
- [ ] If $.formhandler does not find jQuery, Bootstrap, etc, show a visible one-time dismissable warning that can be turned off by default
- [ ] Allow exporting as JSON, CSV (in addition to XLSX). This helps users right-click and copy-paste the URL into applications.
![proxy](/uploads/aac9f1f4976f067762a149e85cd698e2/proxy.gif)
- [ ] Deleting an empty primary key in Excel deletes all rows.
![proxy](/uploads/df82ed66aa08ff1b23334fbe1cab5711/proxy.gif)
- [ ] If all rows in table are deleted, we cannot add rows. Maybe because it loses information on what columns exist.
![proxy](/uploads/141c8140da4fbafc742edd03aa491ef5/proxy.gif)
- [ ] Make Add and Edit easier. On Add / Edit:
- [x] move focus to first input `$('input', ...).focus()`. I want to directly start typing
- [ ] give me a cancel option in red `.btn-danger`
- [x] make the Save button green `.btn-success`
- [x] don't allow both add and edit to happen at the same time
- [x] allow shortcut (Enter) to save
- [ ] TejeshTejeshhttps://code.gramener.com/cto/g1/-/issues/79Formhandler Plugin mechanism - Datacomb2018-07-16T11:23:46ZTejeshFormhandler Plugin mechanism - DatacombPlugin Mixin to include functionality easily at almost any level.
To start with https://github.com/cmpolis/datacombPlugin Mixin to include functionality easily at almost any level.
To start with https://github.com/cmpolis/datacombhttps://code.gramener.com/cto/g1/-/issues/78Implement a formhandler Tree View2018-12-19T16:08:43ZTejeshImplement a formhandler Tree ViewReferences:
https://docs.webix.com/desktop__treetable.html
https://frappe.io/datatable - Tree View section
https://gramener.invisionapp.com/d/main#/console/13753225/303473425/preview - BMGF project design linkReferences:
https://docs.webix.com/desktop__treetable.html
https://frappe.io/datatable - Tree View section
https://gramener.invisionapp.com/d/main#/console/13753225/303473425/preview - BMGF project design linkhttps://code.gramener.com/cto/g1/-/issues/72formhandler: view option for charts2018-07-16T11:25:09ZPratap Vardhanpratap.vardhan@gramener.comformhandler: view option for charts### Summary
With _by option #71 added.
User will have flexibility to construct large number of usecases from formhandler interface. Currently, table view is the default.
It would be useful to have view dropdown on options to select ...### Summary
With _by option #71 added.
User will have flexibility to construct large number of usecases from formhandler interface. Currently, table view is the default.
It would be useful to have view dropdown on options to select chart type.
- After selecting a chart, ex scatterplot, chart options like x, y, size, color, will be automatically selected from dimensions and metrics in naive order.
- User can modify chart options from a modal popup, to select x, y etc.
- url parameters preserve chart options
- For now, charts with minimal/flat options will be supported
- End URL should be shareable/embeddablehttps://code.gramener.com/cto/g1/-/issues/57formhandler table modal doesnot appear sometimes (needs page refresh to make ...2018-07-16T11:28:23ZTejeshformhandler table modal doesnot appear sometimes (needs page refresh to make it work)TejeshTejesh