Dependent Dropdown not working in desktop mode and chat app

R_J
Bronze 3
Bronze 3

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

R_J_0-1713404944093.png     

Desktop mode

R_J_1-1713405102377.png

Chat App

R_J_2-1713405178658.png

 

 

Solved Solved
0 6 87
1 ACCEPTED SOLUTION

R_J
Bronze 3
Bronze 3

I found the answer.  Unfortunately Valid_If is not supported in chat apps. 

Source: http://www.google.com/url?sa=D&q=https%3A%2F%2Fsupport.google.com%2Fappsheet%2Fanswer%2F14102086%3Fh...

View solution in original post

6 REPLIES 6

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 DropdownR_J_0-1713447258688.png

Site Dropdown R_J_1-1713447641999.png

 

 

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 - DESKTOPR_J_0-1713452077821.png

NOT WORKING - CHAT APP R_J_1-1713452153882.png

 

 

R_J
Bronze 3
Bronze 3

I found the answer.  Unfortunately Valid_If is not supported in chat apps. 

Source: http://www.google.com/url?sa=D&q=https%3A%2F%2Fsupport.google.com%2Fappsheet%2Fanswer%2F14102086%3Fh...

Yes that's actually true. Sorry.. I didn't thought about that when the dropdown was not working with the desktop either.

Top Labels in this Space