Latest Contributions by GaryBowles1

I am trying to use nested if statements to color code the instance name in the Inbox. I have 4 cases that I need to check for: CASE 1 - No Leak If(string-length(${leak_id} = 0), concat('<font color="green"><b>', ${location_name}, '</b>', '</font>'), '') CASE 2 - Leak Found and Not Repaired If(string-length(${leak_id} > 0) and string-length(${leak_repair_date}=0), concat('<font color="red"><b>', ${location_name}, ‘ – NEEDS REPAIR’,'</b>', '</font>'), '') CASE 3 - Leak Repaired and Not Re-Checked If(string-length(${leak_id}>0) and string-length(${leak_repair_date}>0) and string-length(leak_recheck_date}=0), concat('<font color="orange"><b>', ${location_name}, ‘ – NEEDS RE-CHECK’,'</b>', '</font>'), '') CASE 4 - Leak Repaired and Re-Checked If(string-length(${leak_id}>0) and string-length(${leak_repair_date}>0) and string-length(leak_recheck_date}>0), concat('<font color="blue"><b>', ${location_name}, ‘ – LEAK REPAIRED & RE-CHECKED’,'</b>', '</font>'),'')   So, putting this all together gives me: If(string-length(${leak_id}=0) , concat('<font color="green"><b>', ${location_name}, '</b>', '</font>'), If(string-length(${leak_id}>0) and string-length(${leak_repair_date} =0), concat('<font color="red"><b>', ${location_name}, ‘ – NEEDS REPAIR’,'</b>', '</font>'), If(string-length(${leak_id}>0) and string-length(${leak_repair_date} >0) and string-length(leak_recheck_date=0), concat('<font color="orange"><b>', ${location_name}, ‘ – NEEDS RE-CHECK’,'</b>', '</font>'), If(string-length(${leak_id}>0) and string-length(${leak_repair_date} >0) and string-length(leak_recheck_date}>0) ,concat('<font color="blue"><b>', ${location_name}, ‘ – LEAK REPAIRED & RE-CHECKED’,'</b>', '</font>', ‘’))))) Can I use nested if/then for instance name and if yes, what am I missing?? Thanks, --gary ... View more

We have a case where the Inbox will be used to update existing surveys (repairs to equipment) and also for a re-check survey. Would it be possible to have 2 Inboxes where each one would have a different Inbox Query to show only Repairs Needed in one Inbox and Re-Checks in the second. Also, being able to re-name the Inbox would be ideal for this. Thanks, --gary ... View more

Not sure if this is a Survey123 issue or a general esri issue or an OS issue but when we have a text field in a survey and someone enters a character ie. ", it looks fine in the survey, but when we pull this info into an email notification via GeoEvent Server, the character looks like �. What is the cause of this? Is there a way to prevent this from happening?  Thanks, --gary ... View more

We have a Survey embedded in a dashboard where the user can update an existing survey or add a new survey. In both cases, when the survey data is uploaded the created_user or last-edited_user does not grab the username from Portal but populates with Esri_anonymous. Is this expected behavior? I would like to have S123 grab the actual username of the person logged into Enterprise and updating/creating the survey. Thanks, --gary ... View more

I have a dashboard that contains an embedded S123 form. When a data record is selected on the dashboard, the S123 form displays the proper data except for one field (see attached). The field is a text field with the following inputMask >AAA to force 3 capital letters. Other fields with inputMask set are working. Ideas? Thanks, --gary ... View more

I have a dashboard that contains an embedded S123 form. When a data record is selected on the dashboard, the S123 displays the proper data except for one text field (see attached). The field is a text field with the following inputMask >AAA to force 3 capital letters. Other fields with inputMask set are working. Ideas? Thanks, --gary ... View more