Hi community,
I've been hung up over over this for some time now, but haven't been able to figure it out, so finally thought of asking the community, hoping someone would've come across this already.
I have two fields in a form: Total Marks and Letter Grade. Both are essentially Text Fields. Is there any way to automatically change the value in the Letter Grade field based on the entry in the Total Marks field? For example, if the Total marks value is equal to or more than 80, then the letter grade needs to be A. If the total marks value is less than 80 but equal to or more than 60, then it needs to B.
Thanking you in advance for your kind help/suggestions/inputs in the right direction.
Warm regards,
Finny
I'm not sure what "essentially text fields" means, but I don't see a way you can do this with native features. You can solve it with just a few lines of JavaScript if you're so inclined.
Hi Rob. I assumed that I would need a bit of Javascript to get this done. "Essentially text fields" was my (convoluted) way of saying it could be a single-line text field, or a number or a calculated field.
Thanks for chiming in. Will now look to JS for this.
Please login or Register to submit your answer