3.1 Arrange data send to Googlesheet

Case 1: The order of arranging information about Google Sheet is the same as the order of filling out the information fields in the form

Option 1. Use the layer feature to track the order of fields in the form

Access: Builder -> On the bottom left -> Layer -> Find the Form

The order of Form field in Layer is similar with order of data in Googlesheet

Option 2. Use the "Up, Down" button to change the order of the fields in the layer

Use "Up, down" button to arrange order of field in Layer as you want -> Order of data that send to Googlesheet will be similar

Case 2. The order of arranging information about Google Sheet is different from the order of filling out the information fields in the form

  • Arrange the order of required information to be entered in the same way as option1 and 2 of Case 1

  • Arrange Google Sheet Field

Click Form -> Advanced -> tick Arrange Google Sheet Field

Sort default fields in Sheet sync configuration

Last updated