Color coded answers from same list
are you talking about displaying these color coded items in a list in the dashboard? You can use arcade in the advanced formatting section of the list configuration to do this probably. Here's some arcade I have that colors inspections by the number of days since a location was visited - red for over 100, orange for 60-100 days, and green for under 60 days, and a screen shot of what the list looks like. I don't know if tables offer the same kind of formatting though since I haven't worked with them.
// calculates the number of days since a location has been inspected, if greater than 100 days then the background turns Red
var daysSince = round(DateDiff(Today(), $datapoint.LastInsp,'days'))
// var alert = 100
var bkgrnd = When(
daysSince > 100,'#FF7f7f',
daysSince >= 60 && daysSince <=100,'#ffb461',
'#8efc8d')
//var nextVis = $datapoint.nextVisit
var vistTxt = IIF($datapoint.nextVisit > 0,'Next visit is scheduled for' ,'No additonal visits have been secheduled at this time.')
var visDays = round(DateDiff($datapoint.nextVisit, Today(),'days'))
var daysTxt = IIF(visDays > 0, 'in ' + visDays + ' days','')
return {
textColor: '',
backgroundColor: bkgrnd,
separatorColor:'',
selectionColor: '',
selectionTextColor: '',
attributes: {
numDays: daysSince,
schedVis: vistTxt,
schedDays: daysTxt,
}
}
I was hoping to be able to have the Survey123 automatically change the color based on the answer, was hoping I could input a command that would take the fields ie, c2:c26... it would be way to tedious to list every answer. I could do a list and have specific fields have a color, but my dilemma goes back to the Survey, I am trying to only have one field to capture all the responses... my experience has been the more fields you offer the more confusion on the inputters. I think what i might end up having to do is add a (T)=Trail, (R)=Route, (P)=Path to the end of each name, so that it shows up on the answer Red (T), Blue (T), Wing (R), Bird (R).... It is more for quick reference to identify what the patroller is doing, if they list a (P) answer, they were most likely doing some sort of preventative avalanche mitigation and the Lead would want to pay more attention to that then a (T) answer which is just general work.... Its just that color helps the answer to stand out... I am trying to avoid having three different dashboards and being able to look at one and see all activity.. In the pic , below the SS Run Out would be changed to Run - Path - Route, and the responses would be color coded...
You'll want to explore using the choice lists capabilities of survey123 - the first link that was posted will help explain how it works. This allows you to specify which options populate in your question based on how you responded in a previous question - you end up having to add a field to your xlsx that tells s123 which options are valid given a certain response elsewhere. Its pretty slick really. In the screen shots you can see that the options available in the 'Determination' field depend on the type of Inspection that is selected.
Yes, that is how the Choice Filters operate. You can find a choice filters sample survey (and many others) in the samples option of Connect. This is a great resource for seeing how some of the more advanced capabilities are used in real surveys.
