I'm using the Valid_If method and have used this method a few times in other apps with success, but it doesn't seem to be working this time around and I can't figure out why. What's weird is in the console it appears as though it's working, but when viewed in desktop mode or chat, it's not. Can anyone shed some light on what the issue could be? I'm looking at the database and expression of my other apps side by side and nothing odds seems to standout , so I'm very puzzled why I'm experiencing this issue.
AppSheet console
Desktop mode
Chat App
Solved! Go to Solution.
I found the answer. Unfortunately Valid_If is not supported in chat apps.
What is your formula in Valid_If? Are you sure the desktop is using the same latest app version?
Hello @AleksiAlkio ,
The formulas I'm using are in the images below. I use the exact same formula in another app and it is working there. Both apps are referencing the same spreadsheet and table and their schemas are setup exactly the same so I don't understand why one works and the other doesn't. In regards to the latest version, I open the desktop view from the console so I can only assume what it opening in a new tab is the latest version.
Region Dropdown
Site Dropdown
I made a quick test with the same setup, and for me it's working just fine with mobile and desktop.
Thanks for the update, @AleksiAlkio . I had moved on to something else and when I checked back moments ago before seeing your response, I noticed it was working correctly on desktop. Really weird!
However, it still doesn't work when the form is accessed via chat. This is my first time working with Chat Apps, so I'm not sure if this is supposed to work or not. During my search for answers, I have yet to come across anything that indicates it doesn't work.
WORKING - DESKTOP
NOT WORKING - CHAT APP
I found the answer. Unfortunately Valid_If is not supported in chat apps.
Yes that's actually true. Sorry.. I didn't thought about that when the dropdown was not working with the desktop either.
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |