New Bug Encountered: Action: Execute an action on a set of rows

AppSheet AppSheet Q&A
21

@Andrew_W Thanks for this info. We are aware of this weird behavior and are investigating where the main problem is.

2 Likes
22

I also have an action in an app that is suppose to trigger an email with attachment. It also recently stopped working only in a web-browser, though. The action still works on a tablet (although I need it more for a web-browser). I click the action button and nothing happens when it should automatically update and sync to run the workflow rule.

23

@Aleksi Do we know if this is fixed yet?

24

This seems to be a different problem.
I would suggest to try your action in the app design window (Emulator). If it works, refresh your browser’s cache by clearing all Appsheet cookies and data, and then reloading them again.

25

I believe Appsheet is still working on it.

1 Like
26

@Phil Any thoughts about this issue?

27

We have found the reason for this and if everything goes well, the fix is released when we deploy today.

4 Likes
28

The action now works as expected, all above formulas FILTER(…), REF_ROWS(…) seem to perform well.
Thanks Appsheet team!
Couldn’t do it without your help!

2 Likes
29

You’re welcome

30

For your information what I’ve noticed on my side concerning ‘execute an action on a set of rows’:

For a record of this table : TableA
Referenced Table: TableB
Referenced Rows:
Referenced Action : ActionX

when the 2 tables are the same , Referenced Rows = SELECT() and the ActionX is executed

sample: that works:
For a record of this table : T_ImpPrs1
Referenced Table: T_ImpPrs1
Referenced Rows: SELECT(T_ImpPrs1[Ip1_ID],[Ip1_NewPrs_B])
Referenced Action : ActionX

p1_ID is the key of T_ImpPrs1, the action ActionX is executed

when the 2 tables are the different, Referenced Rows = SELECT() , the ActionX is NOT executed

when I replace the SELECT() by FILTER() the ActionX is Executed

sample: that don’t works:
For a record of this table : T_ImpPrs1
Referenced Table: T_Person
Referenced Rows: SELECT(T_Person[ID],AND([_THISROW].[Ip1_Prs_ID]=[ID],NOT([_THISROW].[Ip1_NewPrs_B])))
Referenced Action : ActionY

ID is the key of T_ Person, the action ActionX is NOT executed

now I change the SELECT by a FILTER

sample: that works:
For a record of this table : T_ImpPrs1
Referenced Table: T_Person
Referenced Rows: FILTER(“T_Person”,AND([Ip1_Prs_ID]=[ID],NOT([Ip1_NewPrs_B])))
Referenced Action : ActionY

ActionX is executed

1 Like