nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Survey123 Custom Text color based on calculation

Michael_VanHatten

I am trying to change the color of a calculated number based on the value that is calculated. I have a series of questions that take in values and give a unique calculation value. I would like that new value to change color based on the numeric value. (Text turns red if number is below 3.0). I cant seem to get a new if statement to work in the "calculation column" of my survey.

Any help would be awesome!

タグ付けされた投稿をもっと見る

Accepted answers

All comments

Michael_VanHatten

Hi Doug, it looks like you got the "please check value" text to change to red. If there no way I can have two calculations for one row? I would like to calculate my value and if it is below 3.0 change it red. Is it not possible to use multiple calculation functions?

Capture.PNG

dougbrowning

Not sure what you posted that is not a valid statement. Unless this is two lines? Your if is unbalanced. Plus you are using a > on a string which is not going to work.

I think you are saying you want the number 3 to change color. You can but I would not because the the html will be in the value. Unless you have a second value to store.

I would use the emojis really. But you can do text also. Few diff ways to do it here.

Hope that helps

Form 1.xlsx

Michael_VanHatten

Thanks Doug,

Here is my calculation code I know the numeric calculation works I just need the text color to change if the value is less than 3.0

(${building_substructure_weighted} * 5 * 0.01), if((${building_average_condition} < "3.0"),"&#9989")

dougbrowning

I do this but use emojis. This how to post may help you get it.

https://community.esri.com/t5/arcgis-survey123-documents/how-to-simulate-instant-data-checking-using-emojis/ta-p/916725

You basically do the calc in a field then use that field in the label column.

You did not post a form or the if statement so pretty hard to trouble shoot it.

Hope that helps

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.