Data Table / Working with Columns

Hi Guys,

Having issues understanding how to change columns in datatable. I need to change the popup list on one of my columns after other things are selected. I just can’t seem to get the popup for the column to edit its list.

So I start here;
var datatable = $$(‘timesheet_datatable’);

There is a column named activity that is a pulldown list, I need to get access to that column and change it from time to time.

Basically the options arguments for the combo boxes in data tables is great. But I cannot figure out how to change the options. In our programs this will happen a lot. There was mention of use of filters, but that currently seems to complex for the operation.

I got the filter working, but it doesn’t work well for this. If I turn a filter on, it filters the entire row. I really just need the specific options in a specific column to changed based on other criteria. Is this possible? I did it once by hacking the list but it caused even more problems. Like blanking the column after a valid selection.

Webix looks good, really impressed, this is our only current hangup.

Ok, got the filter to work well. Next issue :-). Filter are good, but our issue is that sometimes we want to get the data in real time, so is there still a way to completely refresh the options displayed in the combo with what we pull from an API on the other end.

I switched it over to a collection instead of options, isn’t there a way to just refresh the collection? ie; it is an external data source. Seems it should be trivial to me, I’m missing something :-). I’ve now tried options.load() it doesn’t error, but just won’t refresh and show the new data.

Thanks.

Hi,

Is your question about “combo” editor and column collection ?

You can apply clearAll and parse methods to reload “collection”

http://webix.com/snippet/922ec65c