We are currently using dedupe to identify duplicates in our records.Since our records is growing, we need to do it in automated way everytime there's a new record coming in.Here's the scenario:When a new property address will be added, there should b...
Automation set up was.Step 1: When a record matches a condition.Step 2: It will update a field which is the "Client Portfolio Record" (this is a linked to another record field to a view called Client Portfolio)This automation was just working fine be...
I have these two fields Formula on Contract Yield % is this:({Contract Rent PW}*52)/{Purchase Price}I need to replace the formula in the Contract Yield, to an IF formula.More likely:When the result on Contract Yield is 0%, If Contract yield = above...
On this view,I need to create groupings based on the Max Price and Listing Price.The amount should match, but when I tried to do the grouping it did not show the correct numbers.here's the current setup. Here's the outcome.The Max Price Should be $2...
Hello, Can someone help me if this is possible or not?You may watch this loom for more information.So we have this view called "HitList" which came from the sheet of "Client Briefs" This hitlist has our client list that is waiting for some properties...
Hello, @TheTimeSavingCo thank you for this, but when I tried setting it up based on your linked base.It would tag all of the recorded entries as duplicates even if it's not.Here's a short recording for you to show.Thank you.
Thank you Kuovonne, Yes it really worked!By any chance can you tell me what will be the long formula if we will put it all in one formula please?We just really need to maintain the one field.
@Arthur_Tutt you've been incredibly helpful! The "filter" feature was already in place, so there was no need for me to do it.The adjustments you made to the script were spot on! Immense gratitude for your assistance! You truly turned my day around...
