Skip to main content
New

Support formatting on calculations

Related products:Inspections
  • January 13, 2025
  • 1 reply
  • 23 views
N CAZE
  • N CAZE
    N CAZE

Stuart Middleton

It’s frustrating that we can’t perform simple formatting on calculations, such as displaying units or restricting the number of decimal places.

 

The above comment is a full description of what I’d like to see changed, but I thought that it might be interesting to hear the use case that prompted it.

We have a data collection form (inspection) where we apply some in-form validation checks. This will be something like “sum of answers A, B, C must be less than or equal to D”. We then apply logic where if D-(A+B+C) <0, then display information (question) indicating that the user has entered the data incorrectly.

From a presentation perspective, we don’t actually care to display the value - just whether it’s a pass or fail. The ideal option would be that a calculation supported conditional logic and different output data types (e.g. if x=y then “Pass”, else “Fail”). This could be complicated for SafetyCulture to program, so a simpler alternative would just be to make the resulting number less obtrusive; e.g. set the text colour to white; make it so the value isn’t ridiculously long compared to other numbers (1.3333333333 when everything around it is two decimal places); etc.

1 reply

WhiteRabbitPizzaLtd.

This is frustrating, but it is still a recently added feature. Hopefully in time we will see some updates, I’ve been wanting calculations for a long time, and before that the units to really segregate data captured and for ease of user accessibility. Fingers crossed we will continue to be pleasantly surprised! 

Working in food manufacturing we have critical limits and regular checks, if the software can calculate, flag and add logic to the results, it would greatly reduce the work needed for data capture and allow live actioning. 

Hopefully the team see this! Keep the useful stuff coming!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings