Prompting message show if criteria does not work when the targeted column has suggested value

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.

Violet_1-1664423555765.png

Violet_0-1664423497499.png

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 Solved
0 7 210
1 ACCEPTED 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!

View solution in original post

7 REPLIES 7
Top Labels in this Space