So I have a drop down cell and I want to set it so that if a user picks option A or option B from the drop down, Glide will set other certain cells to empty if it has data in it (three of them). Any other option selection wont touch the other cells.
At first I though it would be an if then else, but I can’t see how to use if then else to change a specific cell. Anyone care to point me in the right direction for investigation so I can work out what I’m suppose to do? Thanks so much in advance 
That’s not possible with a choice component (drop down), because it doesn’t support actions.
You either need to use some other type of component (probably a collection), or a series of if-then-else columns.
Hmmm… ok… I will see if I can work it out. Dang I was hoping this one would be an easy one! 
The drop down selection is from its own table. There is no way in the status table (because it is the status drop down I’m referring) to say that any cat that has the status of something other than “adopted” or “trial period”, make the following three fields blank: Adopted Date, Adopted By, Adopted Name
I assume you have a Status column in your Cats table?
Using if-then-else columns, you would do something like:
And then use the ifAdoptedDate column in place of the Adopted Date column.
And do the same for Adopted By and Adopted Name.
It doesn’t clear the columns, but that doesn’t really matter.
So the goal is that if a trial period fails and the cat is returned, becomes available again, then the adopted date, person and name is cleared. It’s only happened once but flagged the error to me. In all honesty I could just manually reset them given if very rarely happens. Maybe once a year. I was just curious but I’m going to save my brain for the other stuff I need to work out
But I will play around with that once I get the other stuff sorted. So thanks for showing concept.