Close

Our Preferred 5 Star Hosting Provider - Award Winning FileMaker Pro Hosting
Results 1 to 4 of 4
  1. #1
    Forum Member
    Join Date
    Feb 2017
    Posts
    3
    Location
    Southport, Queensland, Australia
    FileMaker Pro Software
    FileMaker 12 Advanced
    OS
    Windows & Mac
    Skill Level
    Intermediate
    Last Post
    02-20-2017
    Local Date
    01-20-2018
    Local Time
    07:34 AM
    Last Active
    02-20-2017

    Do a sequential lookup/calc from a csv list

    This has been driving me nuts for 10 days. I tried. Here is what I want to achieve.

    This shows the list of Zip codes and the Cities serviced filled out manually. A pain in the butt
    Screen Shot 2017-02-12 at 4.29.36 pm.png


    This shows the list of Zip codes and the Cities serviced not filled out, I want to do it programmatically.
    Screen Shot 2017-02-12 at 4.29.57 pm.png

    Any ideas or direction would be welcome.

    I can do a lookup for one zip at a time but from a list..?

    Cheers

    JohnGG

  2. #2
    Senior Moderator - FMT Preferred Developer Consultant - Netherlands, Europe, Asia, USA Maarten Witberg's Avatar
    Join Date
    Mar 2004
    Posts
    6,135
    Location
    netherlands
    FileMaker Pro Software
    version 11, 12, 13, 14, 15
    OS
    Windows & Mac
    Skill Level
    Developer
    Last Post
    06-29-2017
    Local Date
    01-19-2018
    Local Time
    11:34 PM
    Last Active
    12-30-2017
    Assuming you have a table with a list of all zip codes and cities, all you need to do is change the CSV to a return-delimited list and create a multi valued relation between the two.


    Code:
    
    
    Code:
    Set field [ sometable::CSV_zips ; Substitute ( sometable::CSV_zips ; ", " ;  ) ]
    Set Field [ sometable::serviced cities ; substitute ( list ( ziptable::Cities ) ;  ; ", " )
    Stick to what you don't know.

    http://www.maartenwitberg.nl

    Filemaker 15 Certified Developer

    -------

  3. #3
    Forum Member
    Join Date
    Feb 2017
    Posts
    3
    Location
    Southport, Queensland, Australia
    FileMaker Pro Software
    FileMaker 12 Advanced
    OS
    Windows & Mac
    Skill Level
    Intermediate
    Last Post
    02-20-2017
    Local Date
    01-20-2018
    Local Time
    07:34 AM
    Last Active
    02-20-2017
    Thanks Maarten, I will try that and then we will see how accurate my question was.

  4. #4
    Forum Member
    Join Date
    Feb 2017
    Posts
    3
    Location
    Southport, Queensland, Australia
    FileMaker Pro Software
    FileMaker 12 Advanced
    OS
    Windows & Mac
    Skill Level
    Intermediate
    Last Post
    02-20-2017
    Local Date
    01-20-2018
    Local Time
    07:34 AM
    Last Active
    02-20-2017
    Got it Maarten. Thanks. It needed just one relation to work. Now to figure out how to eliminate duplicates.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Relationship-Lookup-Calc Question FMP 10
    By grandhawk in forum Calculations and Define Fields
    Replies: 9
    Last Post: 08-25-2010, 03:14 PM
  2. Auto Update Lookup or Use Calc Field in Relationship
    By lk545 in forum Layouts and Design
    Replies: 2
    Last Post: 07-11-2010, 04:44 PM
  3. Calc field to lookup value from one related record
    By mkohler28 in forum Calculations and Define Fields
    Replies: 4
    Last Post: 10-09-2009, 01:53 PM
  4. Different between Auto Enter Calc and Lookup
    By aaa in forum Calculations and Define Fields
    Replies: 2
    Last Post: 04-25-2005, 10:40 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •