Latest Contributions by dgray

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! ... View more

Hi, I was wondering how to deal with multiple if conditions in a Survey123 calculation.  I know you can embed an if within in if but I'm not sure if this can handle all the if circumstances.  Basically, in my case, depending on which region you pick from a Select One list, a different formula will be used to crunch the same value parameter.  I have four different formulas, and one of them has two if's within it, so a total of five possible formulas used to crunch the same parameter. How could I structure this? ... View more

Hi, I'm having a lot of trouble getting a calculate statement to work.  I am trying to set a conditional statement for "Average Test Pressure" so that it does the following:  If there is only one gauge, take 3 readings (0h,1h, and 2 h) and average them, multiply by 6.89476 to get kPa from psi, and round to 0 decimals If there are two gauges, take all 6 readings (0h,1h, and 2 h) for both the higher and lower gauge readings, average them, multiply by 6.89476 to get kPa from psi, and round to 0 decimals However, I keep getting the error that says Invalid calculate for the bind attached to Average Test Pressure: Bad node. I tried playing with the Esri Field Types to make them all double, and the bind type to decimal, but this does not fix my problem.  I need help spotting the problem and fixing it. I've attached the XLS form. Any help would be great. Thanks!   ... View more

Hello,   I would like some help in getting Survey123 to populate attribute fields with weather parameters.  It looks like there used to be a document on how to do this, but it’s no longer available.    https://community.esri.com/t5/arcgis-survey123-questions/using-pulldata-to-gather-live-weather-data/td-p/856935   This site points to another link with some instructions: https://community.esri.com/t5/arcgis-survey123-blog/extending-survey123-smart-forms-with-custom-js-functions/ba-p/898782   It looks like MSN Weather also has parameters: https://docs.microsoft.com/en-gb/connectors/msnweather/ Open Weather has this information: https://openweathermap.org/api/one-call-api#how However, I’m unfamiliar with Javascript, and don’t know how to apply this information to my specific problem.  I need a step-by-step breakdown of how to use a pulldata function to get parameters either from Open Weather or MSN Weather, showing a specific javascript code example that I can use as a model from which to copy.  The actual pulldata function is straightforward, but I need help mostly with the JS part. ... View more