Hello,
I am struggling to perform multiple patch statements in a single button. Currently, I am attempting the undesirable method of just throwing 10+ patch statements in the onSelect() of a button. However, it will only patch 3 values and reset the other updated cells to their previous value before changing them. This worries me because it could indicate a limit in either connection or privileges. It also doesn't matter which values I pick to for my 3.
I'm unsure how to update them with forAll() statements because this button should be updating multiple columns in a single row, instead of multiple rows in a single column. I can't seem to conceptualize using a collection with this situation.
My current patch statements look similar to this:
Patch(RandomTable,ThisItem,{Feb:Value((TextInput2.Text))});
Patch(RandomTable,ThisItem,{Mar:Value((TextInput3.Text))});
Any help would be appreciated.
