How to choose trigger column in case my form have optional questions

[cloud]

I have a google form that has few optional fields, Now I need to add a trigger whenever someone filled this form. Now the problem is if I put the trigger column on the last column, which is optional, It is not triggering the flow, And if I am putting the trigger column on a mandatory field I am losing out on the optional field data as your trigger does not capture data after trigger column. Please suggest a way to solve the problem.

 

[PabblyMember4]

Hey @cloud

We are always suggesting the user to put the last column of the Google Sheets/Forms as a trigger column to capture the data correctly. As our system was designed in such a way that the data will not pick up after the trigger column. Therefore we will request you to kindly change the mandatory column where the trigger can be placed on the last column and then fetch the response from Google Forms.

You can check the below videos for the same:-

https://www.youtube.com/@Pabbly/search?query=Google%20forms

Thanks
Kunal