I'm not sure what specifically your question is. The order option is used to set the initial table order. You can use the order API to change the prder programmatically. If this doesn't help please provide more details about the problem you are trying to solve.
I am researching something which I think may be along the same lines.
I have a column with dates of seniority of membership with the earliest date being
1 01/01/2020
2 02/03/2021
3 03/04/2022
I can sort the dates no problem and I would like another column that would do the count 1-3 so if 2 was to leave 3 would become 2 and so on
Replies
I'm not sure what specifically your question is. The
order
option is used to set the initial table order. You can use theorder
API to change the prder programmatically. If this doesn't help please provide more details about the problem you are trying to solve.Kevin
I'm also not sure what you're asking exactly, maybe this helps:
Order by column name on init:
Order by column name using
order
API:Note that there's currently a small bug with ordering by name using the API. For now you can work around it like this:
But column name is coming dynamically from multiple accounts in same table. Column name is fixed for each account.
So, how can we use condition?
The name value passed is a string. You can set a varaible before initializing Datatabes and use that instead of a literal string, for example:
Kevin
I don't really understand what you mean. Can you provide a test case?
Potentially you could do something like:
Or if you can't define your condition until the table is initialized you could do:
I am researching something which I think may be along the same lines.
I have a column with dates of seniority of membership with the earliest date being
1 01/01/2020
2 02/03/2021
3 03/04/2022
I can sort the dates no problem and I would like another column that would do the count 1-3 so if 2 was to leave 3 would become 2 and so on
@FireNet999 Sounds like you want an index column like this example.
Kevin
Many thanks Kevin
That looks like it fits my needs
I will give it a go
Colin