i have created field(numeric percent field)

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • Answered
i have created field(numeric percent field) if i enter more then 100 in that field,i want show error message how to do this can help me
Photo of venky eshavar

venky eshavar

  • 120 Points 100 badge 2x thumb

Posted 6 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 52,786 Points 50k badge 2x thumb
You can make a new Formula Rich Text field.

IF([my perecentage field name goes here] > 1, "Percentage must be less than 100%")
Photo of venky eshavar

venky eshavar

  • 120 Points 100 badge 2x thumb
i enter more then 100 in one numeric percentage field,here error message is showing in rich text field. i want show error message in same field(where i enter more then 100 that field) 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,786 Points 50k badge 2x thumb
That cannot be done natively.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 27,694 Points 20k badge 2x thumb
This is the essential code:

$("#_fid_6").on("change", function() {
  if (_fid_6.value > 100) {
    alert("Please enter a value less than 100");
  } else if (_fid_6.value < 0) {
    alert("Please enter a value greater than 0");
  }
});