Can someone please help me understand what I am doing wrong? I have been banging my head against this for an hour.
I have a table in my DB which is a list of things:
This isn’t an option for me because I need to return the name field by filtering based on the id field and the above filters the name filed based on the name field.
This seems like it should be so simple. Any help would be much appreciated.
You are going about it in the wrong way. Apple pie, Banana cake, etc. should each be their own entry in your database, each with their corresponding ID.
As you have it now, you have 1 entry and the “name” of that entry is
So yes, if you ask for the “name” you’ll get the above list back.
Thanks for your response but there’s a reason I can’t do what you’re saying. My list of things is populated from an api call and I tried for days to get each elemnt of the api json reponse to save into it’s own record in the DB but bubble doesn’t seem to allow that. So I am stuck with a list of things that I now need to filter.
Unfortunately there doesn’t seem to be a way. I was in contact with the bubble team and they said this is the way I need to store my API response given that my API response has 50 records in it and the rate limiting of the DB writing function that bubble offers will max out well before the 50 records get written.
I have looked at that before but that is through the feature of scheduled workflows. Even on the most high level plans, you only get 1 daily workflow. I have an API call for every single user. As I get more and more users, that could be 1,000’s per day
Paul, I am not an expert on APIs either but I don’t see a way to accomplish what you want, given the way you are storing the data. It is not a bubble limitation but rather the way the API is being parsed. You might need to explore a different format to the API result as it lands in Bubble.