Jump to content

Tony Martin

Members
  • Content Count

    71
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Tony Martin

  • Rank
    member

FileMaker Experience

  • Skill Level
    Novice
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
    Windows
  • OS Version
    Win 10

Recent Profile Visitors

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

  1. 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 :)
  2. 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.
  3. 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.
  4. 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!
  5. 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!
  6. 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.
  7. 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?
  8. 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!
  9. 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
  10. Hi Gang - long time, no post! Thought I knew most everything about FM but... I'm now trying to create a field (lets call it field_B ) which contains a history (including timestamp info) of another field (we'll call that field_A ). Field_A contains frequently updated prices, and every time the field has a new entry (price) or the price changes - either higher or lower - I need a history of the last previous changed prices, along with the timestamp of when they were changed. Neither fields are global - each record has it. The data is being auto updated by an SQL feed - this is how it might come in (appear): Field_A content at 8:00AM on 7/13/2013: <blank - no value> Field_A content at 9:04AM on 7/13/2013: $26,523.72 Field_A content at 9:12AM on 7/13/2013: $26,523.72 Field_A content at 10:02AM on 7/13/2013: $26,064.00 Field_A content at 12:32PM on 7/13/2013: $28,451.84 Field_A content at 12:36PM on 7/13/2013: $26,523.72 etc, etc Field_B needs to look something like this at 12:40PM on 7/13/2013: 07/13/2013 @ 12:36PM - $26,523.72 07/13/2013 @ 12:32PM - $28,451.84 07/13/2013 @ 10:02AM - $26,064.00 07/13/2013 @ 9:04AM - $26,523.72 As you can see - a blank value in field_A wouldn't trigger an entry in field_B. A duplicate updated value from the perviously updated time wouldn't trigger an entry either. Only new entries and updated changes in the value of field_A would prompt an entry in field_B. In addition, I need the latest entry to be at the top of the field. Question: What is the best way to handle something like this, and how would I go about it? To be honest, I haven't had to code anything in a couple years and I'm totally brain dead on the implementation of this. I also realize I may be overthinking the solution - but I'm at a standstill here. We are using FMServer11 Advanced and are familiar with server side script handling. We are perfectly content on running some sort of script to update Field_B using Server Side scripting, unless it cannot be done this way or someone can think of a better way to handle it. I do realize this would be totally easier in FM12 but the clients have FM11 and are not upgrading. Any help you can offer on implementation and execution would be helpful! Thank you! Tony Martin Old Timer
  11. I'm in the process of migrating a customer from one filemaker db to a new db file and my customer would like to migrate his saved finds from the old database to the new one (without having to manually reconstruct them). Is this possible?
  12. Server R2 in either 32 or 64 bit works great for us. We were not happy with the results of FMS 9-11 running on a Vista Core at all. Tony
  13. Hi Everyone - one more question before I slip into a coma... We have 2 servers (both intranet connected via additional LAN cards) - one that our outside (cloud) clients FTP into and load photos onto (10.0.0.1), and a separate server that runs FMS11 as a database host to those customers (10.0.0.2). FYI: They are both internet accessible via IP. We are trying to get the photos they upload to 10.0.0.1 (ftp server) to show up in the databases which are on 10.0.0.2. We're currently trying to use a calculation that returns a container object, but FMP always processes it as a local path, which of course, doesn't work. I'm assuming we're pathing it wrong in the calc, but it may just be something else that I can't think of at the moment. We can't use the web viewer because of the scroll bars and resizing issues, limitations, etc. Any suggestions other than getting reamed $695 by 360Works for SC? Help! : Thanks... Tee
×
×
  • Create New...

Important Information

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