My custom form doesn't report values to the spredsheet it's assigned to. How do I properly set this up?

  • Profile Image
    Kyle S.
    Asked on March 16, 2013 at 06:27 PM

    How do I make it work like the form on the attached website?  Here is the HTML:

     

    Tree Information:
     
    1 - Select -AppleApricotAvocadoBlood OrangesFigGrapefruitGrapesGuavaJujubeKumquatLemonLimeLoquatMandarinMangoMeyer LemonsNavel OrangeNectarineOliveOrangePassion FruitPeachPearPersimmonPlumPomegranateTangeloTangerineUnknownValencia OrangeZapote - Select -123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250 - Select --15'15'-25'25'+ - Select -Front YardBack YardBoth - Select -1-55-1010-2020-5050-100100+ - Select -SummerFallWinterSpring
    2 - Select -AppleApricotAvocadoBlood OrangesFigGrapefruitGrapesGuavaJujubeKumquatLemonLimeLoquatMandarinMangoMeyer LemonsNavel OrangeNectarineOliveOrangePassion FruitPeachPearPersimmonPlumPomegranateTangeloTangerineUnknownValencia OrangeZapote - Select -123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250 - Select --15'15'-25'25'+ - Select -Front YardBack YardBoth - Select -1-55-1010-2020-5050-100100+ - Select -SummerFallWinterSpring
    3 - Select -AppleApricotAvocadoBlood OrangesFigGrapefruitGrapesGuavaJujubeKumquatLemonLimeLoquatMandarinMangoMeyer LemonsNavel OrangeNectarineOliveOrangePassion FruitPeachPearPersimmonPlumPomegranateTangeloTangerineUnknownValencia OrangeZapote - Select -123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250 - Select --15'15'-25'25'+ - Select -Front YardBack YardBoth - Select -1-55-1010-2020-5050-100100+ - Select -SummerFallWinterSpring
    4 - Select -AppleApricotAvocadoBlood OrangesFigGrapefruitGrapesGuavaJujubeKumquatLemonLimeLoquatMandarinMangoMeyer LemonsNavel OrangeNectarineOliveOrangePassion FruitPeachPearPersimmonPlumPomegranateTangeloTangerineUnknownValencia OrangeZapote - Select -123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250 - Select --15'15'-25'25'+ - Select -Front YardBack YardBoth - Select -1-55-1010-2020-5050-100100+ - Select -SummerFallWinterSpring
    5 - Select -AppleApricotAvocadoBlood OrangesFigGrapefruitGrapesGuavaJujubeKumquatLemonLimeLoquatMandarinMangoMeyer LemonsNavel OrangeNectarineOliveOrangePassion FruitPeachPearPersimmonPlumPomegranateTangeloTangerineUnknownValencia OrangeZapote - Select -123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250 - Select --15'15'-25'25'+ - Select -Front YardBack YardBoth - Select -1-55-1010-2020-5050-100100+ - Select -SummerFallWinterSpring
    6 - Select -AppleApricotAvocadoBlood OrangesFigGrapefruitGrapesGuavaJujubeKumquatLemonLimeLoquatMandarinMangoMeyer LemonsNavel OrangeNectarineOliveOrangePassion FruitPeachPearPersimmonPlumPomegranateTangeloTangerineUnknownValencia OrangeZapote - Select -123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250 - Select --15'15'-25'25'+ - Select -Front YardBack YardBoth - Select -1-55-1010-2020-5050-100100+ - Select -SummerFallWinterSpring
    7 - Select -AppleApricotAvocadoBlood OrangesFigGrapefruitGrapesGuavaJujubeKumquatLemonLimeLoquatMandarinMangoMeyer LemonsNavel OrangeNectarineOliveOrangePassion FruitPeachPearPersimmonPlumPomegranateTangeloTangerineUnknownValencia OrangeZapote - Select -123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250 - Select --15'15'-25'25'+ - Select -Front YardBack YardBoth - Select -1-55-1010-2020-5050-100100+ - Select -SummerFallWinterSpring
    8 - Select -AppleApricotAvocadoBlood OrangesFigGrapefruitGrapesGuavaJujubeKumquatLemonLimeLoquatMandarinMangoMeyer LemonsNavel OrangeNectarineOliveOrangePassion FruitPeachPearPersimmonPlumPomegranateTangeloTangerineUnknownValencia OrangeZapote - Select -123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250 - Select --15'15'-25'25'+ - Select -Front YardBack YardBoth - Select -1-55-1010-2020-5050-100100+ - Select -SummerFallWinterSpring
    9 - Select -AppleApricotAvocadoBlood OrangesFigGrapefruitGrapesGuavaJujubeKumquatLemonLimeLoquatMandarinMangoMeyer LemonsNavel OrangeNectarineOliveOrangePassion FruitPeachPearPersimmonPlumPomegranateTangeloTangerineUnknownValencia OrangeZapote - Select -123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250 - Select --15'15'-25'25'+ - Select -Front YardBack YardBoth - Select -1-55-1010-2020-5050-100100+ - Select -SummerFallWinterSpring
    10 - Select -AppleApricotAvocadoBlood OrangesFigGrapefruitGrapesGuavaJujubeKumquatLemonLimeLoquatMandarinMangoMeyer LemonsNavel OrangeNectarineOliveOrangePassion FruitPeachPearPersimmonPlumPomegranateTangeloTangerineUnknownValencia OrangeZapote - Select -123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250 - Select --15'15'-25'25'+ - Select -Front YardBack YardBoth - Select -1-55-1010-2020-5050-100100+ - Select -SummerFallWinterSpring
    + Add Tree Group

  • Profile Image
    EltonCris
    Answered on March 16, 2013 at 07:25 PM

    Hi,

    We do not have such feature but a possible workaround could be using Hide/Show Conditional Logic on Forms. Though, you have to create all the fields manually since we do not have like the one you've provided and shrink them to align them in a new line. It's quite a bit laborious but it should work well.

    Give it a try and let us know your thoughts. Thanks!