Mark checkbox if certain options are selected from a list

[Pch]

For the button Saldar :
I’m not sure if I’m gonna say this properly, but FormulaMap() (See here ) kind of run a formula for each elements in “a list”

In this case, the list is ThisRow.Movimientos and the formula is :
for each CurrentValue (of ThisRow.Movimientos (which are the Cliente from [Movimientos]) mark the checkbox Saldado as True()

For the Filter(), It compares the 2 lists Cliente and Clientes and get only the Cliente where Saldado is False()

But, having played around a lot with buttons and checkboxes, for some reasons unknown to me, I also had troubles with that and found the solution in this post :

Can I use Modifyrows() with an if() statement in the value to be modified? Can't get it to work

Hey Steve! Looks like the ModifyRows action does not evaluate new column values on per-row basis. You need to split your action in two: check the checkbox on the rows where it needs to be checked, and uncheck on those that need to be unchecked. Here’s a formula for the “Set” button in the answer above; no need for hidden buttons. RunActions( ModifyRows([Table 1].Filter(Checkbox.Not() AND Value = Input_Colour), Checkbox, true), ModifyRows([Table 1].Filter(Checkbox AND Value != Input_Colour…

Hope this help a little