Pull/Lookup data from general list into module with numbered list

Options
taqyyudin
taqyyudin Member, ALL USERS, Community Member Posts: 5 New Contributor
in Planning & Modeling

Dear All,

 

Appreciate if anyone can help me on this.

 

How to pull/lookup data (properties data of Total Area sqf) from a specific general list (Detail Project Component list) into a module (Master Tenancy List) that contained a numbered list with parent hierarchy is Detail Project Component?

 

If not using numbered list, yes it can be done easily.

 

Outcome i need is that when i add new tenant in specific unit lot, information of total area of the unit lot will automatically pulled from the general list.

 

image.pngimage.pngimage.pngimage.png

Tagged:

Comments

  • taqyyudin
    taqyyudin Member, ALL USERS, Community Member Posts: 5 New Contributor

    Hi Hayk,

     

    Thank you very much for your suggestion.

     

    Based on the picture attached hope can you suggest which list item should be *your_numbered_list*

    • write a formula Parent(Item(*your_numbered_list*)

    I tried some list but could not work.

     

    image.pngimage.png

  • taqyyudin
    taqyyudin Member, ALL USERS, Community Member Posts: 5 New Contributor

    Invalid formula popup
    image.png

  • taqyyudin
    taqyyudin Member, ALL USERS, Community Member Posts: 5 New Contributor

    Yeyy.. it work.. Thanks a lot Hayk.

     

    image.png

Categories