Survey123 - Improve performance on querying external sources

Idea created by clement.laskar_onf on Aug 21, 2019
    • wparco
    • nicolas.marchand_onf
    • htouyeras_1
    • htouyeras
    • Golaie15
    • clement.laskar_onf
    • fredcocc

    To select a choice referencing a csv file, you are have to copy some fields in your survey datasheet (choices or external_choices).


    Would it be possible to use an external reference file (e.g.: sqlite, other) to populate a select list and make it fast ? (ref. - only with a better perfoming technical solution than CSV files)

    Today I don't see how to use a huge reference list (e.g. 100k + lines floristic or faunistic data) in a Survey123 form. Our tests using choices/external choices result in ~8 to10 second survey  loading time for 4000 lines only(!).

    Many thanks!