Hello,
We need to create a form-based database system to replace an existing, messy, Excel-based system. The idea would be to use likely multiple forms, one to add new entries to a list of projects, and one to modify existing entries. I like Survey123's form-based system and the ease of creating report templates that populate using submitted data, the ability to incorporate location, and the ability to create dashboards to monitor things like project status. I also appreciate the connectivity with Microsoft Power Automate to send e-mails based on a trigger--this is really useful and we'd like to use that. However, I'm not sure that Survey123 is the best tool for the job and could use some advice.
- Is there a way to use a pulldata function to access information from an existing feature service to auto-populate a survey form?
- Can you use a pulldata function to update an existing attribute of a record within an existing feature service?
- Can you use a pulldata function to create a picklist in a form based on attributes of an existing feature service?
I know you can use javascript pulldata functions, so I’m hoping there are ways to accomplish this. I know that in the past some of these things were not yet possible, but I’m hoping to find out both a) what is possible and b) how to accomplish it (I’m generally unfamiliar with javascript so templates or examples of code I could modify would be great).
If Survey123 isn't the right tool for the job, could you suggest inexpensive software that could accomplish this? We have Microsoft Access, though I don't recall this being a great database software. Maybe something open-sourced?
Any help and advice is greatly appreciated!
Thanks!