UpdateIf with a listbox

[Kathryn_Marie]

Hi All,

I have got a record updating if there is a matching record in a table, but I am actually looking at doing the opposite to this. If it finds the item in the table it updates all the other records. My code works to update the record, so what is the opposite to in? I tried NOT but that doesn't work.

ForAll(Gallery1.AllItems,
UpdateIf(Mapping, crb20_item in ListBox4.SelectedItemsText.Value, {cr330_item_order: cr330_item_order + 2 }));

Thanks

[PowerAddict · Accepted solution]

Hi,

Can you try something like this?

ForAll(Gallery1.AllItems,
UpdateIf(Mapping, !(crb20_item in ListBox4.SelectedItemsText.Value), {cr330_item_order: cr330_item_order + 2 }));

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit(Haman)

[Kathryn_Marie]

Perfect!

Thank you 🙂

[PowerAddict]

Glad I could help!