Writing into defferent colums/spreadsheets from one form

I have created an APP in a FORM format. The USER will enter DATA into the APP and it will be WRITEN into a GOOGLE-SHEET.

I want to EXTRACT this DATA into a different GOOGLE SHEET for use in a different department.

Alternatively, I want to simultaneously WRITE this DATA into these TWO different SHEETS once the USER presses SEND.

Is this possible?

*Extract some of the DATA.

Hi @Jako

You may want to set an action here in the “Event Actions” of the Behavior Section, in your form settings:

That implies you create appropriate actions first, so that you will have these available in the dropdown list.


Thanks @Aurelien I will try this