Jump to content


  • Content count

  • Joined

  • Last visited

Everything posted by reynir

  1. Hi I updated my solution to FileMaker Pro 16 and FileMaker Go 16 and after that the script step Insert from Device (Type:Camera). Now FileMaker Go comes with the screeen "Files on iPad" and "No files available". When I press cancel the script continues and opens the camera. This does not happen in FileMaker 13 and 14. Other thing that I noticed is that the Go To Portal Row > By calculation does not work as it does in FileMaker 13-14. Frustrating. Any workaround? Regards, Reynir Iceland Hi again The second problem is solved. I inserted "Refresh Window" before the script step "Go To Portal Row" and that did the trick. Regards, Reynir.
  2. Hi FileMaker Advanced 11 question. I have two separate conditional value lists in one layout showing Provinces, Districts and PostalOffices. One shows the provinces in one country and is linked: Table1::OrginalProvince = Provinces::Province. The Province table has following attributes: ID, Province, District and PostOffice Then I have another conditional value list showing the Districts (with related values only) And finally I have conditional value list showing the PostalOffices (with related values only). This works ok. I used this method: http://www.teamdf.com/weetbicks/24/conditional-value-lists-pt-1-what-are-they-how-to-build-them My problem is that I want to have identical value lists showing the same attributes but with different relationships: Tabel1:DifferentProvince=Provinces::Province. But when I make those conditional value lists the second conditional value lists seems to use the first relationship ?? So in the first conditons (dropdownlist) for OrginalProvince I select "Cabo Delgado" for OrginalProvince, then I get a list of districts for "Cabo Delgado" in OrginalDistricts (dropdownlist), when I choose "Balma" for OrginalDistricts then I get a list of OrginalPostalOffice (dropdownlist) What happens in the second set of drop down list is that when I choose "Maputo" for DifferentProvince then I get a list of districts for "Cabo Delgado" in the DifferentDistricts (dropdownlist) ?? Any idea what is causing this behavior? I use two different relationships for the conditional value lists. Regards, Reynir.
  3. Chart number formatting

    I have a database based on Icelandic localization with the decimal as comma and thousands separator as dot. The numbers are formatted to use system settings. I have a column chart to show percentage of defects. I.e I have in a sample count of items = 40. Then I have defects like brown heads = 2. Calculating ratio of brown heads gives me 2/40 = 0.05. When I format it on a layout to show 5,0 percent. To have it in percentage I multiply by 100. When I format it on a layout it shows 5,0 percent. When I show the same number on a column chart it shows 5,0 When I change the localization of the system to USA or Canada system settings and insert the same data with decimal separator as dot and thousands separator as dot the same information show up as 50.0 on the column chart Have you seen this behavior Regards, Reynir.
  4. Relationship for popover

    Hi I am developing a database for measurements of samples. Each sample has one or more measurements. Each measurement has one or more work items When a sample arrives I add one or more measurements to the sample. For each measurement I copy work items to a table "Work items in a sample" and for this record I log start time and also time when the work item in sample is finished and the result for the work item. I have a list of work items in sample which are not finished and every time each work items in sample is finished I update the list. So if a measurement has 5 work items in sample and 2 are finished I only see 3 in the list. I want to see in a popover all work items in sample to compare the results of the finished with the unfinished. When I create a portal in the popover and try to show records from work items in sample the work items in sample table is grayed out. I have tried to make a self-join "Work items in sample::id" = "Work items in sample::id" but I only get one work item in sample The popover shows correct sample number and measurement name in each record. Hope you understand my problem. Best regards from windy Iceland. Reynir.
  5. Check box set problem

    Hi I have a table with standard comments in icelandic and english, named standard comments. I use the field comments::standard comments in icelandic as a checkbox set in a form in a sample table. When the user checks one or more values the field sample comments in icelandic updates. If I uncheck value the sample comments in icelandic updates. I also have a field which is comments in english and is a looked up value based on a relationship between comments::standard comments in icelandic and sample::standard comments in icelandic. When I check one or more values in sample::standard comments the field sample::comments updates but when I check one sample in sample::standard comments the looked up field comments in english updates only once. If I check more than one the field stores only the first one checked. If I uncheck the first value the fields does not clear the first value. The scenario is that the user is working in icelandic but the output is both icelandic and english. Hope you understand my problem. Maybe I should make this via script?? Any help appreciated. Regards, Reynir.
  6. Hi I am having troubles using the inspector in FileMaker 11 Advanced version When opening files sometime the inspector shows position like 402 px and then everything works well. But sometimes the inspector shows position like 402,000 px and when that happens I cannot copy layout parts on layouts or between layouts. I have tried to uninstall and install again with no luck. Does anybody know this behavior? Regards, Reynir.
  7. FileMaker 11 Advanced inspector issue

    Lee  Im sorry for the late reply.  This is happening in all databases with web viewers. But not in databases with no web viewer.  Advanced 11 Advanced 12 Advanced 13  When I open the database everything works well.  When I open a layout containing a web viewer the inspector changes.  I can do most of the layout work done but I cannot copy between different layout.  Then I get the message "This operation cannot be completed because it would exceed the maximum allowed dimensions of a layout.  It also happens in new databases.  When I restart the computer the behaviour changes to normal but after I go to a layout containing a web viewer this happens.  Attached are sample of inspector ok and not ok from the same file.  Best regards, Reynir.
  8. Hi I have a portal showing upper and lower limits of measurements. The portal is sorted by FK_MeasurementsID Then I have a list showing the upper limits List(Measurements::UpperLimits) also for lower limits My problem is that the List() function does not sort the upper and lower limits the same way as the portal. Then when I use those values they don't match. Does the List() function use the creation order of the measurements records? Is it possible to sort the List the same way as the portal? Regards Reynir.
  9. List function

    Sorting the relationship did the trick. Thank you for your time.
  10. List function

    I am working on this database in FileMaker Pro 11 :-( with my client. I will take a look at the relationship. Regards, Reynir.
  11. Hi I have this strange problem in one script I am using to delete child records. The script is in the attached file. For example when there are 20 child records then the script finds 20 records, but when the script goes into the loop script it only deletes half of the records, so when I press the button "Delete" once there are 10 records left. When I press the button again there are 5 records left and so on. Can anybody point out what I am doing wrong here. The loop part does not loop though the found set. Regards, Reynir. Filemaker - Delete related record script.pdf
  12. Delete Record/Request loop not working

    Exit Loop If [ not Get ( FoundCount ) ] did the trick. Thank you for your time and help.
  13. Delete Record/Request loop not working

    Update: When I create another script to run this script six times it does what I want it to do. I forgot to mention. It is written in FileMaker 11 Advanced.
  14. Hi I am trying to compare two lists in my solution. Detail description of my problem is in the attached document. Short description of this problem is that in the table Production_Lot I have two lists, Prod_Measurement_List and Packaging_Measure_ToDo_List The lists are generated from two portals containing Products_Measurements and Packaging_Measure_ToDo and the items in the lists are identical, like 9Docosahexaenoic acid (DHA) 8Eicosapentaenoic acid (EPA). Then I have the test calculation checking if the patterncount of the product measurement from each portal record of the product_measurements is found in the list Packaging_Measure_ToDo_List and vice versa. This test evaluates corectly if I compare the product_measurements with the Packaging_Measure_ToDo_list but if I compare the Packaging_Measure_ToDo with the Product_Measure_List then the calculation does not evaluate. Always showing null. I hope you can undierstand my problem. And please ask if you need further clarifications. Regards, Reynir. Compare two lists and copy values to another portal.pdf
  15. Hi I updated my FileMaker 11 database to FileMaker 12 and I am using it with FileMaker Go 12 with FM 12 Advanced. The database is for quality control records in the seafood industry I have 7 different inspection types and I am using the same script to create new related records. You can see the script in "Icelandic" in the attached document. The scripts are for two types of inspections and one "Karfi" is working correctly and I get to the field "Þyngd". The script works well in 4 of the seven inspection types but not in three of them. But the other one "Sjófryst flök" does not work as the other one. It goes only in the first portal row. I have reinstalled the FileMaker Go 12 app with no luck. Any ideas to fix this problem. Regards, Reynir.
  16. The problem is solved. All of the scripts are now working correctly. Thanks, Reynir.
  17. I thought I attached a document with the scripts. I will try it again. But I tried the solution Cristoalberts30 and it works well now. Why it works in some scripts but not others is still a mystery. The document was a word document and not permitted. I will send a pdf instead. And I will post how the other scripts are working with this solution. Thank you for your time. Regards, Reynir. FileMaker 12 - New related record script.pdf
  18. Hi I am trying to use the getsummary function to use a summary in a calculation. The database is managing products produced on board a freezing vessel. I have two tables: ProducedProducts with: id fk_trip_id no_of_produced_cases weight_of_case total_weight = no_of_procuced_cases * weight_of_case fk_process_method fk_type_of_productd and Yield with: id fk_trip_id yield_of_products fk_process_method fk_type_of_product Then I have a report with a subsummary showing records from ProducedProducts Subsummary by fk_type_of_product Then I have Total of no_of_produced_cases, Total of total_weight and Average of yield_of_product What I am trying to do is to get the weight of the fish that the vessel got on board by dividing the total of total_weight by the average yield_of_product. I.e. if the vessel produced 100 kg of a product with a 0.54 yield then the raw material was 100/0.54 or 185.19 kg. In the report the Total of no_of_produced_cases and total of total_weight shows but the Average of yield_of_products shows blank. On filemaker formum : http://help.filemaker.com/app/answers/detail/a_id/3614/~/the-getsummary-function-can't-reference-related-fields it says: The workaround for the Break Field reference is to use a Calculation Field in the Master file that simply equals the Break Field in the Related file. In the case of the Summary field reference you will need to create a Calculation Field in the Master file that equals the Field in the Related File you want to summarize and then create a Summary Field in the Master file that Summarizes the new Calculation Field. Another option is to use a Sub-summary report. Sub-summary Parts can Sort on Related Fields. Can anybody point me to the right direction on this workaround? Best regards Reynir.
  19. Getsummary problem

    Hi Comment. I did read a lot of articles on the forums and I managed to fix this problem this way: In the product table I placed a portal based on fk_trip_id & fk_process_method relationship between the prodcedproducts table and the yield table. ProducedProducts::fk_trip_id&fk_process_method = Yield::fk_trip_id&fk_process_method. Then I added an new field in the producedproducts table showing the average yield of the process_method. Then I can calculate the raw material weight of the produced products: ProducedProducts::total_weight / ProducedProducts::average_yield. Then I use the total of the raw material weight in the report. Again, Thank you for your time and efforts. Regards, Reynir
  20. Getsummary problem

    Ok, the calculation works but does not show the right result. The reason is that I need to filter out the data from the product table from each trip. i.e. 20 cases of G-92 (Product code) with sale weight 26 kg. Total product weight = 2080 kg. Then I need to filter out of the yield table the yield tests made for G-92, i.e. 71,88 %. In your case the average (Yields::Yield) result takes the yield of all yield tests in the table and is with a yield 0,54 which is to low. Hope you understand what I am trying to explain. Regards Reynir.
  21. Getsummary problem

    About the yield. Yes there can be many related records for each product/trip combination. The yield for the trip/product is an Average. But the total weight is a Total. So the raw material is calculated as: total weight / average yield. Regards, Reynir.
  22. Getsummary problem

    The problem is following: On a freezing vessel they catch fish in a trawl. The fish comes on board and is not weighed. Then the fish goes into the production line. Then the crew takes sample of 10 fish for each product. This yield is stored in the Yield table. If I could weight the raw material before the production it would be correct to have it in the products table. To have the total catch of raw material I need to divide the producedproducts by the yield to get it. Consultant, what about the workaround from Filemaker, any comments on that? Regards, Reynir.
  23. Hi I have a problem grabbing a value in a text field containing a list. The list is containing values from a related record and is defined: TextField = List (RelatedTable::RelatedField) And is like: 0 10 50 100 etc. What I want to do is to loop through this list, grab each value and create a new related record in another table an paste each value into a field. Can anyone help me on the right track here. Best regards, Reynir.
  24. Almost the right understanding. Thank you very much. In the meantime I found another solution that worked fine (at least I manage to get it working the way I want) CalibrationValue_List is the list of calibration points values. The script is as follows: Loop Set Variable[ $line, 1 ] # Loop over lines Loop Exit Loop If[ ValueCount( CalibrationValue_List ) < $line ] # # Get line values Set Variable[ $fields, GetValue(CalibrationValue_List, $line ) ] SetVariable[ $pk_Calibration_ID, Value: pk_Calibration_ID ) ] Go to Layout(CalibrationValues) New Record/Request Set Field[ CalibrationValues::CalibrationPoint, GetValue( $fields, 1 ) ] Set Field[ CalibrationValues::fk_Calibration_ID, $pk_Calibration_ID ) ] Go to Layout( original layout ) Set Variable[ $line, $line + 1 ] End Loop This will help me a lot. I will try your solutuion as well. One more question: In your solution you commit records in the end, is there a reason to do so? Again, thank you very much pointing me to the right track. Best regards, Reynir. I can see in my reply there is one Loop to much in the beginning.
  25. Maybe I was not clear enough about this. The scenario is like this: I have a calibration program table (pk_CalibrationProgram_ID, etc. which has a related table: calibration points (one or more) (pk_CalibrationPoints_ID, fk_CalibrationProgram_ID, etc.), then I have another table calibration (pk_Calibration_ID, fk_CalibrationProgram_ID, etc.) which has a related table calibration values (pk_CalibrationValues_ID, fk_Calibration_ID, what I want is when I make a calibration record for the calibration program, then I want to copy the calibration points to new records in the calibration value table. The CalibrationProgram table is related to the Calibration table. In the calibration table I have a portal linked to both calibration values and calibration points, Then I have a ListOfCalibrationPoints = List (CalibrationPoint::CalibrationPoint) which contains the calibration points, what I want to do is to copy each calibration point, create a new record in the CalibrationValues table and paste the calibration point into a field, CalibrationPoint in the Calibration Values table. Hope this explains what I mean. Reynir.

Important Information

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