Solved: Update multiple rows - Page 2

Mario_Moncada · 07-01-2022 05:04 AM

Hi,

I have tried to update all the rows through ACTION based on the date on another table. No error but my app froze. can someone please help?

I made an action ("Paid PO TRUE") to put "TRUE" in the [Paid] Column. Then I created another action ("Paid PO") that invokes the ("Paid PO TRUE") in all the rows that are included in my Date criteria.

this is the expression I have used to update the rows:

Referenced Rows: FILTER(
"Expenses Liters",
AND(

([Date] >= [_THISROW].[PO Start Date]),
([Date] < [_THISROW].[PO End Date])
)
)

Please help,

SkrOYC

You are runing it on a phone or in the browser?

Most browsers should have a mechanism to prevent an infinite loop, and if you are changing more than, let's say, 400 rows at a time with an action, probably the browser will say that the app froze or similar. Just click "wait" or similar (Idk how it's translated in english, here it says "Esperar"), that's it.

Anyway, that's to overcome the problem, but I suggest you to think a better solution, like making sure to use a less broad date range, maybe just around a week of data instead of a whole month

View solution in original post