Jump to content

Bryn Kaufman

Members
  • Posts

    13
  • Joined

  • Last visited

Bryn Kaufman's Achievements

Apprentice

Apprentice (3/14)

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

Recent Badges

0

Reputation

  1. Another option is on the FileMaker support site.
  2. I would highly recommend using FileMaker and Instant Web Publishing. I have tried what seems like everything and this is the easiest and most effective solution. It has a few quirks like the speed is slow, the back button does not work, and you can't open multiple windows, but it is still the best option for ease of use and actually getting things done. For the number of users you will have you might need to sign up with a remote hosting company or purchase the server software, that is if you feel there will be more than 5 users at the same time.
  3. The database is downloaded from the Board of Realtors, it is a standard MLS database following the RETS standard. Because it is already defined I don't think it makes sense to change the structure. Answering the question of the thread I would say that the GTRR is not good for emulating a SQL search because of the problem I mentioned in the first post where if nothing is checked then nothing comes up. It is opposite SQL in that if nothing is specified in a SQL search then everything comes up.
  4. Hi, It is not a repeating field but it is similar. What I am doing is using the checkbox set to store multiple values to one field separated by a carriage return. Example: New York Chicago Philadelphia All in one field. The GetValue() is the position of the word in the field so GetValue(fieldname;1) = New York. This allows me to pull each value out of the field separately, store it in a variable, and then use it later on when I go into Find mode.
  5. There are 14 fields being searched. The challenge is that each field needs an OR search. For example, in SQL it would look something like this: WHERE field1 = var1a OR field1 = var1b OR field1 = var1c AND field2 = var2a OR field2 = VAR2b etc.... I don't think there is a way to do it with less lines of code but if you would like to look at the search screen and the code you can do so from the following link or I have also attached the .pdf file. http://www.oahure.com/temp/EasySearch.pdf EasySearch.pdf
  6. Thank you for the tip. I did end up using a normal find and then a series of Constrain Found Set commands and this performed the exact search I was looking for. It took the script from 1 line to over 600 lines which is why I was hoping the GTRR would work, but it is not as bad as it sounds as it took me about 3 hours to complete the script and it works. If anyone is looking to emulate a more complex SQL type search this method seems to be the best way. If anyone has any questions on this please let me know as I would be glad to explain the solution in more detail.
  7. Hi, I am using the GTRR to try and emulate a SQL Search. As long as I check of some data for each field it works perfect, but if I leave a related field blank it comes back with nothing. How can I use GTRR but let my clients leave one or more fields blank and still come back with the right results? For example, in SQL you might use WHERE City = "New York". Then if you leave off the WHERE City = "New York" you would get all the cities. In GTRR you can check off New York as one of the cities, but if you leave it blank it assumes it should have no cities instead of all cities so no records are found because they all have a city. Any help would be very much appreciated. :o
  8. I need to show images inside of IWP that are located outside of IWP on another server. In plain HTML I can show them using http://... but I am not sure how to get them to show up inside IWP? Any suggestions? Is there a Plug-in I could use?
  9. OK, thanks!!! I now have a good solution to a problem that I thought was impossible to solve.
  10. Thanks again! That worked, but one last issue. The data comes to me from the MLS. The multiple entries in a field are now separated by commas so it looks like this. Ocean, Mountain, Marina so for the it to work I need to change it to: Ocean Mountain Marina I tried replacing the , with a ¶ but that did not work. Can you point me in the right direction to take field data that is separated by commas and switch it to having each entry on a separate line? I think after this is done this solution will work great! :thumbup:
  11. Thanks for your suggestion but there is one issue still which prevents it from working. I am hoping there is a solution to this one issue. Using the relationship works great as long as there is just one entry in the field of the table I am searching, but if two or more entries are in that field it will not find it. For example, with the view field, if the view contains Ocean, then it will match if my user checks Ocean for the view. However, most views contain multiple entries, such as Ocean, Mountain, City. So now if my user checks Ocean it no longer finds the record because Ocean does not equal Ocean, Mountain, City. Can you help me to bypass the brick wall again? Thanks.
  12. I have a simple SQL Search that needs to be done but it looks like Filemaker can't do it. Any help would be greatly appreciated. I am search a table that contains homes in my area. In plain English the search would look like this: Select all fields where Region = region1 or region2 or region5 or region7 or region8 or region9 and condition = excellent or above average or average and view = ocean or mountain or beach and price > 100,000 and price < 200,000. Now this search is fairly easy to do using SQL, but in Filemaker it looks like I would need to create 54 search requests, which of course no user would ever do. I called Filemaker support twice on this issue and the only suggestion is to write a custom script, but when there is a lot of fields to search a custom script to emulate a SQL search is very difficult. Again, any suggestions would be greatly appreciated. I love Filemaker's ease of use but I think I hit a brick wall.
×
×
  • Create New...

Important Information

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