Latest Contributions by GISAdministrator22

Worked like a charm!!  Thanks a bunch! ... View more

Thanks again.  One last question.  The min_fair, min_poor, etc is determined by the color.  The color answer from a previous question should be used to determine the min and max values for condition in the table above.  see below for description of statements: if color is Blue and Reflectivity is less the min_fair then condition is poor if color is Blue and Reflectivity is less then min_good and greater than max_poor then condition is fair if color is Blue and Reflectivity is greater then min_good then condition is good if color is Brown and Reflectivity is less the min_fair then condition is poor if color is Brown and Reflectivity is less then min_good and greater than max_poor then condition is fair if color is Brown and Reflectivity is greater then min_good then condition is good etc. Is it possible to use the pulldata function for multiple fields (min_poor, max_poor, min_fair, max_fair, etc.) using the external table above and then use the above "if" statement based upon the color (which is determined by a previous question in the form)?  I have not been able to get this to work but am sure I am missing something in the syntax. ... View more

Thanks for the quick response!  So...  here is my external table (SignReflect2.csv): color min_poor max_poor min_fair max_fair min_good max_good Blue 0 19 20 39 40 60 Brown 0 24 25 44 45 55 FY 0 149 150 374 375 450 FYG 0 249 250 474 475 650 Green 0 69 70 114 115 125 Red 0 49 50 99 100 160 White 0 249 250 499 500 750 How would I nest the following expression using SignColor and Reflectivity(integer) entries from Survey123 form?  if(${Reflectivity} < ${min_fair}, 'poor'), if(${Reflectivity} < ${min_good}, 'fair'), if(${Reflectivity} > ${min_good}, 'good')  When using the following pulldata parameters: pulldata ('SignReflect2','min_fair','color',{SignColor}) pulldata ('SignReflect2','min_good','color',{SignColor}) or am I not approaching this right?  I appreciate any feedback you can provide as I may be over thinking this. ... View more

I have created surveys for street sign inspections and have collected about 7k sign poles with 13000 related signs (with groups and repeats). I am now working on another survey to collect the reflectivity of those signs.  The current form auto-populates most of the fields based upon the sign inspections collected previously and through the use of external choices and "pull data".  Is it possible to calculate values from those choices using a range?  What I am hoping to accomplish is populate a field with a condition based upon the reflectivity reading.  For example, a "white" "regulatory" sign would be considered in "fair" condition if the reflectivity reading fell between the range of 250 -500 and a "brown" "guide" sign would be in fair condition if the reading was between 25 - 40.   So the condition is determined by the results of the following fields 1) SignType 2) SignColor 3) Reflectivity (integer).  I am just trying to figure out how to incorporate ranges for different sign types and color into the equation to determine condition based upon the entered integer (reflectivity).  Hope that makes sense!  Any thoughts? ... View more