The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Hello AT FamilyTable: Properties (is our base table with all of our info)Table: Mortgagehas all mortgage info pertaining to each property in Properties TableThe main statuses in this table is "Yes, No, Refinancing"Note: some properties in this table ...
We interact with multiple Utility Companies (Water, Electric, Gas from different cities and counties).Is it possible that when I select a Utility company, the contact information auto populates in another field (Separate Single Line Text Fields or a ...
I fixed it. I had to create a formula in the Mortgage TableIF({Status} = "Yes", {Lender}, "")IF({Status} = "Yes", {Loan #}, "")Then I looked up these columns in Properties Table.Finally, I pulled this info into the Insurance Table from the Properties...
See screenshot attached.There are a couple of properties that have an old mortgage, and that status is now NO. So I don't care to see the lender for the NO status. Those few properties now have an active mortgage, and I just want to see the Lender ...