Optimizing the structure of the worksheet | Community
Skip to main content
Answered

Optimizing the structure of the worksheet


Hi all,  We just created our first typeform and it looks nice and easy. Now we are challenged with the structure of the results. We are saving the results in a worksheet and the structure is growing with the typeform. Do you people have recommendations how restructuring works best in worksheets or databases? What is possible? What not? 

Thanks in advance for sharing your know how and experiences!

 

Best answer by john.desborough

@Marike - what you should do is create another tab in the spreadsheet and change the order of the columns on that second tab. You can also rename the column headers from the ‘question text’ on the typeform created version to a new set of names that are shorter and make more sense. 

if you are using google sheets: to pull the data across each time a row is added from typeform you would need to use the arrayformula() function to pull the data from the appropriate column on the previous tab. 

hope this helps a little 

 

des

View original

3 replies

Liz
Community Team
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 15035 replies
  • April 19, 2022

Hi @Marike Happy Tuesday! Could you share a little more info on what’s working/what isn’t working? What are you looking to restructure and why? Thanks in advance!


  • Author
  • Explorer
  • 1 reply
  • April 20, 2022

Hi @Liz , thanks for getting back to me. 

Our typeform has grown and developed - only over days, but still a lot of things have already changed. All the results are saved in a worksheet. The order of the columns in the worksheet make our lives at the moment a little difficult as they seem very random and not logical. So, I would like to change the order of the columns and regroup it. I am not going to change any title or anything like that. Do you see any risk if I do that?

Thanks and best, 
Marike


john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5338 replies
  • Answer
  • April 20, 2022

@Marike - what you should do is create another tab in the spreadsheet and change the order of the columns on that second tab. You can also rename the column headers from the ‘question text’ on the typeform created version to a new set of names that are shorter and make more sense. 

if you are using google sheets: to pull the data across each time a row is added from typeform you would need to use the arrayformula() function to pull the data from the appropriate column on the previous tab. 

hope this helps a little 

 

des


Reply