Query regarding dynamic lists

Ask for Help
1

Hi all

Firstly, I’m a complete newbie to everything here. Never coded, new to databases and new to front ends.

I volunteer for a small NFP charity that rescues cats. We presently have our data stored in google sheets which is fine for a couple of us but we would like foster carers to be able to update the database so want to make a front end. I’m looking at Glide as a no-code solution but I’m wondering if it will actually work.

Essentially we have three tables - cats, people, medical. Cats is a list of all the cats, people is a list of all the people and their various roles, and medical is a list of all the medical actions taken for each cat.

Presently our google sheets has drop down lists in the tables which are populated by filtered data from the other sheets. For example, in Medical, we have a Practitioner field which is populated as a drop down comprising of the People list BUT filtered to only show those people set as Vets or Foster Carers. Also in Medical, there is a drop down list of every cat name (all which are unique). We potentially may want to filter this to exclude deceased or adopted cats - not sure yet. And in Cats, we have a field showing the current Foster Carer, which is a drop down populated again from the People list BUT filtered to only show those people that have a type of Foster Carer. That’s just some examples.

I imported the google sheets into Glide but it seems all the formulas are stripped meaning the sheets can no longer create dynamic drop down lists.

So my question is two fold. First, how do I create a drop down list and, secondly and most importantly, how do I make the drop down list dynamic based on filtered data from a particular sheet?

As said, I am a newbie. I have limited Excel/Google Sheet knowledge but everything else is brand new to me.

2

Glide can certainly do everything you’ve outlined, but before diving into it you should first determine whether or not it will be a cost effective solution for you.

As you’re a charity organisation I’d guess that you don’t have a big budget for something like this. Assuming that you have more than 10 users (the maximum allowed on the Free plan), you will need a Maker Plan, which starts at US$49 per month.

So - is that within your budget?

If it is, then yep, most certainly Glide should work.
If it isn’t, you probably should look elsewhere.

Normally you would use a Choice component for this.

Choice components can have conditional filters applied.

See also: Glide Pricing | No Code App Builder for Teams & Businesses

1 Like
3

Thanks Darren. I’m hoping to stay within the ten user limit so can keep using the free plan :smiley_cat: We are only a small charity so I’m hoping we can do that.

I will see if I can work out how to make the Choices option work. Thanks so much for the fast response.

4

Okay, no worries.

Feel free to come back if you get stuck. If you do, a couple of screen shots that show how your data is structured will be useful.

5

Wonderful. Will do. Thank you again!

6

OMG That works and it is so easy when you showed me where to look! Thank you so much! I will have more questions about other things but I will post new questions. Wow! Thank you! :heart: :smiley_cat:

2 Likes