I’ve been doing some more filterByFormula research and found some things that might be helpful for the Adalo engineers to know.
FilterByFormula works when I manually enter text, but not when I pull magic/dynamic text from the Adalo user base. Here’s an example. What’s shown in the image does not work (even with quotes around the red magic/dynamic text), but if I manually type “Group:Food & Ag Services” where the red magic/dynamic text is, then it works.
It also works with the form input component, but in this case that is not the right data source for this application. I need to be able to pull the data dynamically from the Adalo user collection in the internal database.