I have a Text message displaying on the form when a selected course has reached it's capacity.
The selected course column is refering the course database which stores course Name and Term & whether it has available spot or not.
It's working as intended when there's no suggested values.
The problem is,
when I limit the suggested value of the selected course to Term 4 in the database, the text message prompting won't work properly. It's just keep displaying itself no matter what I choose in the selected course.
My guess it that the suggested value works as prefilled data disregarding the selected course is a single-selection value. Here's the formula that I put in the show if part of the Text message.
Can anybody point me a way that I could have my suggested value set-up and this prompting message working at the same time?
Thank you for your time.
Solved! Go to Solution.
I have this working now!
Thank you for the idea @jyothis_m .
I changed the suggested value in the Course_Selection column to make sure that they yeild the ID of the course not other parts of the Course database. And then the Capacity Text is working properly now!
User | Count |
---|---|
25 | |
15 | |
4 | |
3 | |
3 |