Does anyone know if there is a way to have an external data set on ODK central that is not just a CSV file connected to an individual form but a single online data set which several forms can pull from?
If not, does anyone know if this is expected to be a future feature?
We have a hacky way of having this function, which uses another application (Drive Autosync) to pair the contents of a shared Google drive with the relevant media folder for our forms on the devices. For us it gets around the current limitation of Central entities, which is that of needing to approve submissions before they get added to the datasets. We run SQL scripts to produce the external csv files and run these as cron jobs - they write the csv files to the Google drive and the field teams sync the folders in their devices. What they registered yesterday becomes available to them today, and without our intervention. We can’t wait for Central to provide this, because it is such added value to the entire tool set, and crucial for our workflows. One of the csv files has the general external itemsets, which doesn’t change often.
Looking to save time? Try ODK Cloud, the official managed hosting service from the creators of ODK.