Jump to content
Sign in to follow this  
Lizzy

solutions wanted Multiple addresses

Recommended Posts

Wondering if someone could point me in the right direction of keeping a list of addresses that my contacts have lived at. I've looked at some of the starter solutions, but they only allow for second addresses, or a business and a home address etc...

I import from excel as information is given to me, and would like to import it, have FMP find the contact, if their address in the excel spreadsheet is not the same as their existing address in our database then have FMP add the new address as a new record in a addresses table, which is linked via their ContactID...

Many thanks in advance...

:

Share this post


Link to post
Share on other sites

Easiest way would be to store addresses in a separate table, but use calc fields in the Contacts table to pull in the details from the last related address record (the rationale being that the last related record would be the newest).

Share this post


Link to post
Share on other sites

Thanks for the quick reply...

I was thinking of something along those lines for the displaying of the address in the contacts layout, but the solution I need for now is how to import multiple excel spreadsheets, so it creates records in the addresses table (but not dup's of the contact names). And then using calc's to filter the most recent address, dependent on a date field.

I've about 200 spreadsheets to import...

Sorry, my original post wasn't so clear... I'm working on an Events Database, and if we can track where people have lived, we can target them specifically in Marketing for eg: if an event in Melbourne is not full, we can email all contacts who have lived in Melbourne, and let them know there are available places... Even if a contact has moved to Sydney...

I'm thinking along these lines... Creating an Address book database that shows all our contacts, and where they have lived, and then all the addresses and who has lived there... This database is not for the end user, its just storage and related data.

In the Events database, we show the most recent address dependent on the date of the last event they attended (this way we are sure to know their address is most up to date)...

Thanks again...

Share this post


Link to post
Share on other sites

Hi Lizzy,

I am from Dunsborough - Western Australia. I would like to help you. If its ok for you send me all the spreadsheets and I will convert it in database and will send it to you.

Tusif Ahmad

Share this post


Link to post
Share on other sites

Thanks Tusif, I'm not sure the company this is for would allow that the contact lists be passed onto a third party, but I can certainly check into that some more.

I'm really just looking for assistance on the script steps, if you could help with that it would be much appreciated.

Anyway, post back your email if it's not on your profile and i'll send direct if you are interested in helping out there...

Thanks again,

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Similar Content

    • By omnia
      I am a canadian and I work with fmpAdvanced.
      if you find a solution, I'd appreciate you contacting me.
      <reply by private topic>
      I am looking at a solution for inventory.  One important request is that they need to be able to calculate the inventory for previous dates.  E.g. the beginning of the quarter compared to today or this day last year.
      My thoughts so far to be able to do this is to have an article file and a stock movements file, all values and quantities of stock will be held in the movements file.  Basically the last related record will be in the movements table will be current value, but we can also find the last related related record based on any date. 
      Will this be a fast way to calculate or slow?  I don't want to start and then find things slow down on me too much.
      After this I will also need to be able to age the stock.  
    • By wedgeman
      We are working with a medical non-profit working in Latin America, running on much older hardware.  Seeking older individual or group/site license seats of FMP & FMS 13, 14, or 15.
      We need a bunch.  We could buy site license seats, or simple 1-off licenses.   
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.