NewBoard
-
Posts
39 -
Joined
-
Last visited
Everything posted by NewBoard
-
Solution: I just needed to allow Field Entry in Browse mode.
-
Our database has a container field that we mostly have PDF's inside of, with the occasional PNG. Currently we have this container in three different layouts. On all layouts the scrollbar is visible when applicable. However, only one layout allows the users to interact with this scrollbar. This includes using the scroll wheel of the mouse and dragging the scrollbar with a click of the mouse. I've tried ensuring all the settings for this container field are identical across the three layouts, but nothing seems to fix this issue. One thing to note is the layout where it works properly does have the same Associated Table as the container itself, whereas the other two layouts have related tables as their Associated Table. Any help would be greatly appreciated!
-
As part of their workflow, some of our employees prefer to drag-and-drop PDF's into the container fields of our FileMaker database. This works with files in local directories, but if they try to drag a file from a network folder nothing appears to happen to the database. If they use the Insert>Insert PDF command, or if we use the Insert File function in a script, then the files are imported perfectly even if they are in a network folder. I'm curious if anyone else has run into this, or if we simply have something strange going on with our network stack. This happens across multiple computers. All users are on Windows 11. We are using the latest version (20.2.1.60) of FileMaker on both server and clients.
-
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 have attempting the following troubleshooting steps: Disabled firewall on the server Disabled firewall on the client Disabled both firewalls Switched the container field from internal storage to external storage Tried both Open and Secure storage. Tried to access the container fields from a FileMaker install directly on the server When I tried it on the server I got the following information: Module: IIS Web Core Notification: MapRequestHandler Handler: StaticFile Error Code: 0x80070002 Requested URL: http://Juniper.local:80/Streaming/MainDB/69C195279B5026B83046F07324A22947B573DE471A28D1F7BA92374DD54F758F.pdf?REType=EmbeddedRCFileProcesser Physical Path: C:\inetpub\wwwroot\Streaming\MainDB\69C195279B5026B83046F07324A22947B573DE471A28D1F7BA92374DD54F758F.pdf Logon Method: Anonymous Logon User: Anonymous Following the "Physical Path" listed above on the server, I am unable to locate the "Streaming" folder within the "wwwroot" directory. I am wondering if the server is attempting to find a file where there is none. Please let me know of any more information I can provide. Any assistance you all can give will be greatly appreciated!
-
Thank you very much for your assistance bcooney, this definitely gives me a good starting point on this project!
-
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.
-
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
-
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.
-
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?
-
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!
-
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!
-
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.
-
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.
-
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.
-
I'm sorry, what does "TO" mean?
-
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?
-
Thank you very much LaRetta, this did the trick!
-
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!
-
Less than operator not behaving as intended
NewBoard replied to NewBoard's topic in Conditional Formatting
Thank you very much Wim! This did the trick -
I have a form in which users make measurements of multiple parts, then input the max and min measurements. I then have conditional formatting that compares these maxes and mins to the hard mins and maxes for that part. If the inputted max is larger than the hard max, or the inputted min is smaller than the hard min; the conditional formatting is supposed to highlight that measurement in red. This has worked in almost every case I have tested so far, except for one strange case. I have a hard min of 9.8, and my user is attempting to input 10 as the min. FileMaker is highlighting this in red, even though 10 is larger than 9.8. When we change it 9.9 it isn't red, but 10.1 makes it red as well. I have no idea why this is happening, so any assistance in this matter will be greatly appreciated!
-
Checking if all related records in a portal have a specific value
NewBoard replied to NewBoard's topic in Finding & Searching
Thank you comment this did the trick! -
I currently have a form that contains a portal. In the portal there is a value that will either be "Accepted" or "Rejected". I'm wondering if there's a way to parse through this table to check if any related values have a "Rejected" or if they are all "Accepted". Then using that outcome, decide if the form should display Rejected or Accepted. Please let me know if I need to provide any more information and/or images. Thanks in advance for any assistance you can offer!
-
Oh my gosh. Thank you so much Fitch. You have solved something that I've been stuck on for a few days now. This worked perfectly!
-
That won't work for me unfortunately. I don't have a simple relationship like that. I have Lots, tied to Part Revs, tied to Parts
-
I have a table that contains dimensional data for parts. Each record has a unique ID, but also has another field with the ID associated with the part. I have another table that I'll be storing individual inspection data on. I was wondering if it's at all possible to parse the first table, and copy over all records that have a specific part ID to the second table whenever someone starts a new inspection record. Please let me know if I need to provide any more information and/or pictures. Thank you in advance for any assistance you can offer!
