What is the problem? Please be detailed.
My use case is this - We have one 'Enrollment form' which is being used to enroll children in an NGO's creches. The results from these submissions are being aggregated on an ODK Aggregate instance hosted on Google cloud. We're looking to create another simple 'Attendance form' which has a multiple select question which will dynamically pull the names of enrolled children into the form for their daily attendance, 'present' or 'absent'. Hence if a new child joins the creche mid-month the attendance form should automatically reflect their name once enrolled.
What ODK tool and version are you using? And on what device and operating system version?
Using ODK Aggregate, and the form submissions are also being published to Google sheets. ODK Collect is being used on Android tabs to collect data.
What steps can we take to reproduce the problem?
Do let me know if sending sample data and forms will help with this question, but to my knowledge its a generic issue, not specific to any particular form.
It appears that the only way to have external options is through a csv file that has to be uploaded to ODK Aggregate. You can't access select options from other form submissions. Even with this csv file if one needs to change the select options it has to be done manually and secondly the form version number has to also be manually changed. Am I right in understanding this?
What alternatives do I have since updating these forms manually on a daily basis is not feasible.