All the instructions I've found so far say that the .csv must be put into the media folder.... So that .csv is only good for a single survey.
Is there any way to force all my surveys to pulldata from a single source?
YES WE CAN!!!!!
Just did a test run with linked cells from a single source and it works!!!!
I'm not there yet, hehe
Over my head at this point.
Ahh that would make a difference
But that only works when online. We are offline 99% of the time.
You can also pull data from a feature server with some code in a calculation field
You will just have to add an extensions folder to your survey folder with a file with the appropriate JavaScript functions in it.
This will work when in Excel but you would still have to open, refresh, then republish each form.
You can even link excel to SQL directly. But again this just changes your excel on your computer. Still got to get it up to 123. Still have to open all your forms and republish.
Hi Bryan,
Can you outline the workflow steps you used to make this happen please.
Regards,
Craig
Great idea.
I wonder if we can link cells in the XLSForm choices tab (or custom choices tab) to a master excel file?
Not that I have seen.
My idea is to have a master lookup form (have a form that just has a bunch of choices, external_choices, or csv files with it). Then the pulldata has a itemid in it that points to this master form. Seems like a way to do it without any new tech needed.
I have an Observes list that varies throughout the year as crews come on and leave. Right now I have to update the same list in 9 different forms. Having a Company X lists form would be cool.
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
