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. You are correct about what I'm after. I overlooked the fact that Set Field[] uses the currently selected field (when no field is specified). This is so much cleaner. Thank you very much.
  2. That was my initial attempt, but when selecting "Specify target field", then clicking "Specify...", I did not see a way to programmatically set the field name. Good to know it works in v.18, thanks.
  3. What you wrote makes total sense in general, but it piqued my curiosity about this particular script step. Get ( ActiveFieldName ) returns the name of the field that has focus, and Get ( ActiveFieldContent ) returns the contents of the field that has the focus. My hunch is that when this script step completes execution, that no ID nor content is stored in relation to the script step. Thus (IMO) when this generic script is copied and pasted into another file, it should remain exactly as written, for consistency. If, however, data specific to the last execution of the script *is*
  4. macOS 10.13.6. FileMaker Pro Advanced In a solution "A" on my computer, I created a script as follows, to remove any non (field) default formatting in effect on a selected field. I used this method: "If no field is specified and a field is selected in Browse mode or Find mode, that field is used." The script works as expected: Set Field By Name [ TextFormatRemove ( get ( ActiveFieldContents ) ) ] During testing, I've saved the script in solution "A", and even quit FileMaker and reopened the two solutions. When I copy the script and paste it into solution "B
  5. 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 multip
  6. 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 lat
  7. 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.
  8. 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
  9. 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 en
  10. 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.
  11. 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 wit
  12. 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
  13. 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::as
  14. 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.
  • Create New...

Important Information

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