Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

"Kanban Order" as a read-only field in Grid View that can be sorted by

cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Michael_Vaganov
5 - Automation Enthusiast
5 - Automation Enthusiast

I want to be able to use the (amazing) Kanban view to prioritize tasks, and share those task priorities with people. The filter and share view features, which already exist, are so clutch for this.

Itโ€™s almost exactly what I want already! I want to be able to see the order that I put Kanban entries in when looking at the Grid view.

5 Comments
Mohamed_Swella1
13 - Mars
13 - Mars

Hi @Michael_Vaganov,

Welcome to Airtable Community! :slightly_smiling_face:

I would suggest that you create a Last Modified field, and set it to check for changes in the Single Select field you use in the Kanban view. You can then use Sort by date in the Kanban view .

BR,
Mo

Michael_Vaganov
5 - Automation Enthusiast
5 - Automation Enthusiast

That does help determine when an entry changes itโ€™s state, but thatโ€™s not what Iโ€™m looking for.

I want to know what order the Kanban cards are put in. If I have 20 items in my TODO column, and I re-arrange them based on priorities I have with my team (highest priority on top) by moving them up and down in the column, I want to know that priority later. I canโ€™t find a way to determine that ordering within the column right now.

We can (and do) have a priority value field, as a number, but those values are not great at resolving priority. Itโ€™s easier for the team to say TaskA-is-more-important-than-TaskB than it is to say TaskA-is-rank-9.1-and-TaskB-is-rank-9.05. Our best option is to un-hide the priority value field, and โ€˜bake inโ€™ the priority values manually, with lots of clicking and UI navigation, while still in the kanban view, after arranging the order. Iโ€™d like an automatic process that does that for us.

ScottWorld
18 - Pluto
18 - Pluto

This would be helpful! Unfortunately, there is no built-in way to do this in Airtable, because it doesnโ€™t remember your sort order from one view to the next.

As you mentioned, you would have to create your own additional field to keep track of the sort order numbering.

You might be able to partially automate the filling in the values of that new field. You could write a custom JavaScript to loop through the records in the order displayed, and auto-update that new field with increasing numbers. You could do the same by iterating through records with Integromat.

It would be nice if the Batch Update block enabled us to increment numbers throughout a list of records, but it doesnโ€™t allow that.

Your idea plus these ideas would make for good feature requests, if you want to add any of them into the #show-and-tell:product-suggestions category.

Michael_Vaganov
5 - Automation Enthusiast
5 - Automation Enthusiast

Is there a tutorial where I can learn more about manipulating Airtable data with JavaScript? Also, would the JavaScript be able to access the Kanban order, or are we back at the same problem?

ScottWorld
18 - Pluto
18 - Pluto

You know, I actually donโ€™t know if the JavaScript can access the Kanban order or not. It might not, because I just tested this with Integromat, and as far as I can tell, Integromat canโ€™t access the Kanban order at all.

So itโ€™s very possible that Airtable simply doesnโ€™t โ€œrevealโ€ the Kanban Order in any way that is accessible to external tools.

To learn more about manipulating Airtable data with JavaScript, you can add the new Scripting Block to your base, and it comes with some built-in examples.

Also, @JonathanBowen has created an ongoing tutorial series here:

And @openside is curating a list of community-developed scripts here:

https://builtonair.com/airtable-scripts/