Buttons to increment value in table

1

I have made a grid of buttons that I want to increment a value of rows inside a table, but I can’t find a good way to go about it. Since the buttons aren’t in the table, I can’t get the value of thisRow. Does anyone have any solid ideas?

bilde
bilde1728×1980 141 KB

2

Hello @Stian_Ovesen

You need a way to filter the table. The most obvious option is to filter based on the arrow. Since it is represented as text, you can filter the table accordingly. The formula might look something like this:

[Antall markeringsskilt - Alti Sandnessjøen].Filter(Name = "↑").First()

The button formula could be something like this:

Let([Antall markeringsskilt - Alti Sandnessjøen].Filter(Name = "↑").First(), cRow,
ModifyRows(
  cRow, 
  [Antall markeringsskilt - Alti Sandnessjøen].[10], cRow.[10] + 1)
)

I updated the first two button formulas in your doc. You can apply the same logic to the others.

Note: I added the Let() formula to reuse the filter result and used the First() formula because the filter always returns a list. Even if the list contains just one element, you need to extract the first element from the list using First().

Best regards,
Arnhold

3

Thank you, @Felipe_Arnhold! That works perfectly :slight_smile:

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.