Dynamically create a select list based on how many rows are in the table?

David_Burkhart · November 17, 2023, 4:12pm

Hi,

I have a select list column in my table that I want to give options based on how many rows are in the table.

For example, if there are 2 rows in the table. I want the options for the list to be either “1” or “2”.
I have not had success with this so far.

This formula is the closest I have gotten but it still does not display the items as a list:

Sequence(1, thisTable.Count())

My use case is I for project management. I have a list of tasks, and based on the list of tasks, I want to calculate the order of priority. So if there are 10 tasks (rows), I want to be able to order each row 1-10 to determine a roadmap of the timeline that each task should be completed.

Shaina_Torgerson · November 22, 2023, 4:04pm

Hey @David_Burkhart ! Thanks for reaching out. While this is not possible at this time, this sounds like a feature request the Coda team has been tracking to be able to sort select lists from column options and affect the row sorting on the whole table. That said, we have moved this post into the Suggestion Box for other members of the Community to chime in on this. We’ve gone ahead and tracked your vote for this feature formally.

joost_mineur · November 22, 2023, 4:16pm

Hell @David_Burkhart,

Are you sure you entered this code as a formula - not as text.
It works for me just fine.

Greetings, Joost