best practice collecting in large amounts of data | Community
Skip to main content
Answered

best practice collecting in large amounts of data

S

I create Celebration of Life Summary Magazines so I need to collect a large amount of data and I am concerned about a long form and the customer experience. Is it easy for a client to come back and complete form? What do you recommend for the form design or maybe this is not the right solution to collect life story data? Will collect personal data, stories, tributes etc. and will have short answers, long form, drop downs, and multiple choices. Thanks you. 

Best answer by john.desborough

@SMerkel - if you connect each form to a google sheet, for example, and capture and pass the email address as the unique identifier between the forms, you can use the functions inside google sheets to pull all the data together on a ‘reporting’ tab using the email address as the identifier for vlookups. 

 

i do this all the time for my forms and for those of my clients. 

 

des

View original

    6 replies

    Liz
    Community Team
    Forum|alt.badge.img+5
    • Liz
    • Tech Community Advocate
    • 14862 replies
    • July 18, 2023

    Hi @SMerkel Happy Tuesday! If possible, I would suggest breaking up the form into multiple and either connecting them together or sending them one by one to ensure there isn’t any data loss. 

    Life is a series of awkward moments separated by snacks.
    S
    • SMerkel
    • Author
    • Explorer
    • 2 replies
    • July 18, 2023

    Thanks for your reply.  let’s say there is 8 sections. If I create 5 separate type forms, and I have 50 customers, won’t it be hard to track if I got all 8 sections back from each client?  I don’t see how you would like together. 

     

    john.desborough
    Forum|alt.badge.img+6
    • john.desboroughCertified Partner
    • Certified Partner & Champion
    • 5264 replies
    • Answer
    • July 18, 2023

    @SMerkel - if you connect each form to a google sheet, for example, and capture and pass the email address as the unique identifier between the forms, you can use the functions inside google sheets to pull all the data together on a ‘reporting’ tab using the email address as the identifier for vlookups. 

     

    i do this all the time for my forms and for those of my clients. 

     

    des

    If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
    Liz
    1 person likes this
    • Liz
      Liz
    S
    • SMerkel
    • Author
    • Explorer
    • 2 replies
    • July 18, 2023

    Thank you! I will try that out. 

    Grace
    1 person likes this
    • Grace
      Grace
    Liz
    Community Team
    Forum|alt.badge.img+5
    • Liz
    • Tech Community Advocate
    • 14862 replies
    • July 19, 2023

    Let us know how it goes, @SMerkel !

    Life is a series of awkward moments separated by snacks.
    V
    • VilandreIck
    • Navigating the Land
    • 1 reply
    • November 10, 2024

    Use conditional logic to show only relevant questions based on previous responses. For example, if a user says they don’t want to add a specific tribute, additional fields for that section could remain hidden.

    Liz
    1 person likes this
    • Liz
      Liz

    Reply


    Still need help?

    Don't be shy and ask the community.

    Ask your question here!
    Community T&Cs