How to create a constant numeric field?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I want to calculate the travel time by going this :
Number of Miles / 65mi/hr = xxx

'The Number of Miles' Field ist a numeric field which gives me a distance/ We calculate the travel time by car with a constant value of 65 mi/hr .
It is not possible just to write down that value in the formula field. Is there any possibility to save a number in a field? Thank you!
Photo of Dilan

Dilan

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,806 Points 50k badge 2x thumb
The formula for time would be

[Number of Miles] / 65

If for some reason you want to have a field always calculate to the value 65, then the formula is simply

65