Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About kirvis

  • Rank
  1. Hi all, I am currently using a wonderful custom function called TypeSumField which I found here. In short, it makes it possible to sum a certain field from records that meet a certain condition. (i.e. if category = "Bread and pastries" then Sum( amount ) ) The source code for this function is: //This function will sum all SumFields whose TypeField = Type //Start should =0 or blank Let([ End = Count(TypeField); counter = Start +1; total = If(GetNthRecord(TypeField;counter)=Type; GetNthRecord(SumField;counter) ; 0 ) ]; Case(
  2. Thanks for the help, it works like a charm now. And indeed, it does not say in the Filemaker manual that conditional formatting works subsequently, so that you have to start with the lowest values first.
  3. One other short question related to this conditional formatting: is it possible to disregard the value "0" (zero)? I currently have some fields that are not populated with a value yet, which now automatically become green. I would like the formatting formula to disregard the zero's and leave the fields blank. Is that possible?
  4. Mmm, now it works in my sample file.. I changed the field type to "number" and it works. I just have to figure out now why it does not work in my original file, maybe a parenthesis too much or too little. I have included the updated, functionally working version of the sample file as an attachment. Thanks for the help! conditional_formatting_functional.fp7.zip
  5. I have made a small example file and attached it to this post. When playing with it by changing the numbers, it still does not completely work. I do not see what exactly it does when I change the values. conditional_formatting.fp7.zip
  6. I have clarified the calculation somewhat in my original post. The essence of the calculation is the following: self ≥ ( 0,8* ( max value of all fields - min value of all fields ) + (min value of all fields ) ) If these conditions are met, the fill color is red. Example: five fields with values: 6, 7, 8, 9, 10 max value is 10 min value is 6 field with value 10 will be red according to the above formula: 10-6=4 ; 4*0,8=3,2 ; 6+3,2=9,2 that because 10 is higher than 9,2 The aim of all this is that I want the color scheme to be dynamic based on the maximu
  7. Hi all, I am working with a system which needs quite some reporting, so I have decided to use conditional formatting to create a nice overview. I have five fields in a column on my layout, and a "total" field. What I want to do is give the five fields a color based in their value: First I determine the minimum value and the maximum value. The fields that have a value within the highest 20% between those values are red, the second highest 20% are orange, etc. I use the following formula: Self ≥ ( ( ( ,8 ) *
  8. The first problem I have handled now, by creating a ton of new TO's and creating three new value lists, starting from the order_line_items table. I however still do not know how to create the conditional value list for the "products" table, based on the (sub(sub))categories that are selected. Does anyone here have a clue about this? See attachment for the updated file. conditional_value_list.fp7.zip
  9. Hi all, I have a database system where I can assign categories to a product. There are three levels: category, sub-cat, and sub-sub-cat. I have managed, with a little help, to create conditional value lists for the categories. The sub-category you can select depends on the category you have selected etc. Now I want to be able to compile orders, so I have created two extra tables: orders and order_line_items. From the order layout, I would like to have a portal for the creation of this order. I then want to be able to select the category and sub categories and then finally, based on t
  10. Thank you! I am looking forward to the day you have some "free time" again. :(
  11. Thanks for your reply, I will try to explain my reasoning a little further: With the Excel sheet, I am actually trying to circumvent another problem I described earlier, but that nobody seems to be able to answer. I would like to grab subsummary field values and use them in another (overview) table. As this does not seem to be possible, I wanted to create a standardized Excel sheet, which calculates the subsummary values for me, after which I import only those values into different Filemaker tables. See below for example Excel sheet, the product name and the light grey values need to
  12. Hi all, I would like to know if it is possible to create a script where an excel file can be selected, and where values from a series of defined fields are imported into different tables in the database. For example: select excel file create new record in table "products" extract field "A1" from excel file and enter value into table "products" in column "product name" etcetera.. In short, I would like to be able to select only specific fields in a standardized excel file and insert them into FM via a script. Is that possible?
  13. Hi all, I am quite a novice when it comes to working with Filemaker 10, but I am in the process of learning quite a lot. There is however one problem I have not been able to solve up till now. What I would like to do is use subsummary values from one table, and display that in a field in another table, accompanied by its break field. What it is: three indicators: GHG output, energy use, and waste output one recurring entity: (substituted) end products two subsequent supply chain steps: components per end product, and processes per end product two connect table
  • Create New...

Important Information

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