Action on the system generated list

[Gropapa]

Hi, I'm quite new to appsheet and I've looking for an answer, I hope this not a duplicate (or a stupid question)

I have a list of people generated by the system, each click leads to the persone detail.

On the list I can add (I see the + button).

 Thing is I would like the same type of button (even if it s in header I don't really care) in order to call an action that would gather filtered people phone to send an sms (meaning 1 SMS with multiple recipients)

I see how to create the filter, the action, but there is no way i can have a button to execute this. Everytime I try I have a button inline on each person which makes no sense

Thanks

[OptimiX_XcrY · Accepted solution]

As a start , I suggest to create another table, with only one row , and a button for a Main Action in this new table. The Main Action will be of type "execute an action(your first action) on a set of rows" .

The button you've created so far  is an one row action.

 

[Gropapa]

I'll try that out & let you know, thanks!

[Gropapa]

Works really well, I struggled a bit to find a working formula but I am fine with the result

CONCATENATE(
SELECT(people[Phone],
OR(
COUNT([Related paiements][date])=0,
MAX([Related paiements][date]) < EOMONTH(TODAY(), -1) + 1)
)
)

Thanks @OptimiX_XcrY