If I understand correctly, you want to change the Current Selected Option
of a Select list
column by using a button (?), if thatโs it, you might wanna try something like this
ModifyRows([Books ๐].Filter(Title=thisRow.[Books ๐].Title AND Status="Reading ๐"),Status,"Completed ๐"))
(It comes from my reading tracker where Status
is my select list column)
In this formula :
-
[Books ๐]
is the table where the select list you want to modify is - The first part of the
Filter()
:Title=thisRow.[Books ๐].Title
is just a filter for selecting the right row in the table where the select needs to be changed (You can add as many filters you need) - The second part of the
Filter()
:AND Status="Reading ๐"
was to get the โcurrent selected optionโ in the select list and needed to be changed - The last part of the formula just says what column needs to be โupdatedโ by
ModifyRows()
and by what it should be updated.
But, thereโs a con doing this in this way, if later, you decide to change the Selectable Options
in your select list, youโll need to change it in your formula too, especially the โcurrent statusโ part : Status="Reading ๐"
I hope this is what you were looking for