Need help on formula & expressions

[DjLeiiii]

I need help on formula & expression, i want the system to help me generate Commission summary report based on Start Date/ End Date & sepecific technician. and it will list out all the items/services they had done.

[Metworks_IT1]

Hi, you'd need to configure a bot. Have you set up any before? 

If not, this resource might help:  https://support.google.com/appsheet/answer/11432969?visit_id=638203567241250592-3836459689&p=bots&rd...

If you want to select your parameters, as in the first screenshot, I would set up a "helper" table with those headers as columns, that would trigger a report based on your selection.

[1minManager]

Also - https://support.google.com/appsheet/answer/11541779?hl=en&sjid=16395661684301660075-EU

[Tommy62]

Dieses Video erklärt detailliert an einem Beispiel wie du eine Filter-Bericht-Hilfstabelle und das entsprechende Berichtformular erstellst.

Erstelle einen gefilterten Bericht  Dank diesem Video konnte ich AppSheet besser verstehen.