I have a text label that uses a formula to show the difference between two other field values in real-time.
The calculation is working correctly, but I have these two concerns:
- When I scroll vertically, this new text label stays put while the rest of the form scrolls normally. So it lines up when I start out, but when I scroll the form, it's out of sync with the rest of the form. How do I keep it behaving like the rest of the form?
- Originally, I had created a calculated field in SharePoint, but the format wasn't showing properly in the form. Plus, it would not show the difference in real-time for the user. As a work-around, I made the original field hidden and put this new text label on top of it. Is this good practice or am I setting myself up for disappointment down the road?
