All Activity

This stream auto-updates   

  1. Today
  2. Table A: StartingNumber EndingNumber Active Table B: NumberOne: Calc=1 CalcNumber Count I created a relationship TableA::Active to TableB:NumberOne, but I am struggling to finish. The goal is to get a Count of all Active people matching the CalcNumber - So each record where the CalcNumber >= StartingNumber and CalcNumber <= EndingNumber. The screenshot show the issue
  3. Made runtime with fm 16 advanced when running pdf output script getting following error - some one please guide me doesnt the runtime support pdf output
  4. I don't really see what role the checkboxes are supposed to play here. But to answer what I think may be your original question: Suppose you have a value list named "MyValueList" containing 1000 values. And suppose you have a field named MyCheckBoxfield, formatted as checkboxes using the MyValueList value list. In this situation, the following script step: Set Field [ MyTable::MyCheckBoxfield ; MiddleValues ( ValueListItems ( "" ; "MyValueList" ) ; 600 ; 50 ) ] would check 50 contiguous boxes in the MyCheckBoxfield, starting from box #600.
  5. I wouldn't mark the records if you can help it. You will end up with only those records so why mark them anyway? Do you have another reason to wanting them marked?
  6. Thanks @comment. I do have serial numbers for the Records. Honestly, both solutions seem viable. The second one seems quicker to flesh out. It seems the checkboxes will end up becoming just a visual aid. And, thank you @LaRetta. I played a bit with your example and it seems to be exactly what I need. I'll post again in a while with my solution, if other than yours. Thanks again.
  7. I see no need to tag the records. What you want is a found set of only the records you want to import into, correct? The first set of numbers is the record number which is used to isolate the records and the second is the serial which happens to be same as record number but doesn't matter at all.
  8. Sorry, I don't know what you're showing me. I mentioned two possible scenarios, and you haven't said which one (if any) is correct.
  9. I had just finished an example. See if this gets you closer to what you want. It appears this is similar to Comment's suggestion. Select#numRecords.fmp12
  10. Thanks, I guess you mean (See screenshot). OK, so I would need to create two global fields for the script. Could you please elaborate a little bit further on how the script should look like?
  11. Yesterday
  12. Are your records numbered with serial numbers? If yes, then in order to find 50 records starting from record #600, you need to input somehow two values: 600 and 50 (say into two global fields). Then your script (surely you would want to script this), can find records with serial numbers in the range between 600 and 649 (the latter calculated from the two supplied numbers). No checkboxes are required for this. If they are not numbered, then I guess (!) you would want to start by showing all records, then omit the first 599 records, then go to record number 51 and omit the remaining records. No checkboxes are required for this either.
  13. For example, I have 1000 Records within the database. I am going to import 50 pdf files into Records 600, 601, 602, 603... 649. I need to select from 600 to 649 prior to importing the pdf files, otherwise the pdfs will populate Records 1, 2, 3, 4... 50. Currently I have a Checkbox which I manually select fifty times. Then I perform a Find on those selected checkboxes to filter the results from 1000 to 50. Hope this makes more sense. Best, Daniel
  14. Hi, I want to create a Dropdown List of numeric options to select a range of records. For example, the Dropdown list would contain: 5 10 20 50 100 ------- edit... Each option would select the next 5;10;20;50 or 100 records to the right. A Checkbox would be populated (with an X) in the selected number of contiguous records; Then, a Find Selected Checkboxes would return the selected records. The contiguous selection should be independent of whatever the current state of Found (Sorted/Unsorted) is. Any help will be gratefully acknowledged. Best, Daniel
  15. don't know their api but you are missing the async key. Perhaps they require it?
  16. Thanks for the tip, Wim! I've attempted to build an array in the code after looking at an example online. The dataviewer seems to show the json output matching the API spec, but I'm still getting "{"detail": "JSON parse error - Unterminated string starting at: line 1 column 25 (char 24)"}" Here's what the dataviewer now shows: { "address_from" : { "city" : "Los Angeles", "country" : "US", "name" : "KL Test", "state" : "CA", "street1" : "Thompson Ave", "zip" : "91201" }, "address_to" : { "city" : "Riverside", "country" : "US", "name" : "David Test", "state" : "CA", "street1" : "555 Some Street", "zip" : "90015" }, "parcels" : [ { "distance_unit" : "in", "height" : "5", "length" : "5", "mass_unit" : "lb", "weight" : "2", "width" : "5" } ] }
  17. You need to link RecordedDimensions directly to either Dimensions or Gages. If the Instrument field in RecordedDimensions is populated to be the same as the Instrument field in the corresponding Dimension, you could define the relationship as: RecordedDimensions::Instrument = Gages 2::Gage Type where Gages 2 is a new occurrence of the Gages table. Then your value list would be defined to use values from Gages 2::Gage ID, include only related values starting from RecordedDimensions. -- Note: this is a technical answer. I don't really understand what you're doing here, or why. And I have a feeling there is a better way to do it.
  18. I answered your question. RecordedDimensions
  19. It's a simple question. The answer should be one word: the name of the table in which the field is defined.
  20. Thanks for the replies. Not sure what you meant about having to switch strategies eventually - I assume you mean the deprecated runtime? If so, I'm assuming I'll eventually have to move away from FMP altogether (Xojo is in the running) since any solution that requires users to have their own FM license is not an option. (We've discussed this a while back - I know your thoughts Wim. ). RIght now, while I'm still using FMP, I'm trying to determine what I'll get out of an upgrade to 16.
  21. Your assumption is correct. So, I currently have one form for building the parts. This is where the manager will enter in what dimensions are being inspected, what tools, and the tolerances through a portal linked to the Dimensions table Then, as the inspections are actually performed, they will pull up the following screen: The portal on the left contains all of the information that the manager entered in earlier. I want the user to be able to enter information into the portal on the right, which points to the table RecordedDimensions. Which I have working correctly besides the instrument dropdown.
  22. Let's start with this: in which table is the field you need to populate using this value list. Also, am I correct in assuming that your last picture shows records from the Gages table, with the left column being Gages::Gage Type, and the right column being Gages::Gage ID?
  23. My bad, I should've said MBS can probably come to the rescue, as well. Apologies.
  24. A conditional value list is exactly what I'm trying to make. It's a little easier said than done though, since I'm storing values in one table, but referencing them in another. Currently when entering values, my stored values table doesn't know which report from the Dimensions table it's referencing. If I could figure out how to the dimensions and stores values 1-to-1, I could do a conditional value list. I've managed to get the drop down to only show Gage ID's related to the gages used in the inspection. However, it shows ID's from all of the gages used on that inspection. Whereas I want it to only show the ID's for the gage used on that specific dimension. Let me know what I can clarify for you.
  25. With MBS FileMaker Plugin you can use various functions for this. You can use QTMovie or AVAsset to open the video/audio file and read metadata like duration. Or if you show it in an interactive container to run javascript with WebView.RunJavaScript and query duration.
  26. I got lost in your description. It seems you're looking for a conditional value list.
  1. Load more activity