Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 08, 2023 10:37 PM - edited Apr 08, 2023 10:41 PM
Hello,
These presented properties will have a chance to have a different property address linked on this column which is not having any issues.
My main question here is there any way how could I set up, the "current property" will be replaced with the latest property address from the presented properties?
For example.
The first property from the presented properties was 15 Kaye Drive, after a few minutes there will be another property added to the "presented property which is 36 Erronmago Drive.
How can I replace the "current property" with the latest address which is 36 Erronmago Drive?
The main purpose of the "current property" should only have 1 latest property address only.
Hope it is clear and someone could help 🙂
Thank you
Solved! Go to Solution.
Apr 10, 2023 01:31 AM
Hi Imee!! Yes this is doable!
Try creating a new linked field to the properties table called "History" or something. After that, create a formula field that will use `SUBSTITUTE` to help you get the property that was just linked by substituting the "History" text in "Presented Properties" with a blank.
You can then create an automation that will trigger when "Presented Properties" is updated, and its action will be to update the "Current Property" field with the value from the formula field mentioned above, as well as copy the current "Presented Properties" values into the "History" field!
Apr 10, 2023 01:31 AM
Hi Imee!! Yes this is doable!
Try creating a new linked field to the properties table called "History" or something. After that, create a formula field that will use `SUBSTITUTE` to help you get the property that was just linked by substituting the "History" text in "Presented Properties" with a blank.
You can then create an automation that will trigger when "Presented Properties" is updated, and its action will be to update the "Current Property" field with the value from the formula field mentioned above, as well as copy the current "Presented Properties" values into the "History" field!
Apr 11, 2023 03:29 PM
Thank you Adam for helping me out! 👏