Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


ah last won the day on January 6 2013

ah had the most liked content!

Community Reputation

1 Neutral

About ah

  • Rank
  • Birthday 07/22/1977

Profile Information

  • Gender
  • Location
    Oslo, Norway
  1. Evaluate() is exactly what I needed, and more than I hoped for! Thank you so much Comment, you just saved me many hours of work
  2. This seems to be what i am looking for! I will try to implement Evaluate ( "FieldToEvaluate1" ) into the calculation, and see if it works Hopefully this means that I no longer have to make extremely long Case-statements to get the info I want http://www.dwaynewright.com/filemaker-calculations/2007/9/16/filemaker-the-evaluate-function.html
  3. I mean the actual calculation expression, not the result of it. I am simply wondering if there exists any technique to let the expression itself be dynamic, so that i might write functions etc in a text field that would then be automatically inserted into the calculation, as part of the calculation. Imagine table with the following fields: ID name description textField (a text field) calculationField (a calculation field) In textField, I might write something like: Left(table::name;4) & Case(notEmpty (table::description); table::description) In calculationField I wou
  4. My solution needs quite a few calculations, and sometimes they get really complex. It takes quite a lot of time to 1. Go into the Manage database 2. Find correct field 3. Go to Options >> Calculated Value 4. Make a change 5. Save and go out of Manage database 6. See if it worked this time 7 Repeat X times until the result is satisfactory Is there any way to tell the calc field to update the actual calculation from a global field? A Get() function, maybe? Something like MakeACalculationBasedOn (global_field)
  5. If something is unclear, or my info seems wrong, or my English needs some tweaking, I would appreciate your comments.
  6. How I got a list with data from MySQL in less than 1 second with a SQL VIEW - from an awful 20-25 seconds when going through relationships between multiple tables from the MySQL database. My Filemaker solution is integrated with a MySQL database that has been highly normalized for different reasons. This means that a simple list with 4 different fields can easily contain info from 4 different tables, where a couple of the relationships might span 3 tables. This made the performance in FM really awful. In my case, this easily meant 20-25 seconds to pull out a list of 50-60 records from
  7. I am trying to make a products picture database. To make things as easy as possible, the preferred procedure would be to simply right click the image in a browser, go to the right container field and paste. But the image size gets really bloated: As an example, I copy a jpg-image that the browser says should be 86 kb. But when I paste it into the container field, ithe actual size shows as 209 kb (Length(container_field)/1024). If I then export the field content, the exported image file shows as 196 kb. If I, on the other hand, import the jpg-image to my computer, and then inse
  8. Hi, I am trying to find a simple solution to solve the following problem: I have a table that stores images for a product. Thus one product can have many images. To decide how they will be shown, these images need to be sorted, and have a unique sort value. Is there a simple way to find the highest number in the sort field where the product_ID is the same, and auto increment this? Also, does anyone have a good solution for changing these values in a simple way? Kind of the way tab order is set up in filemaker, so that if you change the value to a lower one, all the other ima
  9. Is it impossible to easily update a native FM-table with changes from external tables?
  10. I am still not able to make neither the otions2.fp7-database work as it should, nor my original database Any help would be deeply appreciated
  11. It dsolved the value list problem, but the relationships were not right for the rest of the database. It might be that it just needs some more buoy/anchor-relationships, but I really have no clue how these should be made. I need to get the options and values right with regards to the attributes and products
  12. I have connected FM 11 Advanced to an external database (Zen Cart MySQL) which has a quite complicated structure. For different reasons I would like to make native FM tables as well that will get updated info from these external tables (one native FM table will have info from multiple external tables). Preferably the native FM-tables should be updated whenever the MySQL-database is updated (the MySQL-database might be updated from external programs as well, not only from FM). One of the reasons is that I would like to have a local file of the most important tables and fileds that will wor
  13. I have now done some minor changes to Options2.fp7: added some name fields to the tables Options OptionsValues and Products made a relationship between the tables products and productAttributes added some records in the above mentioned tables added some fields/portals to the layouts My attempts to make relationships between the tables just made a mess, so I have not made any other changes to the relationship than the link between products and productAttributes. How should the relationship be, so that for instance the layout Products shows a portal with all the
  14. It still doesn't work for my real database, when I tried to do different changes to make it closer to your solution I have now redone some of the tables in the database to a local database, and imported the records for each table. I relookuped all the tables in the relatonship graph as well, but apparently something is not working with these relationships (unfortunately). But at least, this database might better show the structure of the solution. I am uncertain about how the relationship between attributes, options, option_values and option_values_to_options should work, and h
  • Create New...

Important Information

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