Auto populate answers in repeats from previous repeats; and extract information from repeats based on position within repeats

Idea created by nedulfon_usfs on Dec 10, 2018
    New
    Score50
    • dot_mmekuria
    • btkinal_SyrUniv
    • nedulfon_usfs
    • hashimotoy
    • E.degraaff@terranostra.nu

    Hello ESRI team,

     

    I have hit a wall in the development of a form that is used to collect plant data in plots along several beltline transects...

    I got the survey to work originally by using many select_one types in the form... then I learned about the performance issues with pulling too much information from the choices in the xlsForms.... and how it increases the form load time on your phone....

     

    Then I tried using the pulldata() from .csv, cascading selects, and external selects to alleviate the performance issues... this did not fix the problem... So, it seems that using repeat sections for each plot along each transect may answer my need and others needs.... the only problem is.... I now need to add some sort of calculation that can extract the plant names from the first repeat and pull them into the next repeat.... and that repeat into the next.... that way the species are in order of occurrence and don't get mixed up...... so I can analyze the information the data in an analysis section of the form....

     

    I have found such calculation using ODK (open data kit) which uses the exact same xlsForms and format for producing surveys.... the calculation that extracts answers within each repeat based on position is:

    indexed-repeat(namegroupi[sub_grpsub_i[sub_sub_grpsub_sub_i]])

    The indexed-repeat() has the ability to return the response value of question name from the repeat-group group, in iteration i. Nested repeat groups can be accessed using the sub and sub_sub parameters if needed.

    The indexed-repeat calculation also has the ability to copy answers for a question in a previous into the next repeat...

    For example: copying plant names from frame 1 ==> frame 2.... saving time and cutting down on select_one list pulls from the choices tab.... and possibly helping with performance issues and loading times....

     

    I would also like to see an absolute value calculation.... ODK has such a calculation.... abs() which is common to all excel files.... I use this to accomplish vegetation trend... but it is not available in Survey123.....

     

    I recommend checking out the capabilities that ODK has developed and the coding behind the enhancements... They would benefit Survey123 connect greatly.... Survey123 is much less complex and an easier platform to work with... for christmas I wish for indexed-repeats() and repeating answers from previous repeats in Survey123.... forget about my two front teeth...

     

    attached is an example of the xlsform I developed using ODK to extract plant names from two frames and post them into the analysis portion of my form... and I got it to work.... but I couldn't figure out how I would get the plant names to auto populate the next repeat based on the answers of the first plot.... its a dream and I know it would benefit many people and save time....