Hello everyone,
I've been testing the RemoveIf function, and rather than deleting what I was expecting it to delete, lots more records were deleted (they were test records, so no harm done). I'm wondering firstly if I can see in a text box which items are going to be deleted when I click a button and secondly, I probably need some help changing the syntax to do what I want it to do, which is only delete the record where the single item selected from the Combo Box ('CbxSelection') is firstly that which is in my column in SQL '2pInx' & the check box selected is in the same record as '2pInx', the checkbox is being written in 1rInx column in SQL. I can see I am missing the '1rInx' in my below syntax but adding it in after the && seems to error on me!
The below worked but deleted a lot more records than I was expecting, so I think the code needs a little work:
RemoveIf(
2rMapping,
2pInx:CbxSelection.Selected.2pInx = 2pInx && Value(
LookUp(
Gallery3.AllItems,
Checkbox3.Value,
Value(Checkbox3.Text)
)
)
);
