Jump to content

asterix

Members
  • Content count

    10
  • Joined

  • Last visited

Community Reputation

0 Neutral

About asterix

  • Rank
    novice

Profile Information

  • Gender
    Male

FileMaker Experience

  • Skill Level
    Novice
  • FM Application
    12 Advanced

Platform Environment

  • OS Platform
    Windows
  1. Thanks for your suggestion Steve. I made my acquaintance with those Mapping and Geolocation functions last week while I was searching the internet in hop to find a solution to my problem. No doubt, they are excellent, but are not what I need. The ideal solution for me (and hop) is, someone to have a look at my uploaded file (DEMO_LocalitiesGoogleMap.fmp12), figure out why the Gmap is not displayed when the Lat./Lgn. lines are crossing each other over sea, and make it work, possibly by modifeing the html text, or something else. It's of paramount importance for me the fuction to basicaly remain the same as is in my DEMO file. That is; 1) one point plot, satellite and map view, 2) the map is zoomable, and draggable to all direction, 3) the web viewer (map) opens in seperate layout.
  2. Thank you Steve! What I want exactly is the same kind of map as shown in the Demo. (a map that by use the of mouse, can be zoomed in and out, and be moved to all directions)
  3. Steve, Yes, this is a very small sample to demonstrate my issue. The html and the zoom are in a separate table "Global_Settings" for a reason (I have quit few other global settings (not included in the Demo I uploaded) and it is convenient to have them all in one table.. My database contains a lot of records, many with full physical address with lat/long, others only Country and state, and many lat/long records pointing at a specific locality over a given sea, i.e. Atlantic ocean, Pacific ocean, Mediterranean sea and etc. The latter is my issue, Google Maps won't display them. I don't know why.
  4. Hello, I am running FM12 Advanced (Windows), and I have a small issue regarding geocoding with Google Maps (simple marker). My FM-database contenins many different location records, and a fuction to call the layout with the Web-viewer and geocode/mark the location on Google Maps. The problem is that although there are coordinates (Lat / Lgn), GoogleMaps does not display the map when the coordinates (Lat / Lgn) are crossed somewhere over sea area, for example, the Atlantic Ocean, Mediterranean sea, and so forth. The problem is best illustrated on the attached demo DB (DEMO_LocalitiesGoogleMap.fmp12) which contains three locality records: 1) United Kingdom, London, 21 Picadilly str. 2) Turkey, Antalya, Latitude: 36,808, Longitude: 31,762 3) Atlantic Ocean, Latitude: 50.66, Longitude: -28.59 With records 1 and 2, there is no problem mapping the location on Google Maps, while the same does not happen with record 3. Any help to solve the mystery is greatly appreciated. DEMO_LocalitiesGoogleMap.fmp12
  5. Duplicate record X times

    Dear LaRetta, Thank you, that is exactly what I needed. The RegNumber is a primary key that binds relationships to others tables and fuktions. A “global” disaster can happen if I am not careful. I will test and retest the Duploop script in a copy Database before I make any final dicition. I may or may not use the loop, but it gets me moving. Thank you again Is only to be used (as you correctly mention) on an unsorted set, on the last entered/existing number and only the admin can use the loop. If it works as I imagine, it will be a very helpful fuktions, sometimes we have to duplicate quite a few records with partly the same values. Very time consuming.
  6. Duplicate record X times

    I suppose You're right, Full control is an exaggeration. Thank you for your concern, advice and warning. I appreciated Of various reasons The “RegNumber” cannot be changed to Auto-generate serials. The “multidublication” function is only to be used (if needed) in combination with a new record creation. The numbers I am using are unique. No one is in possession of the same RegNumbers, Therefore, it is very unlikely that too persons to punch in the same number at the same time, but yes, it can happen by accident or bad luck. What will be the consequences if it happens? Do you know? Is it possible to construct a script that takes such a conflict situation in consideration? If the only bad thing that happens is the script to stops, that is OK with me.
  7. Duplicate record X times

    The RegNumber is NOT auto-enter serial. It is a series of numbers of my making, regarding the uniqueness of those numbers I have full control over.
  8. Hi, I have a FM database with one table with 28 columns. The first field is named: “RegNumber” which requires a unique value, in my case, something like: nsza001001 I create a new record, let’s say, RegNumber: nsza001001, the remaining fields are filled with other values. Now, I would like to duplicate the above new record an X amount of times, 5, 10, 15, whatever. What I need is this: 1) A field where I can type the amount of duplicates I would like to make. 2) A script I can trigger, that can duplicate the new record the amount of times I need, at the same time increment the unique “RegNumber” of the original record by 1, and assign the incremented numbers e.g. nsza001002, nsza001003 etcetera, to the duplicates. Any help would be appreciated :(
  9. Filtered Value list names

    Dear James and LaRetta, Fantastic! I didn’t expect an answer so quickly. Thank you very much. I also prefer your suggestion LaRetta, it is very simple (like Columbus egg) and easy to understand. Thanks I thousand times. :smile2:
  10. Filtered Value list names

    Hi, I have a FM database with one table with 28 columns. 4 of those are for Location Information. That is: Country Region District Municipality What I need is this: When from the field “Country” a particular country is selected, for instance Italy, I would like the field “Region” to show only Region names from Italy, and when I select a Region name, the field “District” only to display District names from the selected Region only. The same for Municipality. How I am to accomplice this? (For the time been I have assigned to every field a Value list names, f.eks. field: “TableName::County”) Thanks in advance
×

Important Information

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