In a list or report, replace a field with certain conditions with another field
I am setting up a list of with students and their current schools. When providing their information they have a list of feeder schools to pick from. This list also has the choices of "N/A" or "Other. If the student picks "other" as the school another field opens up and they have the option of writing in a school not on our list. In the list/report I would like a script that says:
If "other" is the chosen from the feeder school list insert the information from the other field.
I don't know if they makes sense please contact me and I will give more info.