Hi i have a question that i thought would be straight forward but can’t seem to get.
I have a thing as addresses. In those addresses I have a status (active, deleted, Old) but i have this status as a list to chose from ( so have another table) and in this table i have an attribute to go with this status that i was planning on using to know its the one that i have planed to display in the app.
The quick reason for this is i have users who have many addresses and those addresses might change over time but i do not want to write over the address but rather keep a reference to the old address. What i am trying to do is do a search for to display the current user’s, company’s, active address.
What i’m having a hard part is in the search for option i can not get bubble to let me select the nested field in the linked data field. See image below. I’ve tried to type “current” here one would cick to add the next input but that doesn’t work. I’ve even tried entering the Unique ID for that record in my table and that does not work either.
Here is a visual of my data table showing the status so you can see i’m trying to fetch the address in my table that has the address choice as Current.
I think there should be a way to do this and i’m probably just not looking at it right. Any help would be greatly appreciated.