Help

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.

Selecting the right property based on FIND record?

Topic Labels: Automations
394 0
cancel
Showing results for 
Search instead for 
Did you mean: 
krtphr
6 - Interface Innovator
6 - Interface Innovator

Hello all, 

I have a tenant directory showcasing all units and properties. I have 2 locations with the same unit # but different buildings. I've created a separate column to distinguish the buildings and their identical units. Here's an example:

Building #1

krtphr_0-1704998842994.png

Building #2

krtphr_1-1704998892589.png

As you can see, both buildings have the same unit numbering, the only thing separating them are the buildings. I have an automation to find the respective record, and place that record to the corresponding property - however when it's entered - it keeps going to address "54321 N Ave" unit 201 record instead of the "1234 N Ave" unit 201's record. Here's my automation:

krtphr_2-1704999274743.pngkrtphr_3-1704999297148.png

krtphr_4-1704999318933.png

My Tenant Onboarding table:

 

krtphr_6-1704999423204.png

Align 'Building Four' with the address '54321 N Ave,' and if 'Building 1' is chosen with the identical unit number as Building 4, it should correspond to '1234 N Ave.'

Briefly, I have two buildings sharing the same unit number, and I want the unit number to be correctly associated with its respective building. However, when I input the entries, it consistently directs to the wrong building despite the specified address. Thank you all.

 

 

0 Replies 0