Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About NewBoard

  • Rank

Profile Information

  • Title
    Quality Assistant
  • Industry

FileMaker Experience

  • Skill Level
  • FM Application
    16 Client

Platform Environment

  • OS Platform
  • OS Version
    Win 10

Recent Profile Visitors

1,188 profile views
  1. Thank you very much for your assistance bcooney, this definitely gives me a good starting point on this project!
  2. I've actually used that same Loop logic in other databases, and it works just fine. Variables start at zero when you first create them, so by adding one right away it sets it to one, and then increments it in loops afterwards.
  3. I've honestly put this project off for so long because I'm entirely unsure of how to lay this Database out. I need it to be future-proof so that nobody has to create new Tables, Tabs, Layouts, or anything Administrative. I was hoping to record the parts within the month database. So after running the aforementioned script, you would be able to scroll through and input the data pertaining to each Supplier. I've attached the excel spreadsheet we currently use to keep track of Supplier On-Time Delivery if that can help you to understand what I need this Database to function like. 2017 OTD Supplier.xlsx
  4. Sure all values in a field. The Data is measured in number of Parts. So basically Supplier XYZ delivered 1,000,000 total parts, and 750,000 parts on-time. I'm on the "Month" table, which is related to the "Supplier" table via Month::fk_Supplier = Suppliers::UUID I was hoping to have a button that would "start a new month" by creating a new Record in the Month Table for each Supplier in the Suppliers Table. This would then let the user Filter by month and see each Supplier's On-Time Delivery numbers for their particular chosen month.
  5. The names of all the Tables/Fields are mostly just arbitrary right now, this is a database that I've just begun to slap together this morning. It's going to be a Database that keeps track of each of our Supplier's On-Time Delivery for the month. How would you recommend I get FileMaker to create a List of all Records in a Field?
  6. I am attempting to use the following script in a Database: Set Variable [$supplierCount; Value: ValueCount ( List ( Suppliers::UUID ) )] Set Variable [$month; Value: MonthName ( Get ( CurrentDate ) )] Set Variable [$suppliers; Value: List ( Suppliers::UUID )] Loop Set Variable [$i; Value: $i+1] Exit Loop If [$i > $supplierCount] New Record/Request Set Field [Month::Month; $month] Set Field [Month::fk_Supplier; GetValue ($suppliers ; $i )] End Loop When I run it, however, it creates zero New Records within my "Month" database. I'm not sure what the issue is. My only hunch is that the List function isn't properly creating a List of the "Suppliers::UUID" field, and is causing the ValueCount taken of it to return 0. Please let me know of any additional information I can provide, and thank you in advance for any assistance you can offer!
  7. I have used the combination of ExecuteSQL and ValueCount quite a few times throughout my databases before, with almost no issues. Generally what I will do is set a variable by running an ExecuteSQL, then take a ValueCount of that variable. Then with that ValueCount I will loop through my original ExecuteSQL variable. However, I am now trying to do something different with this combination. Instead of using the ValueCount variable for a loop, I'm trying to use it as a Global Variable that will be displayed on the main menu. Here is an example of the code I'm trying to use: Set Variable [$source; Value: ExecuteSQL ( "SELECT UUID FROM Inspections WHERE Inspector = ? AND Accepted ≠ Accepted" ; "" ; "" ; $$fullName )] Set Variable [$$accepted; Value: ValueCount ( $source )] The UUID field is, as expected, an auto-entered "Get ( UUID )" field. The Inspection table is a table containing all of our part inspections. Each inspection begins with it's Accepted field having a value of "Rejected", if the correct parameters are met this field will become "Accepted". The Inspector field contains the first and last name of whomever conducted the part inspection. The $$fullName variable is set previously in this same script by comparing the user's Username to a Table that contains all of our user's Usernames and Full Names. What I was hoping to do is use a Merge Variable on our main menu that displays our $$accepted variable, showing the user how many unaccepted inspections from that particular user in our database. However, it only ever displays a value of "1". One of our users has 6 unaccepted inspections in our database currently, but this script only shows that he has 1. I am wondering if you can't use Merge Variables or ExecuteSQL in this way, or if I'm simply missing something obvious. Please let me know of any more information I should provide. Thank you for any assistance you may offer!
  8. I'm not sure what you mean by rebuild your indexes. How would I go about doing this? But yes, Part Number field is text. I've already tried deleting everything related to 0000194, including the customer, and rebuilding it. Which did nothing. I only show one occurrence of that part number. And I've checked all UUID's and Foreign Keys which match. Thank you again LaRetta for your attention on this matter. I fear if rebuilding my indexes doesn't work I may need to contact customer support! This is such a strange issue.
  9. Thank you very much for taking the time to build a database and reply! Your relationships are setup like mine, as well as the value list. However, your diagnosis is off. I wish it were something so simple, as I would've definitely noticed that! Here you can see that I do indeed have 0000194 as a record in the Revisions table But when I go to use my value list, it is non-existent: However, when I change the part number to "000194" it shows up just fine.
  10. I have stumbled upon a strange bug in one of my Databases concerning a value list. We have a table containing part numbers, which is related to a table containing "revisions" for the part numbers, which is related to a table of inspections for the "revisions". On a layout of the Inspections table, I have a value list. This value list selects the UUID of the revision, but displays the Part Number for the user. This has worked perfectly for several months. However, this morning one of my users discovered that he was unable to located "0000194" from this list. At first I thought maybe the UUID's somewhere along the line had become disconnected from their respective foreign keys on related tables. This was not the case. I then tried deleting and remaking the value list. This did not solve my problem. Then I figured if I deleted and rebuilt everything related to 0000194 that would fix it. This was not the case either. As a last ditch effort I restarted our FileMaker server, to no such luck. So then I began playing around with various aspects of 0000194. First I changed the company name, but it still didn't show up on the value list. Then I changed the part number to "TESTPART", and it showed up perfectly. So I tried "0194" and that showed up. Same for "00194" and "000194", but as soon as I add a fourth zero making it 0000194, it disappears from my value list. I'm 95% sure that this part number used to show up on the value list just fine, as we've already done inspections using this part number. So I'm thinking this bug has something to do with the leading zeros. I'm unsure of how to debug this or if there's any workarounds for this issue. Let me know if I need to supply any more information. Thank you in advance for any help you all can offer! [SOLUTION] At some point one of our scripts was run by a user without full permissions. The script added part number "0000194" to another customer, which I never noticed. Since Value Lists are indexed, it was not showing "0000194" because it was not a unique value. Deleting the second occurrence of "0000194" cleared my problem up.
  11. I am currently working on a database that will score our company's suppliers. I have one table that contains all contact information for the suppliers (Suppliers), and another related table that contains the actual score entries (Scorecards). Suppliers are scored on pieces shipped on time and quality reports. We only ever send a scorecard to suppliers based on information from the current year, so I have a field in the Scorecards table for year. The layout I am working with is based on the Suppliers table, with a portal displaying the related entries from Scorecards in the specified year. Now, where I'm running into trouble is my attempt to retrieve a total for Shipped pieces for a specific Supplier in a Specific year. In other words, how do I get FMP to take many related records, and sum only related records based on data in a third field?
  12. Thank you very much LaRetta, this did the trick!
  13. I have a database, which has two printable forms. One has been designed in portrait, and the other in landscape. Both of them are only ever printed using buttons tied to script steps, never manually. I was hoping that there would be some way to specify orientation via the script. However, after some poking around of my own and light Google searching I am thinking this may not be so easy. I am able to go into Print setup to change the orientation just fine, however this sets it for the entire database which is not all around helpful. While specifying the options in the print step, I am able to change orientation. For some reason though, this changes the default orientation across the entire database. Not even while running the script, but just specifying it in the options of the script step. So now I'm at a loss. If this is not able to be done, redesigning one of the forms wouldn't be that difficult. But if there's a way to do what I'm trying to do, any assistance would be greatly appreciated!
  • Create New...

Important Information

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