Jump to content

NewBoard

Members
  • Content Count

    36
  • Joined

  • Last visited

Community Reputation

0 Neutral

About NewBoard

  • Rank
    member

Profile Information

  • Title
    Quality Lead
  • Industry
    Automotive

FileMaker Experience

  • Skill Level
    Novice
  • FM Application
    18

Platform Environment

  • OS Platform
    Windows
  • OS Version
    Win 10

Recent Profile Visitors

1,450 profile views
  1. I recently purchased a new server for our FileMaker databases to live on. To migrate our databases, I simply copy and pasted the Database folder from the old server to the new server. The old server was running Windows Server 2016, and the new server is running Windows Server 2019. The clients are running on Windows 10. The Clients are running FMP version 18.0.3.317 and the Server is running FMS version 18.0.1.123 The server is in our building, and all clients are accessing it locally using Bonjour. After the migration, all of our Container Fields are displaying a 404 page. I hav
  2. Thank you very much for your assistance bcooney, this definitely gives me a good starting point on this project!
  3. 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.
  4. 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
  5. 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.
  6. 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?
  7. 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 o
  8. 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
  9. 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.
  10. 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.
  11. 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 ma
  12. 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 ye
  13. Thank you very much LaRetta, this did the trick!
  14. 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
×
×
  • Create New...

Important Information

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