Hi, I’m trying to add a formula to a button so it modifies the item on a status list in the same row.
It is exactly what this example shows: https://help.coda.io/en/articles/2039489-adding-formulas-to-buttons#example-8
However, I can’t get it to work. It seems it’s trying to add a text element instead of bringing the element from the list.
Any help will be much appreciated.
Here’s the example:
Hello Jose! You are right, you are extracting the text from the row, so what you have to do is get the whole row, so instead of this:
Phase.Lookup(Rank,thisRow.Status.Rank +1).Status
Should be simply this:
Phase.Lookup(Rank,thisRow.Status.Rank +1)
You will notice that if you use the formula above, though it will work, it wont show the status as if you would have changed it via the dropdown, I think that is because the lookup gives you all the values that matches your criteria, in this case is only 1 but in other cases may be more. To get around that just put a .First() at the end to tell it is just one value, so the formula would end up like this:
Phase.Lookup(Rank,thisRow.Status.Rank +1).First()
Wow! That was fast, thanks a lot! It works.