Nitrogen (N) is the most important nutrient in coffee, with a direct impact on productivity, quality, and sustainability. N uptake by the roots is dominated by ammonium (NH4+) and nitrates (NO3-), along with some organic forms at a lower proportion. From the perspective of mineral fertilizer, the most common N sources are urea, ammonium (AM), ammonium nitrates (AN), and nitrates; an appropriate understanding of the right balance between N forms in coffee nutrition would contribute to more sustainable coffee production through the better N management of this important crop. The aim of this research was to evaluate the influences of different NH4-N/NO3-N ratios in coffee from a physiological and agronomical perspective, and their interaction with soil water levels. Over a period of 5 years, three trials were conducted under controlled conditions in a greenhouse with different growing media (quartz sand) and organic soil, with and without water stress, while one trial was conducted under field conditions. N forms and water levels directly influence physiological responses in coffee, including photosynthesis (Ps), chlorophyll content, dry biomass accumulation (DW), nutrient uptake, and productivity. In all of the trials, the plants group in soils with N ratios of 50% NH4-N/50% NO3-N, and 25% NH4-N/75% NO3-N showed better responses to water stress, as well as a higher Ps, a higher chlorophyll content, a higher N and cation uptake, higher DW accumulation, and higher productivity. The soil pH was significantly influenced by the N forms: the higher the NO3--N share, the lower the acidification level. The results allow us to conclude that the combination of 50% NH4-N/50% NO3-N and 25% NH4-N/75% NO3-N N forms in coffee improves the resistance capacity of the coffee to water stress, improves productivity, reduces the soil acidification level, and improves ion balance and nutrient uptake.