Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About ken_s2007

  • Rank

Profile Information

  • Gender
    Not Telling

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
    High Sierra

FileMaker Partner

  • Certification
    Not Certified
  1. That looks very promising. I will check it out. Thanks!
  2. I'm not well versed in summary layout parts and reports, but am trying to learn. I have a (personal) database to track investments (stocks, mutual funds, bonds, etc.). I have fields such as: number of shares, price, and value (technically: shares * price). Each record has three checkboxes: buy, sell, and current holding (previous (historical) records do not have 'current' checked). After establishing a found set (of a particular investment), I have a script that constrains the found set to buys, sells, and current record(s) (plural, because the same investment could be held in multiple accounts). (All historical records (except buys and sells) are thus not in the found set.) I have a script, triggered on layout enter, that sorts by buy, sell, and current. (Buys and sells are executed trades.) I have a sub summary part, and in it, a summary field based on value. The layout displays the records sorted as I want, and the summary field displays the correct total for each of the three groupings of records. What I want is to get the value of each of those summary fields, so that I can do a calculation: (Sells + current holding) - buys = profit / loss. Of course using the single summary field doesn't work. I could run a script to find the buy records, set a variable based on the summary field value, find the sell records, set a variable on the summary field, and so on. Then have fields with those variables (plus a calculation field) in the trailing grand summary. I could also create separate fields for buy (shares, price, and value), sell, and current, but I'd prefer not to. I thought I'd ask, because I might be missing a simpler method. thanks
  3. UPDATE: A user claimed to have been clicking a checkbox, which has a script trigger to run a script. The script wasn't executing at times. I misdiagnosed the problem. Sorry for the trouble (I see no way to delete my post here). ORIGINAL POST: I have a database using external authentication (via Active Directory). FileMaker Server 17. Scripting using Get(AccountName) (using some logic ("if") based on an expectation of a particular AD account name, and other functionality) works fine in FileMaker Pro 16 Advanced (returning a value like "smith"; the user's AD account name), but lately, the script isn't executing as expected *at times*, when using WebDirect. I created a script to display the user's AccountName, and instead returning "smith", the WebDirect user's AccountName is in the form of: [WebDirect-DC288] [UPDATE: That was actually being returned by Get(UserName), not Get(AccountName).] ... which seems to be causing the problem. An explanation of why that is being returned would be much appreciated.
  4. You are correct; apologies for my testing error. Nonetheless, after I believe I've removed all fields from QuickFind that could possibly matter, when I use the form of subdomain.domain.com in QuickFind , I nonetheless get multiple found records in the form of server.subdomain.domain.com -- just not the particular record of interest.
  5. Seems odd to allow the EA account to open Security (it says full access is required), but not to re-auth to save changes. Another user of the system (with full access) can both open and save Security settings. For now, I'll continue to use the FileMaker File account. thanks
  6. CLIENT: macOS 10.13.6 FileMaker Pro Advanced SERVER: Windows Server 2012 RS FileMaker Server v.17 I an external authentication account in the form of an AD account: "ken", FM group: "ken_group" [full access]. I also have a FileMaker File account "ken" with [full access], and it is lower in the authentication order. I am able to use the external account to get into Manage > Security (which requires full access), but when I try to save changes with that account, I'm asked to "Sign in with an account that has full access privileges", but when I enter those same credentials, I'm told: "The account name and password entered does not match those for any FileMaker account." This is true for all (a handful) of databases on the same server. Update: Someone (outside of this forum) suggested I not have the FileMaker File admin account name the same name as the AD user. I added a new FileMaker File account "kenlocadmin", gave it [full access], saved, went back in and deleted the "ken" account, saved, closed the file, reopened it, and tried again, but get the same results.
  7. Odd, but today when I enter into QuickFind in the form of: server.subdomain.domain.com , I get that result in the found set. (Note: only that one record is found; no other records ending in subdomain.domain.com or com are found (which is my desired result). The only change I made that I can think of was close and reopen the database.
  8. FileMaker Pro 16 Advanced (, macOS 10.13.6. I have a field (text, indexed, not global) that is searchable" (green) in Quick find. When I enter a Quick find in the form of subdomain.domain.com , I get 16 found records, but a particular record (in the form of server.subdomain.domain.com ) is not in the found set. When I do a (regular) search on the field of interest (using subdomain.domain.com ), I get 16 found records, but again, does not inlcude the particular record of interest, in the form of server.subdomain.domain.com. (Note: there is another field that contains some records with subdomain.domain.com , so that accounts part of the difference in found records). When I enter a Quick find, or a regular find (in the field of interest), in the form of server.subdomain.domain.com , the record of interest is found. I've used copy and paste, so I'm not incorrectly typing information. Help reads: "If you type more than one word in the search box, FileMaker Pro searches for records that have all of the words you typed." but I'm not seeing that as a cause for server.subdomain.domain.com not working in Quick find. thanks
  9. I arrived at a solution that is working now. The problem I was trying to solve: I have a field containing a bar code number, and want to have a find executed against the data, but if the first two characters of the barcode were "AB", to strip those off before executing the find. The solution: Use a custom dialog box with user input to scan the barcode; store the results in a global field; run an If statement, and if the first two characters are "AB", set a variable to the value minus the left two characters; perform a find using that variable. --------- Following is what I tried before the working version. I'm leaving it here mainly because I'm still trying to understand more (in my general FileMaker knowledge) about PROBLEMs 1 & 2 (#3 has been solved by using the custom dialog with user input, etc.). But since I have a working solution, only have a look if interested. thanks I have a field containing a bar code number, and a button that runs a script to perform a find on that field, where the user scans the bar code, and the scanner returns the number plus a carriage return (I have the scanner programmed that way) to execute the find. When there is a record with a bar code label whose number below the bar code itself matches (e.g., "20154673"), the following script works just fine. Enter Find Mode [ Pause: Off ] Go to Field [ Select/Perform ; hardware::id_num_org ] # At this point, the bar code is scanned, and the CR # triggers the find. However there are some barcodes begin with "AB" which are not to be used in the records (business rules). When using "Enter Find Mode [Pause: Off ], "Go to Field [ Select/Perform ... " is then executed before the barcode is entered; if pause is On, the user has to manually select the field to enter in (unless there was an active record, and the target field was active) -PROBLEM 1. If a record is not found due to the leading "AB", the "No records match this criteria" dialog is suppressed (as I want with error capture on), but the error code returns "0", not "401"—UNLESS I use "Perform Find [ Restore ]" with the criteria being data beginning with "AB", but of course the data being searched on is derived from the barcode scan. -PROBLEM 2. (Note: I simplified debugging of the error code by temporarily commenting out the If structure, and placing a custom dialog at the end of the script, using "Get Get ( LastError )" ) . Once I can (hopefully) get into the If structure OK, how can I modify the data that was input during the search? I have the code for "Set Field" (or similar) worked out, but don't know how to capture the input data into a variable, or what have you. -PROBLEM 3. Following are the basics of the script so far: Set Error Capture [ On ] Enter Find Mode [ Pause: Off ] Go to Field [ Select/Perform ; hardware::id_num_org ] If [ Get ( LastError ) = 401 ] # I only want to run the steps inside the following # If statement if the scan begins with "AB"; # not if there simply is no record for the barcode. If [ Left ( hardware::id_num_org ; 2 ) = "AB" Modify Last Find # I think in order to not require the user to # rescan if we get to this If statement, that I may # need to capture the scanned input into a variable. # That is yet another thing to work out. Set Field [ hardware::id_num_org ; Right ( hardware::id_num_org ; Length ( hardware::id_num_org ) - 2 ) ] End If End If Set Error Capture [ Off ] I tried using Perform Find [ ] , but didn't see a way to pass the scanned barcode using criteria for "Specify Find Requests".
  10. It appears I cannot force a line break in a Category Label of a pie chart using the pilcrow "¶". I just wanted to confirm that, or perhaps find out I'm doing something wrong. I've only included one of the case conditions here, for brevity. The label otherwise is performing as expected. thanks Case ( investments::asset_type_all_weather = "bonds_intermed_US" ; "bonds, US, intermediate term (7-10 year) | TARGET: 15%." & "Target = $" & Truncate ( .15 * $$total_value_g ; 0 ) & ¶ & "Actual vs. target $" & Truncate (investments::asset_type_allocated_vs_actual_US_bonds_int ; 0 ) ; )
  11. A Quick Find criteria of C02LPLV5F5N7 was getting a hit of a (numeric-type) field value of: H002557. A second pair of eyes noted that if you remove letters in the criteria, there was a string of 02557, which matched part of the field's value. The field should have been converted to a text field (after the inclusion of a letter (H) at the beginning of a serial number used in a key field), and more so, that field should not have been included in Quick Find results. Problem(s) solved.
  12. When I attempt to 'learn' a word, "Learn" is greyed out. The dictionary I have selected is: /Applications/FileMaker Pro 16 Advanced/Extensions/Dictionaries/User.upr . When I attempt to edit that dictionary, I get: "The User Dictionary file is Read Only." The permissions are: -rwxrwxr-x 1 root wheel 47 Jun 14 12:16 User.upr FileMaker Pro 16 Advanced, I compared the permissions on the files in Dictionaries with a colleague's (he has the same version of FM), and they are identical, however he is able to Learn a word and edit his dictionary. I also can't create a new dictionary in that folder. I checked permissions on each directory, and nothing appears to be wrong. drwxrwxr-x+ 170 root admin 5780 Dec 4 09:52 Applications drwxrwxr-x 10 root wheel 340 Oct 13 09:47 FileMaker Pro 16 Advanced drwxrwxr-x 6 root wheel 204 May 28 2017 Extensions drwxrwxr-x 17 root wheel 578 Dec 4 13:37 Dictionaries I ran repair disk permissions with Disk Utility.
  13. Attached is the file, stripped down to the essentials. Full Access: admin admin data_entry access: sally sally (I created two re-login scripts with buttons in the file.) It is the "sally" account that the problem has been happening with, but I'm unable to replicate in FMP13 Advanced (I've not been able to have my hosting person set this up with Web Direct; I don't know if Web Direct has any bearing on the issue though; my hunch is that it does not). thankshardware.fmp12.zip
  14. The reason for duplicating is because we have several dozen computers all with the same specs, location, etc. Probably 20 fields with data that remains the same. The only difference is we need to enter a different inventory tag number and serial number, and those are both blanked (set to "") by the duplication script. The field in question is a computer's serial number (nothing to do with the primary key serial number, in which we do use auto enter serial ID, and there's no problem with that -- sorry for not being more clear on that!). File will be uploaded shortly...
  15. > I don’t like the word Duplicate? Could duplicating a record have any potential bearing on this behavior, which occurs after the record is created (by duplication)? The duplication script is the following (plus setting a number of other fields to "" ): Show Custom Dialog ["Duplicate Record. ""You've asked for the record to be duplicated. Click 'OK', then hang on a moment."] Duplicate Record/Request Set Field [hardware::serial_num; ""] Go to Field [hardware::id_num_org] Show Custom Dialog ["Your Duplicate Record command is now complete. Be sure to enter the tag number and serial number." > Why not attach a copy of your file? It's hosted by someone else. I've asked for a copy of the database. thanks
  • Create New...

Important Information

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