Latest Contributions by MikeChapman

Greetings All,              I have been working on a field form for collecting sanitary line condition by field crews.  The question came up as to whether the form "date" could be set automatically when someone selects a location or line segment on the location map, any helpful hints greatly appreciated? MC ... View more

Greetings,      I have a survey sheet that includes a series of pulldata functions that return a numeric value to a specific response.  I would like to sum/total those individual numerics to calculate a total score.  Examples below: XLS sheet- Survey form- I have scoured some of the other questions/responses on the forum and tried some 'if' statements but not having much luck (it may only be a formatting issue) Thanks, MC ... View more

I have a survey form for identifying exposed sanitary lines and a few of the questions have multiple choice options. We have a numerical scoring system we use to give each response a specific number that is used to create a total score for prioritizing work. Example- "Label" Pipe material? response "ABS", numerical score = 3                              Pipe diameter? response 15- inch, numerical score 2                                                                       Total = 5 ... View more