Jump to content

Tony Martin

  • Posts

  • Joined

  • Last visited

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
    Win 10

FileMaker Partner

  • Certification
    Not Certified

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

Tony Martin's Achievements


Enthusiast (6/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. Good morning gang! It's been a LONG time since I've made mods to my database. But now, due to a change in the way the data comes in from the source, we have an issue that's making things very slow in the data entry group. Essentially, we have 2 lines of data in a field, but only need the first line of data (address number, street - ie "123 Anywhere St"), and we need that data copied to two other fields, the address number field and the street field. Here's the field we need to copy the num and street from: And here's the fields we need the NUM and STREET copied to: Now, like I said, it's been a VERY long time since I wrote this database, and I'm old now and my memory is shot. lol I cannot for the life of me, remember the best and most efficient way to get this done. We have a button we could integrate the copying of the parsed data into. I guess I just need help with the scripting for this button. If anyone could help with this, I'd be grateful! Thank you in advance.
  2. Hi Everyone - I've been up for two days and am totally brain dead and I cannot for the life of me, remember how to take a list of results as seen here, and make them display the cumulative point totals for each person. Portals? Multiple Tables? I can't remember. Been too long and I'm getting too old - lol Thank you for your help!
  3. Friends: I'm having an issue where the portal shown below works fine in the application (FMP 16), but does NOT show on the web (WebDirect). I'm using the latest version of Chrome, and also the latest version of Java. Also, both logins are mine (the developer - complete access to file). Does anyone have a solution? Help!
  4. Friends: I'm having an issue where the portal shown below works fine in the application (FMP 16), but does NOT show on the web (WebDirect). I'm using the latest version of Chrome, and also the latest version of Java. Also, both logins are mine (the developer - complete access to file). Does anyone have a solution? Help! :)
  5. Good morning, everyone! I have a milti-line field that I use to drop in a name and address, which I then have to parse out to other fields. I've attached an example photo of the multi line field, and the other fields to which I need to add the data. My question is - how can I use the text functions to "grab" the key data (such as the 2nd "address" line, the third "zip code" line, etc) separately, since we have the multi-line data issue? What would be the most efficient way to accomplish this? Thank you in advance.
  6. I'm not quite understanding - the users want multiple photo upload/display ability. You're saying there's a better way to accomplish this using the method described above? I'm very new, so I'm not visualizing your solution - tho I appreciate the feedback :)
  7. I have an auction calendar (layout - "Calendar") with properties that display address, date, time and location data on it from the PROPERTY table. When users log in and enter the layout, they see the calendar for the current day. These properties are common for everyone, and have a unique "PropertyID". I have two additional tables with key ID fields - the first is a USERS table with basic info about the user including their "UserID". The second is the USERPROPDATA table with a "UserID" field and "PropertyID" field. What I'm trying to accomplish is to allow the USERS to add their own pricing data (that only they can see) into a couple of fields from the USERPROPDATA table (Fields are "UserPrice1" and "UserPrice2"), but I'd like them to be able to do this via the "Calendar" layout. Again, this layout displays data from the PROPERTY table. Because I'm fuzzy on creating effective relationships (I'm new), I'm not exactly sure of the best way to do this. In the "Calendar" layout, I have a portal to the USERPROPDATA table displaying the "UserPrice1" and "UserPrice2" fields. When a user enters data in the portal, a record is created in the USERPROPDATA table with the UserID, PropertyID and the data from UserPrice1 and UserPrice2 in it. The problem is - everyone can see that data. I'm getting stuck on how to show only the logged in users' data for those properties. Any help is greatly appreciated. Thank you in advance.
  8. Hello - I'm not sure if this is the right place to put this, but let's have a go at it. I have a "PROPERTY" table that shows stats of homes for my users. In this table there's fields from a related table, "PHOTOS" that displays Default photo(s) for that property in 6 containers. When we add photos, new records are created in the PHOTOS table with our user ID and property ID. There's always at least ONE default photo in the first container window What I'm trying to figure out is this: When a basic user (not us - administrators) visits the PROPERTY table: 1) What's the best way to display the default photos if the user doesn't have any added, and 2) Best way to allow the user to add their own photos thru this layout? I was thinking of maybe having some sort of visual toggle "switch" that the user could click on/adjust. It would toggle between any default photos available, and the users photos. of course, the user wouldn't be able to modify or delete our photos - only the ones they add thru this layout, and only after toggling the users photos "on". Am I on the right track here? Is there an easier way to make this work? Any help is appreciated.
  9. Hi gang - I have another question, this time in regards to popup window positioning in a Windows 10, multiple monitor scenario. The problem is - I have the FM12 solution running on Monitor 2 (the extended desktop display), and when one of my popup windows activates, it always pops up in position, but on Monitor 1 (the main display where all the desktop icons are). I want the popup window to appear in relation to where the original solution is sitting, not 2 miles away on another monitor. Window positioning is important because the industry we're in requires multiple solutions and websites to be open for the research we do. Thank you all in advance!
  10. I'm an idiot - the best way to perform this function (at least the way I wanted to do it) was with a table "X" (cartesian) join to each tables key_ID fields. Works brilliantly. Thank you guys for the ideas!
  11. I have a set of static data that's part of a web string. The users open URL's using buttons and I use scripts to do that. I'm trying to figure out the best way to store that data without storing it in the open url script, because it can change from time to time (not too often) and it can be a pain to change it from the script. I was thinking of creating an ADMIN panel (ADMIN table actually) where the various data could be stored in text fields, but this isn't effective because the table isn't related to any other table. Anyone with any ideas on this one? Thanks in advance.
  12. A couple things that may help re - your response: 1) The Country CANADA is usually (lets call it 98% of the time another country appears) the only other variable country besides the US. 2) Sample 1 is the most common occurrence - probably occurs 75% of the time. 3) NV is the most common state, by about 95%. Maybe we could work our way up from the bottom somehow by detecting and parsing the state and zip code first, then move up to city, then street? Also, is there a way to detect the numeric portion of the street to differentiate it from the name(s) above it?
  13. Using: FMPA 16 Good evening - I have a text field that's auto-populated from an xls file. It's up to six lines long, and contains various data per record that looks like any of the following: (SAMPLE 1) ANYUSER RICK & MELANIE 123 ANYWHERE ST LAS VEGAS NV 89108 (SAMPLE 2) ANYUSER RICK ANYUSER MELANIE & JANINE 123 ANYWHERE ST LAS VEGAS NV 89108 (SAMPLE 3) ANYUSER RICK 50% ANYUSER MELANIE 50% C/O THE RICK AND MEL TRUST 123 ANYWHERE ST LAS VEGAS NV 89108 (SAMPLE 4) THE ANYUSER COMPANY 123 ANYWHERE ST COLDSTREAM BC V1B 3W8 CANADA What I need to accomplish: I need to non-manually populate this data into separate fields. Those fields are OWNER1, OWNER2, ADDY1, ADDY2, CITY, ST, ZIP, COUNTRY. Unfortunately, I cannot alter the data any further before it gets to my database. For the life of me, I cannot figure out the best way to make this happen. Does anyone have any suggestions for me? Thank you in advance!
  14. Hi everyone. This one's simple I'm sure. I have a text field where my client can type freely, but most commonly uses two key phrases (PAA and DRM). In another field, I need to format the text color to red when either of these phrases exist in the other field. The imoprtant thing to remember is that the other field may contain a lot of other text. Brain not working this am (coffee maker broken). Any ideas? Thank you! Tony
  • Create New...

Important Information

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