How to set a chosen entry of a field from link1 as a filter to link2?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ctheuring
    Senior Member
    • Oct 2022
    • 138

    How to set a chosen entry of a field from link1 as a filter to link2?

    When I choose an entry of link1 - which attribute.name does it have BEVORE I save the record, so that I can use it as a (dynamic) filter of link2-entries?
    Example for better understanding:
    Link1 is a list of countries, link2 is a list of cities and link3 is a list of streets. link1 has a 1:n relation to link2 and link2 to has a 1:n relation to link3
    During create a record, I chose "Germany" from the view-list of link1 - then I want to filter the view-list of link2 ONLY to the cities in Germany ... and chose "Berlin" - and then I want to filter the view-list of link3 ONLY to the streets in "Berlin".
    How to do it?
    Thanks for help

    Christoph
  • shalmaxb
    Senior Member
    • Mar 2015
    • 1606

    #2
    similar problem had been discussed here: https://forum.espocrm.com/forum/gene...tional-options

    Only problem, seems not to be applicable for newer versions of espoCRM.

    Comment

    • ThomasB
      Senior Member
      • Mar 2022
      • 163

      #3
      Look at the manual: https://docs.espocrm.com/development...ic-multi-enum/

      But if you really want to filter all countries, citys and streets this would require lots of coding and data. And you need to keep it updated. Streets get added or renamed...

      Guess, what you want it an addess lookup service. Something like this: https://developers.google.com/maps/d...ation/overview

      But no clue how to add this.


      Comment

      • ctheuring
        Senior Member
        • Oct 2022
        • 138

        #4
        Hello ThomasB,
        the example with country, cities and streets is only a popular example for understanding my aim.
        In my application it is a chain of producer, series and type of tool-machines like machining-centers -> this could be handed :-)
        I will try the method of your link - this could be the solution I have looking for - thanks.

        Christoph

        Comment

        Working...