This is difficult to put into words, so I apologize in advance if I butcher it.
In my app, I’m cross-referencing between our Active section and the Parks section. When a user visits Home > Active > Archery, they are presented with info about archery but also a list of parks from our Parks section that have this feature (in this case, archery). I’ve got these 1:1 relationships working without issue—both ADA Accessibility and Archery work as intended.
However when I get to Active > Baseball, I run into trouble. For Baseball, I need to combine two similar park features into a single inline list under Active. For example, for Active > Baseball I need to display all the parks with the feature “baseball field” and “baseball field (lighted)” from the Parks sheet and I don’t know how to write that relational formula? FYI, the parks listed right now under Active > Baseball are only baseball fields and don’t include the parks with lighted baseball fields. I need to combine these.
As you can see in my database, I’m using the following cell formula to complete the multiple relation for Archery:
Parks with Archery=Parks:archery:Multiple
Is there a different way to write this formula with some syntax to achieve what I need like:
Parks with Baseball=Parks:baseball field&baseball field (lighted):Multiple
Here’s a link to my app and a separate link to the database. Thank you in advance for any assistance…much appreciated!