Based on the number of units in a project, create new property records?

Question

Hi,When I type it out, it seems simple but I can't figure it out.Background: I work for a real estate company where we often take on projects that have multiple units on the same area of land- think of townhomes.If I'm in a project record with "Units= X", I'd like to create X number of new property records in the properties table. I'm trying to achieve this with a pipeline, but I can't figure out how to iterate through a loop X number of times based on the value of a record.&nbsp;Please help! Thank you in advance!------------------------------Karah Weber------------------------------

johncrosland · Answer

Good morning,You can create a Unit Count field, and then you can create a Pipeline that will duplicate that Property as long as the Unit Count is greater than 1. This should be triggered based off of On New Event and triggered off of the Unit Count Field. You create the new unit with a Unit Count of 1, and then you update the original to be -1 using {{a.unit_count - 1}}.Good Luck!John------------------------------John Crosland------------------------------

karahweber · Answer

That worked!! Thank you so much John!------------------------------Karah Weber------------------------------

Forum Discussion

Based on the number of units in a project, create new property records?

2 Replies